Best answer

Export data from Airtable

  • 31 July 2021
  • 2 replies
  • 780 views

Userlevel 1

Not sure if this is possible with Zapier/Airtable, so I’ll just lay out what I’m looking for, would be ideal, and then work from there, since I am either blind or don’t see how I can do it.

We use Airtable to collect data from our customers. We would like to automate the export from Airtable and upload to system via FTP/SFTP. So I guess there are a few parts I am looking for some help to determine feasibility:

1] Is it possible to put all data from a base/view on Airtable into a CSV? That is the file format our system uses for data import.
2] Is it possible to automate an export/data dump from Airtable via Zapier?
3] Is it possible to set files up to be automatically uploaded via FTP to a certain folder so that our system can complete its scheduled import?

 

If it’s not possible to do all 3 of these, if there are ways to do one or two of them, perhaps I can piece together a solution for the remaining step on my own. That said, ideally I would like it to be done automatically so nobody has to worry about generating exports or uploading to FTP on a daily basis. Thanks for your help!

icon

Best answer by Troy Tessalone 31 July 2021, 18:22

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @Toast 

 

1] Is it possible to put all data from a base/view on Airtable into a CSV? That is the file format our system uses for data import.

You can leverage the Airtable API to pull data: https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API

App APIs can be used in Zaps with the Webhooks app: https://zapier.com/apps/webhook/integrations

NOTES:

You’ll have to handle pagination with the Airtable API.

Depending on how much data you’re trying to pull the Zap step could timeout.

  • The Free plan can run scripts of up to 1 second and 128 MB of RAM.
  • Paid plans can run scripts of up to 10 seconds and 256 MB of RAM. Your Zap will error if it exceeds these limits.


2] Is it possible to automate an export/data dump from Airtable via Zapier?

In theory yes, but the defined requirements may

You can schedule Zaps to trigger with the Schedule Zap app: https://zapier.com/apps/schedule/integrations

Aitable Article: https://support.airtable.com/hc/en-us/articles/360035101353-Offline-access


3] Is it possible to set files up to be automatically uploaded via FTP to a certain folder so that our system can complete its scheduled import?

Check out the Files Zap app: https://zapier.com/apps/filesdotcom/integrations

 

TIP: May be easier to manually export the desired Airtable data as a CSV, then drop into a Folder.

Zap Steps

  1. Trigger: GDrive - New File in Folder
  2. Action: Files - Upload File
Userlevel 1

I’ll give that a try and see what I can make work. My complication is that to be compliant with regulations, instead of putting everything into one base, I have about a dozen separate bases for customers. So I am basically repeating the process 12 times (12 zaps)… I think with what you have I may be able to put something together.

It appears what I am looking at is something similar to:

  1. Trigger - Scheduled Time (9am for example)
  2. Action - Dump data from Airtable base into CSV (Repeat for each base needed)

Then use the second zap you mentioned to upload via FTP

  1. Trigger - New file in Google Drive (Imports folder, for example)
  2. Action - Upload File

I will explore the nuances on my end to make sure this is feasible unless anyone knows the answer. I just need to ensure that I can keep the file name consistent (As the importer on our system performs the import by file name), and that when I create the new file, it will be a CSV (The importer doesn’t play well with other file formats)

Thanks for your help! Time to start tinkering again!