Add-ons
Check out the store for many more
Add-on

Archive Data


(14)
776 users

Overview

Automatically store historical data from your Google Sheets reports and dashboards before it gets refreshed.
Archive Data lets you automatically store historical data from your Google Sheets reports and dashboards. Set a schedule to paste from range X to Y, backing up data before it gets refreshed.

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.

Changelog:
2018-07-06: new archive to rows functionality
2018-04-23: improved scheduler functionality
2017-12-10: archive to the same column

Created by Mixed Analytics with thanks to Damir Saric. If you have any questions, please send a message or view http://mixedanalytics.com/blog/archive-data-add-on-google-sheets/ for more information.

Details

Version: 27
Updated: August 9, 2018
Language: English