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.

[Umut_Cankurt]

Hello;
I’m waiting for the answer on this issue. I hope that the answer will be written soon, as a solution or method

[Jay]

@Umut_Cankurt

Have you looked at the API? It should be straight forward to loop through the rows in your CSV file and create records in a table.

[Julian_Kirkness]

Hi

You could use Integromat to do this. You would have the ‘Scenario’ run once prepay and look for the file - if found you could use it’s Parse CSV ‘app’ to read the file - and any subsequent steps would then process for each ‘record’ in the CSV. Works like a dream.

Hope this helps!

[Chris_Tennant]

You might be able to find a solution with Zapier.

[Bill_French]

Mark,

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. bill.french@gmail.com

[Abdulrahman_Alz]

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.

miniExtensions

Automatically Import CSVs into Airtable - miniExtensions

Keep your Airtable and a CSV file in sync by scheduling this extension to run regularly. Supports up to 10 CSVs, and supports scheduling and webhooks.

[suvra_roy]

Hi,

We have been just starting with base and have run into problems where bulk import (migration) of the csv files are not possible into the base beyond certain rows. Would you recommend this for us as a possible solution?
Thanks,

[Abdulrahman_Alz]

I’d be happy to help you with that and talk through it. Please reach out to us in the chat at https://miniextensions.com.

[ScottWorld]

Abdulrahman_Alzanki:

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.

How does this tool match field names? By the field name itself, or by the order of the fields on the view? On that note, which Airtable view does this tool use for importing?