Every SEO report starts with the same chore: get the Search Console numbers into a sheet. Here are the three ways to do it, with the steps and the limit of each.
How do I send Search Console data to Google Sheets?
There are three ways. Export the Performance report to Google Sheets by hand, up to 1,000 rows at a time. Automate it for free with an add-on such as Search Analytics for Sheets, or an Apps Script that calls the Search Console API on a weekly trigger. Or let an AI coworker such as Patricia build the report.
The manual export is fine for a one-off check. If you report on a property every week, or on ten client properties every month, pick a route that runs on its own. Every limit below comes from Google's own help and developer pages, or the add-on's own site.
Checked on 18 November 2026The three routes at a glance
| Route | Cost | Rows | On a schedule | Best for |
|---|---|---|---|---|
| 1. Export by hand | Free | Up to 1,000 per export | No | A one-off check |
| 2a. Search Analytics for Sheets | Free plan, paid plans for more rows | More than the interface, through the API | Daily or monthly | Teams that live in Sheets |
| 2b. Apps Script and the API | Free | Up to 25,000 per request, 50,000 a day per search type | Any time-driven trigger, weekly included | Someone who can maintain a script |
| 2c. Looker Studio | Free connector | Reads Search Console directly | Live report, no sheet | A client-facing chart |
| 3. Patricia | Credits, on the Agency plan | Dashboard tiles download as CSV | Dashboards refresh; Sheets writes on request | Agencies with many client properties |
Row limits per Google: 1,000 for an export from the interface, and for the API, up to 25,000 per request and 50,000 a day per search type per property.
Route 1: export the Performance report by hand
- Open Search Console and pick the property.
- Open Performance, then Search results.
- Set the date range, then any filters: query, page, country, device or search appearance.
- Pick the table tab you need: Queries, Pages, Countries, Devices or Dates.
- Click Export at the top of the report and choose Google Sheets. Microsoft Excel and CSV are the other two formats.
Where it stops: Google's help page says an export is "truncated to 1,000 rows of representative examples of your data", while the totals shown are the real totals. A large site has many more rows than that. Each export is a fresh file, so a weekly report means a weekly export by hand. The newest days may be preliminary: Google says collected data is usually available in 2 to 3 days.
Route 2: automate it for free
All three free routes read the same Search Console API. Pick by who will look after it.

