CSV Style Import

Hi there. We are looking to import order data into Airtable with something similar to the following CSV functionality except through the API:

We would like to trigger automations only when there are a) new rows or if b) certain fields for an existing row are updated (eg. order cancelled field: null → ‘cancelled’).

Is there anyway to accomplish something like this through the api? Any other suggestions are greatly welcomed :).


Hi @ir_cdmed - I wrote a small python script a while back that imports data using the API:

You could follow this pattern with pretty much any programming language that can parse a csv file and call an API.

I haven’t tried this out, but I assume new records imported via the API could then have automations triggered against them.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.