Automatically backup Airtable to Google Drive

Introduction

CSV Getter is a data export platform that allows you to connect to your favorite no-code platforms to create automated data pipelines. The platform helps you understand what data you are exporting and where it is going. In this guide, we will show you how to schedule a complete Airtable database backup to Google Drive using Make.com and CSV Getter. Your Google Drive file will have your latest Airtable database snapshot and will be updated at a frequency of your choosing.

Step 1.

Create an Airtable export URL or test this process with our demo URL available to copy and paste below.

https://api.csvgetter.com/15SpsAURiAXlKSzZeORq

Step 2.

Log on to Make.com, and create a new scenario.

Step 3.

Press the large "+" button to add a new action and under HTTP, choose Get a file.

Step 4.

Add your CSV Getter export URL as the URL for HTTP.

If you would like to see an example of adding an HTTP bearer token to your URL in advanced settings, then check out this article.

Step 5.

Add a second action, a destination cloud drive of your choosing. Google Drive is used in this tutorial. On the Google Drive action, click Upload a file.

Step 6:

Fill out the fields required for the action. For the file, you can choose the file retrieved from the HTTP module.

Step 7:

Test your scenario by pressing 'Run once'. Once this is complete, you will see your Airtable CSV Backup in Google Drive.

When you are happy your scenario is working, you can turn it on and select a schedule, and your Airtable will be backed up automatically.

(Optional) Step 8:

Get notified of each backup using further Make actions. The below screenshot will give you an idea of how Make modules can be used in synchronisation.