Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 01, 2024 05:40 AM
Hello,
Yesterday I realized that I don't have a backup of my many bases.
Quite worried, I then looked for a solution. And found out: Almost all of them are quite expensive, and some of them seemed awkward to handle.
Now I would like to know how important it is to have a local data backup?
Is it really possible for my data to suddenly disappear one morning? Perhaps due to some error on the part of Airtable, San Francisco?
Or is all data backed up redundantly several times, as some providers claim? So secure that you don't have to be afraid?
Marceting
Feb 02, 2024 01:59 AM - edited Feb 02, 2024 02:36 AM
Hey!
I made CSVGetter as a low-cost solution.
Our app has a small price tag but can work with Google app script which is free. You can setup a scheduled trigger to backup Airtable into Google sheets: hourly, daily, weekly, monthly etc.
It works by letting you create an export URL which can be used in a google app script. See here.
The export URL is very powerful - for example, you can put ?email_me=true at the end of the URL and use it in the scheduled script. This means the scheduled backup trigger in google sheets will achieve two things:
1. Your latest Airtable data is safely stored to google drive.
2. You have a daily email reminder prompting you to save the latest data to your local machine, and a link to do so in one click.
Can now also add your own custom auth headers to lock the whole process down as well.
It's super versatile and modular and we add features all the time! Let me know if you have any questions 🙂
Feb 02, 2024 10:40 PM
You can retroactively make backups using the snapshot feature in the UNDO menu on any base. You'll notice that Airtable backs up your base about every 8 hours. Depending on your plan, they will keep these backups for upto three years. You can also initiate a snapshot (or backup) before doing any potentially destructive work.
Another possibility, if you're somewhat technical, is to install the open-source version of NocoDB on your own computer and have that backup all your data on Airtable periodically. I experimented with it a year ago, and it not only pulled down all my data but also all my attachments. Obviously they are different products with different features, but it might give peace of mind when the Amazon US East region is down.
Feb 04, 2024 11:21 PM
Hi creminology,
Thank you very much for your comments. That is very reassuring.
Could you send me a link to the open source version of NocoDB?
I couldn't find it yet.
Thanks again and have a nice day -
Marceting
Feb 06, 2024 02:01 AM
Have sent you a private message with the direct link to the source code. For anybody else reading this , just Google “nocodb” and “github” and it should be the first result.
The code was updated yesterday, so it is in active development.
Feb 09, 2024 12:15 AM
Thanks a lot, creminology.