Export Airtable to Dropbox

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 Dropbox using Make.com and CSV Getter. Your Dropbox 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/6Fh3GMVzakIXIjl1KxET

This demo Export URL is a exporting the following base:

You can visit the demo base here.

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, and select the Dropbox file.

Select Upload a File for the Dropbox action.

Step 6:

Select the folder in Dropbox you would like to save your backups to.

Step 7:

Test your scenario by pressing 'Run once'.

Visit Dropbox, and you will see you Airtable has been backed up as a CSV file.

Scheduling and Cataloguing

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.

We recommend attaching the filename_timestamp parameter to your CSV Getter Export URL. This parameter will add the date and time of each export to your filename, perfect for recognising each backup file in Dropbox.

https://api.csvgetter.com/6Fh3GMVzakIXIjl1KxET?filename_timestamp=true

After the scenario has run multiple times, you will have catalogued CSV backups of your Airtable data.