Each month, find posts whose search clicks dropped, research what changed with Perplexity, and get a Claude-written refresh brief for each one.
Old posts quietly lose traffic as facts go stale and competitors publish newer guides. Content teams know they should refresh them, but working out which posts slipped and what to change takes a full day in Search Console. So the team keeps writing new posts while the old ones drain.
Create a Google OAuth credential with the Search Console API enabled and add it to n8n. Use an HTTP Request node to call `searchanalytics.query` with `dimensions: ["page"]` for the last 28 days and for the same 28 days one quarter earlier.
In a Code node, join the two periods by URL and keep pages under `/blog/` where clicks fell by 30% or more and the earlier period had at least 100 clicks. Cap the list at 10 posts per run so the team can act on all of them.
Use Loop Over Items to fetch each URL with HTTP Request, then an HTML node (Extract HTML Content, selector `article`) to keep only the article body. Run a second Search Console query per page to get its top 5 queries.
Call the Perplexity API with the `sonar-pro` model, the post title and its top queries, using the research prompt. Keep the `citations` array so every claim in the brief can link to a source.
Send the article text, queries and research to Claude with the refresh brief prompt. Set max tokens to about 1,200 so briefs stay short enough for a writer to act on.
Append a row to the `Refresh queue` sheet with URL, click change, brief and an empty owner column. Six weeks after each refresh ships, compare clicks against the flagged period before lowering the 30% threshold.
I am updating a blog post titled "{{post_title}}", first published {{publish_date}}. It currently ranks for these queries: {{top_queries}}.
What has changed on this topic in the last 12 months? Cover new product features or pricing, changed best practices, new data or studies, and anything that is now outdated. List each change as one bullet with a date and a source link. If nothing material has changed, say so plainly.You are an editor preparing a refresh brief for a writer. The post below lost {{click_drop}}% of its search clicks over the last quarter.
Inputs:
- Current article: {{article_text}}
- Queries it ranks for: {{top_queries}}
- Research on what changed: {{research}}
Write a brief with these sections:
1. Outdated claims: quote each sentence that is now wrong and give the correction with its source.
2. Missing sections: topics searchers expect, based on the queries, that the post does not cover.
3. Cut: sections that are padding or off-topic.
4. Two new title options under 60 characters and two meta descriptions under 155 characters.
Keep the brief under 400 words. Do not rewrite the article.Score every demo request against your ICP, update HubSpot and ping the right rep in Slack within a minute of the form submit.
Every new Zendesk ticket gets a category, priority and sentiment tag plus a draft reply in an internal note before an agent opens it.
Export the Descript transcript, let ChatGPT pick the five strongest moments, and get 10 platform-ready posts in a review doc within minutes.