fbpx
Auto import new records from a CSV file URL. This extension supports scheduling to run regularly.

With this extension, you can automatically import and update rows from CSVs into Airtable. This extension can be scheduled to run regularly, and supports webhooks. Every time the extension is run, we go through every row in the CSV, and check whether or not it exists in Airtable. If it doesn’t, we add it to Airtable. If it does exist, we update it.

Note that we determine whether or not a row has already been added to Airtable by checking whether or not its unique value already exists on Airtable. Because of this, your CSV must have a column that has a unique value for each row. This can be a unique ID, SKU, username, email, etc.

Features

  • Supports up to 10 CSVs (can be for different bases/tables)
  • Supports adding and updating records (all field types)
  • Supports Dropbox share URLs. Example: https://www.dropbox.com/s/a1b2c3d4ef5gh6/example.docx?dl=0
  • Supports Google Drive share URLs. (public ones, not private!)
    Example: https://drive.google.com/file/d/1kazyfB4JHoZSmczN-FBVXB4C8qN5b46G/view?usp=sharing
  • Can be triggered by a schedule or a Webhook.

Limitations

  • This extension can only sync a few thousands of records.
  • Only supports adding and updating records, but doesn’t support deleting existing records.
  • Airtable must have field names that are matching all the CSV column names before the import.
  • Columns/field names are case sensitive and they have to match exactly.
  • CSVs must have a column that contains a unique value for each row (ID, SKU, username, email, etc.)
  • Collaborator field is not supported.

Use Cases

Some examples

  • Pull data from Google Sheets
  • Sync multiple bases (with our exporter)
  • Automate some daily reports
  • Auto-sync with 3rd parties with no API

Released

Supported features

Third Party Integration

FAQ

Most frequent questions and answers

You can use the subscription on different bases/accounts. It covers universal access to all of our extensions. All of our extensions can be setup for multiple bases and tables.

There’s no limit on the number of records you can process. Unlike Zapier and Integromat, our pricing is per month, not per record. However, there might be limitations by third party integrations. Also, some extensions can only run on one table at a time. Please refer to each extension’s page on whether or not it supports running on multiple tables simultaneously.

Yes. Submit your request here and we will get back to you as soon as we can.

Yes, you can schedule a call with us by going here.

Yes! Also, please note that we usually make updates when users request them. We try our best to make things work like expected.