Retrieve data and create automatic backups from Google Search Console™ into Google Sheets™.
Listing updated:November 9, 2022
Works with:
186K+
Overview
Search Analytics for Sheets allows you to:

1. Retrieve query, page, clicks and other data on-demand for any of your verified websites from Google Search Console's Search Analytics directly into Google Sheets.

- supports grouping and filtering data by "Query", "Page", "Country" and "Device"
- offers data on "Clicks", "Impressions", "CTR" and "Position"
- no limit on how much data can be pulled (only limited by the available data and the Google Sheets limit of 5 million cells per spreadsheet)

2. Create automatic data backups in Google Sheets

- backup daily or monthly Search Analytics data for any site or property set in its own spreadsheet
- create unlimited number of backups
- create both aggregated-data backups as well as grouped/filtered backups

Visit https://searchanalyticsforsheets.com for full documentation of what the add-on can do.


CHANGELOG

2022-07-21: Version 90

- Added concurrent API requests for faster URL Inspection calls

2022-07-21: Version 87

- Fixed small issue preventing the URL Inspection checkbox from showing up

2022-07-19: Version 86

- Added URL inspection, append, Sheets API and batching

2021-11-26: Version 67

- Added News Tab, Google News and Discover search types, as well as the ability to fetch fresh data and use regex within filters

2021-11-23: Version 66

- Added ability to request custom amount of rows

2020-03-13: Version 56

- Added search bar for site dropdown

2019-10-30: Version 55

- Fixed backups not getting deleted automatically

2019-10-27: Version 54

- Disable backup on most errors

2019-04-04: Version 49

- Added handling multiple signed in accounts issue and domain properties

2018-07-26: Version 48

- Added the new 25,000 row limit per query

2018-06-22: Version 44

- Now includes the full 16 months range of data available to request

2017-10-22: Version 37

- Now works with property sets as well!

2017-09-08: Version 36

- Upgraded to the latest OAuth library

2017-06-01: Version 35

- Added daily backups!

2016-11-13: Version 29

- Added Google Analytics tracking code

2016-31-10: Version 25

- Fixed newsletter subscription from notification.

2016-31-10: Version 24

- Added notification for new version.

2016-31-10: Version 23

- Added option to retrieve more than 5000 rows. 'Cleanified' code to make it easier to add new features later.

2016-08-13: Version 11-16

- Tested and fixed authorization bug when property sets are present.

2016-06-09: Version 10

- Fixed small issue during authorization.

2016-06-08: Version 9

- Fixed small issue causing backup cycles to execute every day.

2016-06-06: Version 8

- Fix to backups not running due to trigger not being executed.
- Added the ability to run a backup cycle right away when activating the backup.

2016-05-17: Version 7

- Small fix for a notification that showed up if the user wasn't authorized.

2016-05-16: Version 6

- Small fix to issue that caused backups to run every day, despite completing successfully.

2016-05-15: Version 5

- Fixed MAJOR issue with fetching available date ranges from Google Search Console. If you had issues authorizing the add-on until now, this should fix it.
- Added the ability to view all active backups (the spreadsheets where backups have been created with your current user account) in the 'About' tab. This will only work with backups created started with this version.
- The backup option that allows you to save aggregated data as well no longer applies filters. You'll notice that the sheet name containing this data will change as well (starting with the next backup cycle).
- You can now subscribe to be notified by future updates via e-mail using the Subscribe button in the 'About' tab.
Additional information
PricingFree of charge with paid features
Developer
Privacy policy
Terms of service
Search Analytics for Sheets will ask for the permissions shown below. Learn more
Search Analytics for Sheets will need access to your Google account
This will allow Search Analytics for Sheets to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
View Search Console data for your verified sites
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Sharizan Abdullah Sonny
March 18, 2024
Amazing tool, but I sometimes get this error message: "Requesting data failed due to the following error: Error: Error writing data: API call to sheets.spreadsheets.values.append failed with error: Request range[sheet1] does not match value's range[sheet1]. I have no idea what I'm doing wrong. I never change my behaviour when using this, but I sometimes get this issue.
Is this review helpful?
Yes
No
Profile Picture
Nazım Kopuz
November 10, 2023
One of my favorite tools as an SEO advisor. If you've ever wanted to delve into Google Search Console data beyond the limited 90-day window, your wish is granted with the remarkable Search Analytics for Sheets add-on. With a seamless addition to Google Sheets and a quick authorization with GSC, you're ready to expand your analysis beyond typical limitations.
Is this review helpful?
Yes
No
Profile Picture
Paul Baterina
August 14, 2023
The filtering of country doesn't seem to be working properly. I typed United States, and even united states and got 0 results. Please advise. And yes, our main business is United States
Is this review helpful?
Yes
No
Profile Picture
Abdollah Zamani
January 29, 2024
nice
Is this review helpful?
Yes
No
Profile Picture
Mantas J
April 10, 2023
Anyone facing issue with wrong data pulled? I wanted to pull report with "query" and "pages" nothing else changed. The report generated, but keywords mapped to wrong pages. Any advice on this?
Is this review helpful?
Yes
No
Profile Picture
edit
August 3, 2022
This is a fantastic add-on - absolutely a life-saver. The Google Search Console UI is great but highly limited, especially when pulling down granular data at the keyword level etc. This tool let's us get a ton of data on a regular basis with next-to-no set up. Developer has been helpful anytime I needed support - many thanks!
Is this review helpful?
Yes
No
Profile Picture
Analytics Access
December 6, 2021
This add-on is a must have for any agency or smb looking for more of their keyword or url specific data that was previously limited via GSC. It's also great to be able to see the keyword by page results as that adds an additional layer to analyze.
Is this review helpful?
Yes
No
Profile Picture
Olivian Breda
August 23, 2021
Mihai A. knows his way around both SEO and programming. Very useful app, I wholeheartedly recommend it. If you need data from Google Search Console into Google sheets (who doesn't?), this app can help.
Is this review helpful?
Yes
No
Profile Picture
Paulos Raja
July 6, 2021
Dear Team First I would like to thank you all for this wonderful tool. But I have one issue, the date / period selection function not working properly. I selected for only one month, but result shows for more than 12 months or one year.
Is this review helpful?
Yes
No
Profile Picture
A User of Search Analytics for Sheets
October 23, 2019
This is great. Works really well. My backup is only giving me a single line of aggregate data. Is this by design? If so, would be great to be able to select, 'run as backup' when creating a 'request'. Also, would be REALLY helpful to: 1. Have multiple backups (ex: for different sites) 2. Have the ability to overwrite data in a tab with your backup
Is this review helpful?
Yes
No
1-10 of 73
Search
Clear search
Close search
Google apps
Main menu