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

Last Updated

Supported features

Third Party Integration

12 Questions
Inline Feedbacks
View all comments
Site visitor
Site visitor

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

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

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

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

Unknown field name: “Name “.

miniExtensions
Admin
miniExtensions
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

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

miniExtensions
Admin
miniExtensions
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

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

Chat with GPT using Airtable Data

Enhance user engagement and interaction with the power of ChatGPT in miniExtensions. Create a captivating and dynamic extension that allows your users to effortlessly engage

FAQ

Most frequent questions and answers

No, regardless of how many collaborators you have in Airtable, you only need to pay for one miniExtensions subscription then you can have unlimited users access the extensions you build with no extra fees. Learn more

There is no limit on how many bases you can install miniExtensions on. Learn more

 

We offer limited and unlimited plans. To learn more about how our limits work, see this article.

 

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.

 

We’re not offering discounts at this time. And no commitment is required.

 

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

 

New Releases