Option A: the Search Analytics for Sheets add-on
Search Analytics for Sheets is a third-party add-on, not a Google product. Its site says it was created by Mihai Aperghis, founder of the SEO agency Vertify, and it installs from the Google Workspace Marketplace. It requests Search Console Performance and URL Inspection data into a sheet, and every plan lists unlimited daily and monthly automated requests (checked 18 November 2026).
- In Google Sheets, open Extensions, then Add-ons, then Get add-ons, and install Search Analytics for Sheets.
- Sign in with the Google account that can open the Search Console property.
- Open the add-on from the Extensions menu, then pick the property, the date range and the dimensions (query, page, date, country, device).
- Run the request once and check the rows against the Search Console chart.
- Save it as an automated daily or monthly request so the sheet fills on its own.
Where it stops: its pricing page lists a free plan "forever" and paid Pro and Unlimited plans with more rows per request. The rows per plan were listed twice with different figures when we checked, so confirm the cap on its pricing page before you rely on it. Each client property needs its own setup.
Option B: Apps Script and the Search Console API
Free, and fully under your control, if someone on the team can read a script. The function below calls the Search Console API over HTTP with UrlFetchApp, and passes the token of the person who runs it, a method Google's ScriptApp reference documents.
- In the sheet, add a tab called
GSC, then open Extensions, then Apps Script. - In Project Settings, tick Show "appsscript.json" manifest file in editor, then add the scopes below to the manifest.
- Paste the function below and change
sc-domain:example.comto your property. A URL-prefix property looks likehttps://www.example.com/. - Run it once and approve the access Google asks for. If the run fails because the Search Console API is not enabled, link the script to a Google Cloud project with that API turned on, in Project Settings.
- Open Triggers, click Add Trigger, choose the function, a time-driven source and a weekly timer, then save.
The scopes for appsscript.json:
"oauthScopes": [
"https://www.googleapis.com/auth/webmasters.readonly",
"https://www.googleapis.com/auth/spreadsheets.currentonly",
"https://www.googleapis.com/auth/script.external_request"
]The function: it reads the last 7 days of finished data, by query and page, and appends one row per query and page with the date range in front.
function pullSearchConsole() {
const site = encodeURIComponent('sc-domain:example.com');
const fmt = (d) => Utilities.formatDate(d, 'UTC', 'yyyy-MM-dd');
const end = new Date(Date.now() - 3 * 864e5);
const start = new Date(end.getTime() - 6 * 864e5);
const res = UrlFetchApp.fetch(
'https://www.googleapis.com/webmasters/v3/sites/' + site + '/searchAnalytics/query',
{
method: 'post',
contentType: 'application/json',
headers: { Authorization: 'Bearer ' + ScriptApp.getOAuthToken() },
payload: JSON.stringify({
startDate: fmt(start),
endDate: fmt(end),
dimensions: ['query', 'page'],
rowLimit: 25000,
}),
}
);
const rows = (JSON.parse(res.getContentText()).rows || []).map((r) =>
[fmt(start), fmt(end), ...r.keys, r.clicks, r.impressions, r.ctr, r.position]
);
if (!rows.length) return;
const sheet = SpreadsheetApp.getActive().getSheetByName('GSC');
sheet.getRange(sheet.getLastRow() + 1, 1, rows.length, rows[0].length).setValues(rows);
}Where it stops: the API returns at most 25,000 rows per request, and Google's Search Central blog puts the ceiling at 50,000 rows per day per site per search type, paged with startRow. Google also says the API "does not guarantee to return all data rows but rather top ones". The script runs as the person who set the trigger, so when they leave the agency, it stops. Someone has to fix it when Google changes something.
Option C: Looker Studio, when the chart is the goal
If the sheet only exists to feed a client chart, skip the sheet. Looker Studio has a free Search Console connector: choose Create, then Data source, pick Search Console, authorize, then pick the site, the table and the search type, and click Connect. Google's page offers two tables, Site Impression (data by site) and URL Impression (data by page), and one data source uses only one of them, so add two data sources for both views.
Route 3: Patricia, an AI coworker that reads Search Console for you
Patricia is an AI coworker for small agencies that works in Slack and Microsoft Teams. Connect Search Console and Google Sheets once, then ask her for the numbers, the report or a dashboard in the channel.
- What she reads. Through the Search Console connector, the verified properties you connect, with one OAuth click: queries, clicks, impressions, CTR, average position, indexing status and sitemaps. Reading changes nothing in the property.
- Dashboards, in public beta. Ask for a Search Console dashboard for a client. A dashboard reads up to 20 sources and refreshes when you open it if the data is more than 12 hours old. Every tile has View data and Download CSV, and the CSV opens in Google Sheets or Excel. A scheduled task can refresh a dashboard and tell you what changed.
- Google Sheets. Through the Google Sheets connector she can append rows, update a tracker or build a report sheet when you ask. By default, appending and updating wait for your yes, and so does clearing or deleting.
- The report. She writes what moved in plain words for the client channel: queries close to page one, pages losing clicks, indexing issues. See what Search Console and Google Sheets do together in Patricia.
- Where it stops. The numbers are still Search Console's: the same 2 to 3 day delay and the same anonymized queries left out. Dashboards are in public beta. We do not claim a fully automatic weekly write into a Google Sheet today: download the CSV, or ask her to write the rows.
- What it costs. $195 a month per workspace, every seat included, with 95,000 credits a month. Work is billed in credits: BetterPic's monthly client report used about 613 credits (about $1.38) in October 2026.
Which route should you pick?
- One site, once in a while: route 1. It takes a minute.
- One or two sites, every week, a team that works in Sheets: the add-on, or the Apps Script if you want no third party in between.
- A client report with charts: Looker Studio, straight from Search Console.
- Many client properties, and someone has to explain what moved: an AI coworker such as Patricia, so the numbers arrive with the reading of them. If you also pay for a rank tracker, read Semrush vs Google Search Console to see why the two disagree.
Why your sheet will not match the Search Console chart
- Anonymized queries. Google's Search Central blog says anonymized queries "are always omitted from the tables" but are included in chart totals, unless you filter by query.
- The 1,000-row cap. An export from the interface keeps 1,000 rows; the long tail is cut, the totals are not.
- Fresh data. The API returns only final data unless you ask for
dataState: "all", which adds fresh data that may still change. - Page vs property. Google's help page says impressions are combined per page when you group by page, so totals by page and by property can differ.
Write the date range on every tab, and compare totals, not row sums.
How we checked this guide
- Google, read 18 November 2026: Export data from a Search Console report, Performance report metrics, About Search Console data, Export with the Search Console API, Search Analytics query reference, Performance data deep dive, Debugging search traffic drops, Apps Script installable triggers, ScriptApp, Looker Studio Search Console connector.
- Search Analytics for Sheets, read 18 November 2026: home page and pricing.
- Patricia: the Search Console, Google Sheets and dashboard pages of this site, and BetterPic's October 2026 usage.
FAQ
How do I send Search Console data to Google Sheets?
There are three ways. Export the Performance report to Google Sheets by hand, up to 1,000 rows at a time. Automate it for free with an add-on such as Search Analytics for Sheets, or an Apps Script that calls the Search Console API on a weekly trigger. Or let an AI coworker such as Patricia build the report.
Can I connect Google Search Console to Google Sheets for free?
Yes. The export button in the Performance report saves straight to Google Sheets at no cost, up to 1,000 rows. For a free schedule, use the free plan of the Search Analytics for Sheets add-on, which lists daily and monthly automated requests, or write an Apps Script that calls the Search Console API on a time-driven trigger.
Why does my Search Console export stop at 1,000 rows?
Google caps exports from the Search Console interface at 1,000 rows. Its help page says the data is truncated to 1,000 rows of representative examples, while the totals stay the real totals. The Search Console API returns up to 25,000 rows per request and up to 50,000 rows a day per search type per property.
Is Search Analytics for Sheets made by Google?
No. Its own site says it was created by Mihai Aperghis, founder of the SEO agency Vertify, and it is installed from the Google Workspace Marketplace. It uses the Search Console API with your Google account, so it sees only the properties you can access.
Why don't my exported rows add up to the Search Console total?
Search Console leaves anonymized queries out of its tables but counts them in the chart totals, unless you filter by query. Exports are also capped at 1,000 rows. So the sum of exported rows is usually lower than the total clicks and impressions on the chart.
How far back can I export Search Console data?
Search Console shows about 16 months of Performance data. Google's guide to debugging traffic drops suggests the API or the bulk data export if you want to keep more than that, which is a good reason to append a copy to a sheet every week.
Can Patricia put Search Console data in Google Sheets on a schedule?
Patricia reads Search Console through its connector and builds the report or a dashboard. Every dashboard tile has Download CSV, which opens in Google Sheets, and she can write rows into a sheet through the Google Sheets connector when you ask; by default, that write waits for your yes. Dashboards are in public beta. She costs $195 a month per workspace, every seat included.




