SEO position and content decay watch
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.
Try
- 1Google SheetsRead rowsReads the 'Rank history' tab to find each query's most recent earlier reading to compare this week against.
If a step fails
- 2Google SheetsCreate tabCreates the 'Rank history' tab on the first run, when there is no history to read yet.
- 1
If not
historyHasHeader- 3Google SheetsAppend rowAppends a header on a new tab, then one row per query each week with its position, ranking URL 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 one line 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 query your pages are meant to rank for, and where your site sits is compared against the last check. Each reading, with the position, which of your URLs ranked, who holds the top spot and who holds the answer box, goes into a Google Sheet as a rank history.
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 fetched 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 currently contains, and posts a specific recommendation grounded in that evidence as a thread under the summary.
You need your domain, a list of pages with the query each targets, an empty Google Sheet and a Slack channel.
You May Also Be Interested In
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.LinkedIn content idea generatorEvery morning, turns the news logged in your sheet into LinkedIn post ideas for your area of interest, emails them, and clears the sheet.Nurture leads with a personalised articleEach day, picks an article for every lead due one, by their interests and stage, writes a personal note around it and emails it.
Start from a workflow that already works.
Add "SEO position and content decay watch" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required