To update the Blue Font job board, I run the LinkedIn Job Scraper Skill every Friday. I thought the scraping from LinkedIn and filtering were going to be my biggest obstacles — I was unfortunately wrong.

It turns out updating a simple Google Sheet with new data is the big kahuna. Here’s why and how to navigate around this.

The 🚩

Claude's Google Drive connector can do many things: it can create a file. It can copy a file. It can read one.

But what it can't do is edit (or write into) an existing file or write into. This is a red flag if I’ve ever seen one.

I went looking for a dedicated Google Sheets connector to route around it. This doesn't exist yet either (checked this August — the nearest things in the registry were Smartsheet and Tiller, neither of which is the thing I wanted).

What that forces

There’s a workaround: the Google Chrome Connector. It works by taking control of your browser, navigating to the Google Doc, and editing it just as you would manually. Pretty rad, right?

That makes installing Google Chrome in addition to the connector a requirement, not a nice-to-have, for a "one running sheet" setup.

While this sounds like a clean workaround, there is a caveat: Cowork scheduled tasks normally run in the cloud and fire whether or not your machine is awake. But a task that needs local resources has to run locally instead, and browser control counts: Claude in Chrome drives the Chrome window on your computer. So Friday's run requires my Mac to be awake, the Claude desktop app open, and Chrome running and signed into Google.

Running it

Here's what the actual weekly pull looks like end to end:

First, ensure the computer is online, awake, and signed into chrome. The Claude Desktop App has a “Stay Awake” feature in the “Schedule Tasks” section for this exact purpose.

Claude scrapes LinkedIn through Apify, filtered down to the roles and location specified/ Before writing anything, it reads what's already in the sheet.

Each job gets a dedupe key — company plus title, so a role that's already logged doesn't get re-added just because LinkedIn reposted it under a fresh listing ID. Then it's the browser's turn: Claude switches to Chrome, selects the sheet, and pastes the new rows in below the existing ones.

And wallah, you’ve edited an existing Google sheet!