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
Any help would be gratefully accepted.
The only practical approach for this is to use Google Apps Script natively to digest, format, and push CSV content directly into your target Airtable base.
I have built many custom solutions like this and they are extremely reliable. My experience is that Zapier adds a level of abstraction and moving parts that are less than ideal for integrations.
I’m a Google Apps Script consultant and data integration architect - happy to provide a little guidance with some code examples. email@example.com
We made a tool that automatically imports a CSV into Airtable. It supports scheduling and webhooks. Every time the tool runs, it tries to see if there are any rows that exist in the CSV but not Airtable, and then add those to Airtable.
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.
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.