Archive Data - Google Workspace Marketplace

Mixed Analytics

• 126,117

Overview

Automatically store snapshots of historical data in your Google Sheets reports and dashboards.

Archive Data 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

✏️ 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:
https://mixedanalytics.com/blog/archive-data-add-on-google-sheets/

💬 Fast, friendly support
https://mixedanalytics.com/contact/
_______________________________________________________________________________________

📃 Changelog:
2020-12-05: run archives one at a time + drag-n-drop ordering
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!

Reviews

Language:

Sort by:

Shane Brunson

February 13, 2021

Thank you so much this helps tediously with my SEO automation!

Is this review helpful?

Yes

Uday Patil

January 16, 2021

Great add-on... I like it. Is it possible to add run schedule report every 15 minutes? Please consider this request to further update.

Is this review helpful?

Yes

Ana Kravitz

January 17, 2021

Sorry, Google limits add-on triggers to once per hour at most. If Google ever removes this limit, I will update the add-on to enable more frequent schedules.

Jose Flores

December 29, 2020

Works perfectly! Thanks so much for this, just a question, what timezone does the app follow? GMT+8? or Pacific Time? please let me know. Thank you :)

Is this review helpful?

Yes

Ana Kravitz

December 29, 2020

Hi Jose! It uses the timezone of the sheet. You can check your sheet timezone by clicking File > Spreadsheet settings. Hope that helps clarify.

Jose Flores

December 29, 2020

The reason I ask this is that I scheduled the archiving and am using 2 other scheduled scripts that follows GMT+8. I just need to ensure if I have the correct timezone for this or else, I won't get the data I need :( Thanks in advance!

Samson Assefa

December 7, 2020

Samson Assefa Gebrehiwot

Is this review helpful?

Yes

Nika Jikurashvili

October 4, 2020

Thanks!! It's helpful for me

Is this review helpful?

Yes

Ana Kravitz

October 5, 2020

Nice! I'm glad you like it :)

Aston Hunt

September 23, 2020

It works on a manual basis, but scheduling for the purpose of automation doesn't work.

Is this review helpful?

Yes

Ana Kravitz

January 8, 2021

This add-on is totally free, including scheduling. There's no option to subscribe, I think you were looking at a different add-on.

Jose Flores

January 6, 2021

It works perfectly but found out that scheduling is a feature available when you subscribe. :) I guess I'll stick to manual update :D

Adel M. Ibrahim

July 30, 2020

Thanks

Is this review helpful?

Yes

A User of Archive Data

July 2, 2020

This is awesome, but would love to be able to Archive to a separate Sheet so that my main sheet does not get bogged down!!!

Is this review helpful?

Yes

A User of Archive Data

May 13, 2020

I'm using real-time data & I was needing a way to take a snapshot at a given time. This is perfect for what I needed. It's very simple and user friendly to set up. Plus, I made contact with the developer, Ana, who is very accessible, helpful, and kind. You'll probably never need it. But conscientious assistance is right there for you if you do. This is an excellent add-on.

Is this review helpful?

Yes

A User of Archive Data

March 2, 2020

Thank you for this nice add-on. Set it and (kind of) forget it.

Is this review helpful?

Yes

1-10 of 25

Additional information

Mixed Analytics

Website

Support

Clear search

Close search

Google apps

Main menu