Auto Import CSV

[Mark_Ryan1]

Hi all,

First time poster.!

I am looking to import a file each day that we receive via e-mail. Using Zapier I can save the attachment to G Drive but can’t figure out how to get this data into a base as it hits the folder.

I have tried using

1. New file in G folder but you can’t see inside the file so you can’t map the data fields.
2. I’ve converted the file to a Google Sheet to see if it was a CVS thing but same issue.

Any help would be gratefully accepted.

[Abdulrahman_Alz]

The field names are copied from the CSV. The order of the fields is not relevant when importing the files because we assume that the columns in the CSV have corresponding Airtable fields.

In terms of Airtable views, the rows are just added to the table. The view would be determined by your existing Airtable Views. We just add the rows to the table.

[ScottWorld]

The field names are “copied” from the CSV? Meaning that you “match“ the field names from the CSV to identical field names in Airtable?

[Matej_Skarka]

Is there anyone who user Integromat/Make.com for importing CSV? I was not able to set it up properly.

I am able to GET the CSV from FTP. Parse the CSV… but not able to create/update the records in airtable.

I am trying to use “Upsert a Record” but always ends with error " BundleValidationError" - Invalid number in parameter ‘fldsAHrvmFOW4OBQ4’.

But I can’t see parameter named like that in my airtable.

[ScottWorld]

Matej_Skarka:

Is there anyone who user Integromat/Make.com for importing CSV? I was not able to set it up properly.

You posted this question at the link below, which I have responded to:

Importing CSV from Make.com (Integromat) Importing / Exporting

Hello, I am tryig to setup automatic CSV import of our product catalog to Airtable. Every morning it should update in case there are changes in prices or stuff. I was able to setup the Make.com (Integromat) scenario to: Get the CSV from FTP Parse the CSV And I can even create new records in airtable sucesfully BUT We use our codes for every product (and it is unique). I amy trying to setup that it will “Create new” record if it doesnt exist and “Update” if it does. I am trying to use “Upse…