Automatically store snapshots of historical data in your Google Sheets reports and dashboards.
Listing updated:November 28, 2023
Works with:
128K+
Overview
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:
https://mixedanalytics.com/blog/archive-data-add-on-google-sheets/

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

📃 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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
E. O.
May 6, 2022
This addon is THE missed link for all who build time-series charts in Google Data Studio, based on third party data. There are multiple possibilities to query data - but most possibilities rewrite the sheet, if you consecutively query it. This addon closes this gap and enables you to create the day-by-day data flow. The addon works out-of-the-box and needs no support. Nevertheless, the developer team doesn't let you stay in the rain - my personal experience, validated multiple times.
Is this review helpful?
Yes
No
Profile Picture
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
No
Profile Picture
Nika Jikurashvili
January 31, 2022
working great! It will be good if cells will clear after move scheduled data. please work on it...
Is this review helpful?
Yes
No
Profile Picture
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
No
Profile Picture
A User of Archive Data
November 20, 2019
Awesome add-on tool! Covers basic archiving needs. NOTE: If you receive an error code referencing user authorization when selecting the source and destination, make sure you're not logged in to multiple google accounts. I had to log-out and log back in to my google user account.
Is this review helpful?
Yes
No
Profile Picture
Shane Brunson
February 13, 2021
Thank you so much this helps tediously with my SEO automation!
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
March 31, 2018
Hi, I have used the add on, It is really user friendly and effective, I would like to have one more option in the add on, Example ;- i 1 have archived sheet1:A1:F100 to sheet2:A1:F100 after that i deleted the data in the source sheet the next time when i archive i dont want the data in A1 to F100 to be over written instead it should write to next available epmpty range in sheet 2
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
November 8, 2017
Muy bien! Very cool, simple, effective) But it seems that scheduling does not work, archiving is possible only "by hand". --- 8/11/17 checkbox (or smth) to paste data to row/column would be great - spreadsheet is longer down than to the right
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
December 21, 2019
Very cool add-on! I'm trying to archive several sheets and it's not working. Is it possible? For example, "ARCHIVE Sheet 1" is getting info from "SOURCE Sheet 1" (in the same document), "ARCHIVE Sheet 2" is getting info from "SOURCE Sheet 2" (in the same document), etc. Here's the error message: "The number of rows in the data does not match the number of rows in the range. The data has 1495 but the range has 1986." I think it's summing the rows from multiple sheets, because when I did it for just one sheet it worked perfectly.
Is this review helpful?
Yes
No
Profile Picture
A User of Archive Data
December 20, 2018
I love this add-on tool! Would it be possible to add a timestamp to the rows/columns of the archived data? Then I'd easily be able to tell which segment of data was archived when Thanks :)
Is this review helpful?
Yes
No
1-10 of 25
Search
Clear search
Close search
Google apps
Main menu