Help

Auto Import CSV

Topic Labels: ImportingExporting
9548 13
cancel
Showing results for 
Search instead for 
Did you mean: 
Mark_Ryan1
4 - Data Explorer
4 - Data Explorer

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.

13 Replies 13
Umut_Cankurt
5 - Automation Enthusiast
5 - Automation Enthusiast

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
4 - Data Explorer
4 - Data Explorer

@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.

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
5 - Automation Enthusiast
5 - Automation Enthusiast

You might be able to find a solution with Zapier.

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
6 - Interface Innovator
6 - Interface Innovator

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.

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,

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.

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?