Help & Support
Send Feedback
Search Analytics for Sheets
Retrieve data and create automatic backups from Google Search Console™ into Google Sheets™.
3,487 users
Works with
Install
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 Google Sheets limit of 2 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

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.
Reviews
Priit Kallas
May 30, 2019
Very useful to get Search Console data into Sheets.
Submit reply
Cancel
Alex Corral
May 29, 2019
Good functionality and relatively quick support replies.
Submit reply
Cancel
A User of Search Analytics for Sheets
April 11, 2019
Great tool, only one feature missing: to add datas after an existing dataset
Submit reply
Cancel
A User of Search Analytics for Sheets
December 29, 2018
Very helpful and easy. Thank you!
Submit reply
Cancel
A User of Search Analytics for Sheets
November 24, 2018
why does the "group by" search appearance not work for me
Submit reply
Cancel
Joseph Robison
November 4, 2018
This add-on is so amazing and critical to my SEO work. I can't believe it's free. Aside from Ahrefs and Search Console itself, this is probably my most useful tool for doing SEO. It's that important. Only suggestion would be to see an update log for the plugin so I'm aware of the changes, since I didn't know we now have 16 months of data!
Submit reply
Cancel
A User of Search Analytics for Sheets
August 7, 2018
Best Search Analytics Add-on EVER! Easy to use. Embedded step-by-step help. Add hoc AND automated exports. I had been using the freemium super metrics data connector in google data studio for my backups because it had the higher limits before SAS did. But just recently, they changed the terms and required a subscription fee. So, you can imagine my sheer delight when I came back to SAS and found the new 25,000 rows per query and 16 month data access. Thank you for keeping this add-on up to date. It is a great service to the entire seo/web community, especially nonprofit orgs like us.
Submit reply
Cancel
A User of Search Analytics for Sheets
April 24, 2018
Excellent add-on. Setting up the daily backup is ideal
Submit reply
Cancel
A User of Search Analytics for Sheets
January 17, 2018
Fantastic plug-in, allowed me to store historical data from Search Console, and I mean, the whole data! No limits! And also, Mihai helped me to figure out a little problem... very responsive and helpful. Thank you again Mihai!
Submit reply
Cancel
A User of Search Analytics for Sheets
November 22, 2017
Been using for a while, this plugin is exceptionally useful. Very reliable. And absolutely superb support from Mihai the developer.
Submit reply
Cancel
1-10 of 31
Additional information
Search
Clear search
Close search
Google apps
Main menu