How to connect Google Search Console to Google Sheets

An analyst at her desk watches data flow from a magnifying glass with bar charts into a spreadsheet

Search Console shows how your site is doing on Google, but it has two limits you'll run into sooner or later: the screen only shows 1,000 rows, and data older than 16 months is deleted. Moving it into Google Sheets fixes both, and lets you run analyses the report can't: grouping queries, comparing pages and spotting opportunities.

This guide covers three ways to do it, from the simplest to the most complete, and what to look at once you have the data.

If you don't use Search Console yet, start with how to use Google Search Console.

Option 1: export from the report (two clicks)

Two windows, one with a line chart and one with a spreadsheet, and an arrow carrying data from one to the other

It's the fastest option and there's nothing to install.

  1. Open Search Console and go to Performance → Search results.
  2. Pick the date range and any filters you want (for example, only the United States, or only mobile).
  3. Click Export in the top right.
  4. Choose Google Sheets.

A new spreadsheet is created in your Google Drive with one tab per table: queries, pages, countries, devices, search appearance and dates.

Limit: each table holds up to 1,000 rows. That's usually enough for a small business; for a site with many pages or queries, it falls short.

Tip: use the date Compare mode before exporting (say, this month versus the same month last year). The sheet gets both columns side by side.

Option 2: a Google Sheets add-on

To pull more rows, combine queries and pages in one table or keep automatic backups, use an add-on. The best known is Search Analytics for Sheets, which is free (it isn't made by Google, but it's widely used in the industry).

  1. In a Google Sheet, go to Extensions → Add-ons → Get add-ons.
  2. Search for "Search Analytics for Sheets" and install it with the same Google account that has access to Search Console.
  3. Open Extensions → Search Analytics for Sheets → Open Sidebar.
  4. Choose the site, the dates and how to group the data (by query, by page, or both).
  5. Click Request Data.

Automatic backups: the add-on's Backups tab can save a monthly copy on a schedule. That keeps your history beyond the 16 months Google stores. If you do just one thing from this guide, make it this.

Option 3: the API (for large sites or automated reports)

The Search Console API returns up to 25,000 rows per request and can combine dimensions like query, page, country and device. You can call it from Google Apps Script, inside the same sheet, so a report refreshes itself every week.

It takes some coding. It's worth it if you run a site with hundreds of pages or prepare reports for several clients. For most businesses, options 1 and 2 are enough.

There's also the Looker Studio connector, which sends the data to a dashboard with charts rather than to a sheet. It's good for keeping an eye on things; for digging into the details, a sheet is still more practical.

What to analyze once you have the data

An advisor shows a business owner a spreadsheet with one highlighted row and a rising bar chart

Getting the data is half the job. These are the analyses that lead to the most decisions:

Queries just short of page one

Filter for queries with a position between 8 and 20 and sort by impressions. Google already considers you relevant for these, just not relevant enough. Improving that page (more complete content, a better title, more internal links) usually pays off faster than writing something new.

Pages with lots of impressions and few clicks

If a page shows up often but almost nobody clicks, the problem is usually the title or description. See titles and meta descriptions that get clicks.

Brand versus non-brand queries

Add a column that flags whether the query includes your business name. In Sheets: =REGEXMATCH(A2, "yourname|your name"). That separates people who already know you from people who find you through what you sell, which is what SEO really measures.

Several pages for the same query

With data grouped by query and page, look for queries where two or more of your pages appear. It can be a sign they're competing with each other; we explain it in duplicate content and canonical tags.

Comparing periods

Compare a month with the same month last year, not with the month before. Most businesses have seasons (holidays, high season, rainy season) that skew month-to-month comparisons.

To decide which numbers to watch and how often, see how to measure SEO results.

Common mistakes

  • Exporting once and never again: the value is in comparing over time.
  • Analyzing only the first 1,000 rows of a large site and drawing site-wide conclusions.
  • Mixing filtered and unfiltered data (one month with all countries, another with only one).
  • Waiting until you need the history to start saving it.

Frequently asked questions

Is it free to connect Search Console to Google Sheets?

Yes. Exporting from Search Console, the Search Analytics for Sheets add-on and the API are free for normal business use.

Why don't the totals in my sheet match the report?

Google hides some rare queries for privacy, and tables have a row limit. So the sum of the rows is usually lower than the total in the chart. That's expected.

How often should I export the data?

Once a month is enough for most businesses. With a monthly automatic backup, you don't have to remember.

Can I give my agency access without sharing my password?

Yes. In Search Console, under Settings → Users and permissions, you can add someone with restricted (read-only) access.

Want someone to go through this data for you?

In our SEO audit we analyze your full Search Console history and hand you a plan with what to fix first. See our prices or get in touch.

Get your SEO plan

What do you need?

We reply on WhatsApp or by email. We never share your details.

Rather talk first? Book a free video call or price your project.

Keep reading