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
The integration steps this workflow runs, in the order it first runs them.
- 1Google SheetsCreate tab
- 2Google SheetsAppend row
How it works
Everything the template sets up, and what to fill in before the first run.
Every Monday morning this pulls last week's search performance for your site and appends it to a Google Sheet, one row per query, so the trend builds up week after week without anyone opening a console.
It reads the seven full days ending three days before the run, because search consoles finalise a day's figures on a lag and the most recent days are still moving. 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.
The columns are fixed and named by the workflow - Week start, Week end, Query, Clicks, Impressions, CTR, Average position - so it only ever writes the figures it knows how to read. The first run creates the tab and writes that header; every run after that only appends, so the history is never overwritten and no week is lost.
To set it up, fill in the 'searchDataUrl' step with your search analytics endpoint, the 'accessToken' step with a token for it, and the 'spreadsheetUrl' step with the link to the sheet. 'sheetTab' and 'maxQueries' already have sensible defaults.
A week with no data stops cleanly and leaves the sheet alone, and a single result that comes back without query text is logged and skipped rather than ending the run.
You May Also Be Interested In
Send sentiment-aware emails with couponsEmails each customer about their purchase in your tone, reads their feedback first, and adds a coupon when the feedback is negative.
Approve the outline, then the post, then publishTakes the next topic off your content plan, asks you to approve the outline, writes the post to it, and publishes only if you say so.
What your YouTube viewers are sayingSorts the comments on your latest videos into asks, praise and complaints, and emails the counts with real quotes.
Read a whole site into spreadsheet rowsFinds the pages on a site from its sitemap or front page, reads each one, and adds a row per page to your 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. No credit card required.
Free plan available · No credit card required