Mihai Aperghis
•  21,578
Overview
Retrieve data and create automatic backups from Google Search Console™ into Google Sheets™.
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

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.
Reviews
Language:
Sort by:
A User of Search Analytics for Sheets
May 15, 2020
Would it be possible to append backup data instead of keep creating separate tabs?
Is this review helpful?
Yes
No
Pierre Laing
May 5, 2020
This plugin has stopped working, I keep getting the following error. Error: There was an issue showing the sidebar at line 518: Couldn't fetch the list of sites verified in your account, an error occurred at 450: Service invoked too many times for one day: urlfetch..Details Anyone else having problems with this plugin ?
Is this review helpful?
Yes
No
A user of Search Analytics for Sheets
May 13, 2020
I'm having the same issue & couldn't figure out a solution.
Anubhav Narula
April 29, 2020
Useful
Is this review helpful?
Yes
No
A User of Search Analytics for Sheets
April 14, 2020
Hey Mihai, here an user of this add-on for years :) Using it in so many different ways, I'm now using it with several backups across a lot of spreadsheets. Because of this, I found something that you might be interested in looking at. When you create a Daily backup (those that have less data than a monthly one for obvious reasons) and use a lot of filters (in my case, I'm doing very granular backups), if on a particular day there's no data to backup, the Backup Log generates the following entry: There was an issue retrieving your backup at line 1271: Uh oh, it looks like there's no data to be retrieved for the selected property. Please check if you chose the correct form (https/http/www/non-www) and date interval, then try again. (line 1246). Backup cycle has been disabled. When this happens, it's OK not to create a backup (because dah, there's nothing to backup) but it would be incredibly helpful if the backup continues to run for the next day. Today I need to re-enable the backup the next day (and it only allows me to do it if there's data). Either way, thank you for this add-on, and I hope this suggestion makes sense to you! Edit: A tiny extra one: In the Backup Totals (were the non-grouped data is saved) the A column is not formatted as date :P
Is this review helpful?
Yes
No
A User of Search Analytics for Sheets
March 24, 2020
It's extremely slow to query when selecting all data; how many rows are you requesting at once?
Is this review helpful?
Yes
No
A User of Search Analytics for Sheets
February 25, 2020
Hi. This is a great app but unfortunately I'm having issues with the backup feature. When I run the backup for multiple query filters I get error messages. It is fine if I run the backup based on one query as a filter but not multiple. Will this be fixed?
Is this review helpful?
Yes
No
A user of Search Analytics for Sheets
March 15, 2020
its a spy app
A user of Search Analytics for Sheets
February 28, 2020
Hey! Unfortunately, the only filtering available from Google's side is an "AND" filter, so if you add a filter for queries that contain the word 'red', and another one for queries that contain the word 'widget', it will only return queries that contain those two words at the same time. As Google puts it: All filters in the group must return true for the filter group to be true. Will update as soon as they make an "OR" option available.
A User of Search Analytics for Sheets
February 19, 2020
I am no longer seeing this show up in the Add-ons menu - has something changed recently? I have attempted in both normal Chrome and incognito.
Is this review helpful?
Yes
No
A User of Search Analytics for Sheets
January 29, 2020
I am getting an error message when trying to pull data for a retail site that's quite new that says "Requesting data failed due to the following error: Exceeded maximum execution time". This plugin I have even written a blog post about, but this data set isn't that big and the timeout happens after about 3 minutes. UPDATE. I reinstalled it and ran a smaller date range (that actually had more data than before). It worked so I'm altering my rating.
Is this review helpful?
Yes
No
A user of Search Analytics for Sheets
December 16, 2019
Hey! Are you still getting this error? This should only happen if there's too much of a delay from Google's API.
A User of Search Analytics for Sheets
January 19, 2020
I got this error when trying to open the sidebar: Message details Error: There was an issue showing the sidebar at line 518: Couldn't fetch the list of sites verified in your account, an error occurred at 459: There are no properties available for this account. Add a verified property or choose a different account..
Is this review helpful?
Yes
No
A User of Search Analytics for Sheets
January 19, 2020
A great tool! Now and than (including now) I get the message: "Date Range: Getting available date range..." and keeps getting.... any idea how to fix?
Is this review helpful?
Yes
No
1-10 of 48
Additional information
Mihai Aperghis
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu