Search Consolein GoogleSheets.
A free add-on that pulls every row Search Console has, plus Core Web Vitals, URL inspection and sitemaps, straight into your sheet.
Four tools in the sidebar
Open SEO Sheets from the Extensions menu, pick a tool and the data lands in a new tab.
Search Analytics
reports
Twelve reports you can add to a Search Analytics query. Each one gets its own tab, built from the same data.
Click a report for an example.
Questions
Is it free?
Yes. Every tool and report is free for everyone. There are no plans, trials or accounts.
Where does my data go?
Straight from Google's APIs into your own Google Sheet. We don't store anything: no accounts, no usage logs, no API keys.
What do I need?
A Google account with at least restricted access to a Search Console property. Chrome UX Report requests also need a free Google Cloud API key, which you paste in each time.
Are there limits?
The ones that remain come from Google: the Search Console API returns at most 50,000 rows per day per search type, Search Console keeps 16 months of data, and a Google Sheet holds 10 million cells.
Can I schedule reports?
Not at the moment. Scheduled reports and email notifications are switched off. Run a report from the sidebar whenever you need fresh data.
Pull yourdata.
Install from the Google Workspace Marketplace. Then open any sheet and go to Extensions → SEO Sheets → Show sidebar.