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.
⚠️ Note

This extension can only sync a few thousand records.

Limitations

  • 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.)
  • The 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

Troubleshooting

My CSV is not being imported. I’m getting an error!

Before you start importing your CSV with our extension, make sure that your Airtable table have all the field names that exist in your CSV file. If you’re starting with a brand new table, then the easiest way to create all the required fields is to import your CSV file in Airtable first. Then you can schedule your CSV to be automatically imported with miniExtensions going forward.

I keep getting an error “Could not import CSV because there is a row that does not have a value for “UniqueID”. I have no row with empty UniqueID.

Make sure that your file URL is both public and direct, not private!
(checkout the screenshot for an example of a non-public link)

Released

Supported features

Third Party Integration

12 Questions
Inline Feedbacks
View all comments
Site visitor
Site visitor
4 months ago

How to setup a schedule for a job to run every day at 8am? I can’t see how to set the time.

miniExtensions
Admin
miniExtensions
4 months ago
Reply to  Site visitor

If you select the extension settings to run ‘every 24 hours’ and you hit save at 8 AM, it will run every 24 hours going forward.

Site visitor
Site visitor
4 months ago

If I set up Airtable Automations to trigger via a webhook that should work right? I am not very familiar with webhooks yet, this is why I ask.

miniExtensions
Admin
miniExtensions
4 months ago
Reply to  Site visitor

The webhook is a unique URL for your extension. Every time it’s accessed (opened), it will trigger the extension to run. The extension will run in the same way as if you clicked on the run button on the settings page manually.

Site visitor
Site visitor
4 months ago

I’m getting this error:

Could not find a unique ID for the following row: {"<!DOCTYPE html><html lang=\"en\"><head><...etc.
miniExtensions
Admin
miniExtensions
4 months ago
Reply to  Site visitor

The CSV file URL has to be public and direct. If you’re trying to import a private URL, the login webpage will be fetched. And that’s why you’re getting this error.

Also, note that to get direct URL in Google Sheets, you would need to change it to something like this: 

https://docs.google.com/spreadsheets/d/ID/export?format=csv
Site visitor
Site visitor
4 months ago

I re-synced my base already, but I’m still getting an error that says:

Unknown field name: “Name “.

miniExtensions
Admin
miniExtensions
4 months ago
Reply to  Site visitor

Notice there is a space at the end of that field name. It has to be exactly the same. The best way to avoid these mistakes is to first import the actual CSV file initially in Airtable and then schedule it to be synced afterward.

Site visitor
Site visitor
3 months ago

I am getting an error message “You cannot update the same record multiple times in a single request”

miniExtensions
Admin
miniExtensions
3 months ago
Reply to  Site visitor

You are seeing this error because this extension requires to have a field with unique IDs. This field cannot have multiple records with the same ID.

Site visitor
Site visitor
2 months ago

We’re running into some limitations with airtable’s csv import app and are looking for a third party app that’ll do the trick. I’d like to run the specific functionalities by you to make sure they’d work with your extension. The root of our situation is that we need to be able to import bulk records and have them be entered either as new records or merge/update existing records is they share a “RefID”. Airtable’s import block will not allow record merges based on function fields, but our RefID field is a concatenation of another field in the record and part of the record ID written into airtable. The format is “XXX-####”. We have external partners sending us their data with some regularity. Records on their data will either have a “RefID” field that matches our existing records, we need these to be merged, or their data will have no value entered for “RefID” and we need those to be imported as new records. So we need to be able to determine whether to add/update a record based on a function field. And we need to have a different selection of fields for records being updated than for new records.

miniExtensions
Admin
miniExtensions
2 months ago
Reply to  Site visitor

If the problem you have is the inability to use a formula field type for the matching field (or what we call the unique ID field), you would have the same issue with our extension, because it’s not possible to edit computed fields in Airtable.

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.

We have instructional videos for how to use each one of our extensions on the product page. They guide you step-by-step of how to set them up.

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

We’re not offering discounts at this time. And we don’t require any commitment. You can cancel your subscription anytime.

Unfortunately, we only offer a single plan which provides unlimited access to all of our extensions.

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