Automatically store snapshots of historical data in your Google Sheets reports and dashboards.
Listing updated:November 28, 2023
Works with:
The Mixed Analytics Data Archiver lets you automatically store historical data in your Google Sheets reports and dashboards. Set a schedule to paste from range X to Y, backing up data before it gets refreshed. 
šŸ‘‡ More info below

āœļø Example:
You have a monthly dashboard that uses the "Google Analytics spreadsheet add-on" and a Salesforce connector to automatically pull in new website and customer data each month. When the report refreshes and gets populated with new data, the old data is wiped out. With this extension, automatically save January's data in a new column before it gets overwritten by February's data.

āœØ Features:
*Choose your source and destination ranges
*Choose whether to archive to row or columns
*Copy formatting or paste plain text
*Scheduling options (hourly, daily, weekly, or monthly) or archive immediately
*** Generally you should choose an archive time an hour or two after the report refreshes.
*Free :)

šŸ““ Documentation:

šŸ’¬ Fast, friendly support

šŸ“ƒ Changelog:
2022-07-20: minor tweaks
2020-12-05: run archives one at a time
2020-11-07: style update
2019-09-25: better navigation
2019-08-19: increased save request limit
2019-06-24: last day of month scheduling
2018-07-06: new archive to rows functionality
2018-04-23: improved scheduler functionality
2017-12-10: archive to the same column
2017-11-05: re-release after accidentally borking the 1st version šŸ˜…
2017-06-28 first release!
Additional information
PricingNot available
Privacy policy
Terms of service
Archive Data will ask for the permissions shown below. Learn more
Archive Data will need access to your Google account
This will allow Archive Data to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu