How to get csv from Airtable into Make?

Hello @Sam_Bastiaens,
A suggestion from @Donald_Mitchell is also works.
But I’m thinking about another type of workflow to implement this.

→ Use Airtable as a Data Storage for all types of forms.
→ Create Table(response), set all the fields, and then go to Table Permission set Who can create records?-> specific users and then select a user with API access.

⇒ Now Go to make and set up a Scenario using Airtable’s “Watch Records” when the record is created on that specific response table.

  1. Remember when the Airtable form is submitted that itself creates a new record in that response table.
  2. To handle Google Form responses create another scenario when that Google form is submitted and store that data in Airtable.

Now 1. and 2. both of them trigger the “Watch Records” scenario.

Your CSV is always stored in Airtable’s Attachment field.
The attachment field always returns the public download URL for the file and download URLs stay active for at least 2 hours after receiving them. Airtable Attachment URL Behavior | Airtable Support

After you get that attachment URL just use HTTP to download it and then use Parse CSV.
You get all the CSV data in multiple bundles.

I hope this helps you.


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution :white_check_mark: and :+1:
Need expert help or have questions? Contact or comment below! :point_down:

1 Like