Catch the pages slipping in Google each week
Tracks where your pages rank each week, catches the ones slipping, and says what to change on each.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads the pages to track from the 'Tracked pages' tab, and the 'Rank history' tab to compare this week against each query's last reading.
If a step fails
- 2Google SheetsCreate tabCreates the 'Tracked pages' and 'Rank history' tabs on the first run, when they do not exist yet.
- 2
If not
historyHasHeader- 3Google SheetsAppend rowAdds headings to a new tab, then one row per query each week with its position, ranking page and answer box.
- 3
For each
trackedPage- 4SerperSearch webRuns one Google search per tracked query, from a fixed country and language, to find where your site ranks this week.
- 4
For each
historyRow- 5Google SheetsAppend row
- 5
- 6SlackSend messagePosts the week's summary to your channel, then each page's recommendation as a reply in the same thread.
For each
finding- 7AnthropicGenerate model responseAsks the AI, for each slipping page, what to change, working only from the measured positions, results page and page contents.
If
recommendationis not empty- 8SlackSend message
- 8
- 7
How it works
What happens on each run, in plain English.
Every Monday at 07:00, one Google search is run for each page you list in your Google Sheet, and where your site sits is compared with the last check. Each reading, with the position, which of your pages ranked, who holds the top spot and who holds the answer box, is added to the same sheet as a rank history. The first week's Slack summary lists where each query stands.
A page is only written up when it has lost ground beyond the threshold you choose; everything else is recorded and left alone. A summary goes to your Slack channel every week, even when nothing moved. Each slipping page is opened first, because a missing page, a redirect or a noindex tag has to be fixed before any content advice matters, and then AI weighs the query, both positions, the results page around it and what the page contains, and posts a specific recommendation as a thread under the summary. If the sheet cannot be read, nothing is written; a search, a post or a write-up that fails is named and the run is marked as failed.
You need Serper, Anthropic, Google Sheets and Slack connected, your domain, a Slack channel ID, and a Google Sheet with a 'Tracked pages' tab listing each page's URL and the Query it should rank for.
You may also be interested in
Get a daily round-up of your press coverage in SlackSearches the last day's news for your brand and people, archives what it finds and posts a round-up to Slack.Hear in Slack when a competitor does something that mattersWatches your competitors across news, social and review sites, and posts to Slack only when something changes how you sell against them.
Drip helpful articles to your leadsEvery day, emails the next few leads in your sheet a random article with a short AI note, and comes back to each after a set gap.Personalised marketing emails from customer dataReads each customer's purchases and feedback, lets AI decide who earns a coupon, and sends a tailored email from Gmail.Start from a workflow that already works.
Add "Catch the pages slipping in Google each week" to your workspace, connect its apps, and make it yours.
Free plan, no credit card