Archive Data lets you automatically store historical data from your Google Sheets reports and dashboards. Set a schedule to paste from column A to B, 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
*Copy formatting or paste plain text
*Scheduling options (hourly, daily, weekly, or monthly) or archive immediately
How to Use:
1. Choose Add-Ons > Archive Data > Add New Archive
2. Select the source and destination cells to include
3. Choose formatting and scheduling options
4. Name the project and hit Save
Created by Mixed Analytics with thanks to Damir Saric.
Extore is a team of professionals who are passionate about creating extensions for web browsers. This devotion also gives us opportunity to appreciate work of other people. We get inspired by useful, open source extensions made by developers all over the world. Our strong belief is that one should share helpful add-ons with others. That’s why we’d like to present you our ever-growing list of favourite extensions that have inspired us. Moreover, as you probably have already learned, sometimes struggling for the best brings an end to the good. Talking about add-ons it often turns out that an upgrade is worse then previous version. Also it can become really tricky to get back to the beloved version of your favourite extension. That’s why we’re going to make not only the latest, but all versions of our favourite (and we hope yours too) add-ons available for download. No more compromises, just stick to the version you really like!