Search Console data in Google Sheets, refreshed on a schedule
Queries, pages, clicks and position written into a tab you choose, and current before you open the file. Fresh Sheets only reads your Search Console property.
30 days of Plus, free from sign-up. No card needed.
Sign in with Google or a work or school Microsoft account.
What you can pull from Search Console
Every dimension and metric the Search Console API offers for daily data. Not a subset and not a list we curated: this is all of it, so all of it is here.
Any report can be filtered: up to five conditions, all of which have to match, on query, page, country, device or search appearance. No regular expressions.
This morning's queries, already in the tab
Search Console, written to Top queries
- Each report owns a tab, and everything in it is replaced on every refresh. Nothing else in the spreadsheet is touched.
- It runs whether the spreadsheet is open or not. Refreshes happen on our servers, so the numbers are current when you open the file, not when you remember to.
Want it in BigQuery as well? See Search Console to BigQuery.
Prefer Microsoft Excel? See Search Console to Excel.
Want to ask Claude about it instead? See Search Console in Claude.
Google Search Console to Google Sheets, in three steps
- Connect the account and pick which one to read from.
- Pick the site, then the fields. There are ten and you can see all of them at once.
- Choose the tab, worksheet or table it writes to, and how often it refreshes.
Try it with your own Search Console data.
30 days of Plus, free from sign-up. No card needed.
Sign in with Google or a work or school Microsoft account.
Other ways to do it
Search Console can export a report to Google Sheets, Excel or a CSV file.
Source: Search Console Help: Export report data; Google Search Central blog: data export
That makes a new file each time. Fresh Sheets writes the figures into a tab of the spreadsheet you already use.
What it can see, and what it cannot
Fresh Sheets reads Search Console through webmasters.readonly, Google's own read-only permission for it. Google publishes a separate permission for changing a property, and the permission to do so is never requested, so it cannot be granted by accident.
Every connector Fresh Sheets ships is read-only, permanently. That is a design decision rather than a current limitation, and it is set out in our privacy policy.
In Excel, writing happens only in the worksheets your reports use, in workbooks you choose or ask Fresh Sheets to create. Fresh Sheets never changes anything you did not ask it to.
Your data is never sold and never used to train anything, and you can disconnect the account at any time.
Fresh Sheets asks for all of its data permissions in one consent screen, so you will see Google Analytics and Google Ads listed there even if you only connect Search Console. Every scope is set out in full on our privacy page.
How we handle your dataStart on Plus, and decide later
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.
Questions
Can you export Search Console data to Google Sheets?
Yes. Search Console can export to a new spreadsheet, and Fresh Sheets can write into one you already have, in a tab you choose, on a schedule, without the file being open.
How far back does the data go?
Sixteen months, which is Google's own retention window for Search Console. Fresh Sheets can read any range inside it.
Why isn't today in the report?
Fresh Sheets only reads data Google has finalised, so figures don't shift after they land.
How many rows can a report have?
Google returns up to 50,000 rows a day, and Fresh Sheets writes up to 125,000 a run. A report that would return more stops at 125,000 and tells you how to bring it under, and nothing is written for that run.
How often can it refresh?
Choose the schedule when you build the report, and it runs on our servers from then on. How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.
Can I report on more than one site?
Yes, one property per report, and several reports can write into different tabs of the same spreadsheet.
Does it change anything in Search Console?
No. Fresh Sheets reads Search Console through Google's own read-only permission, so it cannot submit, remove or alter anything in your property.
Set up your first Search Console report
Connect the site, pick your fields and a tab, and leave it running.
30 days of Plus, free from sign-up. No card needed.
Sign in with Google or a work or school Microsoft account.