Weekly search performance export to Sheets
Appends last week's top search queries, clicks, impressions and average position to a Google Sheet every Monday.
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 SheetsCreate tabCreates the 'Search performance' tab in your sheet on the first run and leaves it alone once it exists.
If
tabIsNew- 2Google SheetsAppend rowWrites the header on a new tab, then appends one row per query: week dates, clicks, impressions, CTR and position.
- 2
For each
searchRowIf
queryTextis not empty- 3Google SheetsAppend row
- 3
How it works
What happens on each run, in plain English.
Every Monday at 08:00, last week's search performance for your site is pulled from your search analytics endpoint and appended to a Google Sheet, one row per query, so the trend builds up week after week without anyone opening a console.
Each row records the week it covers, the query, clicks, impressions, CTR and average position, written as real numbers and dates so you can chart any column straight from the sheet. It reads the seven full days ending three days before the run, because search consoles finalise a day's figures on a lag. The first run creates the tab and writes the header; every run after that only appends, so history is never overwritten. A week with no data stops cleanly and leaves the sheet alone, and a result with no query text is logged and skipped rather than ending the run.
You need an access token for your search analytics endpoint and a Google Sheet to hold the history.
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.
Fill a spreadsheet with a ChatGPT-written list every hourEvery hour, has ChatGPT write a fresh batch of the list you describe and adds each item as a row in your Google Sheet.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.Get LinkedIn post ideas from the news in your sheetEvery morning, turns the news logged in your sheet into LinkedIn post ideas for your area of interest, emails them, and clears the sheet.Start from a workflow that already works.
Add "Weekly search performance export to Sheets" to your workspace, connect its apps, and make it yours.
Free plan, no credit card