Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi everyone!

I have an Airtable database with 5 tables in it, and each table has at least 300 records in it.

I'm trying to set up an automation that every weekend, it creates a CSV file/excel with the database records and store in a Google drive. 

I'm looking for a way to automatically back up my Airtable data to Google sheet every weekend so I don't lose them. 

Is this possible pls?

Hi ​@Lynds 

You can manually duplicate a Base.

You can manually export Base Tables to CSV.

Otherwise, it will involve using the Airtable API to automate the data exports as backups: https://support.airtable.com/docs/api

Perhaps look into existing apps that can be connected to Airtable that will do the scheduled CSV exports of Airtable Base Tables.

e.g. miniExtensions: https://miniextensions.com/airtable-csv-export/

Hi ​@Lynds 

You can manually duplicate a Base.

You can manually export Base Tables to CSV.

Otherwise, it will involve using the Airtable API to automate the data exports as backups: https://support.airtable.com/docs/api

Perhaps look into existing apps that can be connected to Airtable that will do the scheduled CSV exports of Airtable Base Tables.

e.g. miniExtensions: https://miniextensions.com/airtable-csv-export/

 

Thanks a lot Troy, this is really helpful. 

Terms & ConditionsAccessibility statement