I am tryig to setup automatic CSV import of our product catalog to Airtable. Every morning it should update in case there are changes in prices or stuff.
I was able to setup the Make.com (Integromat) scenario to:
Get the CSV from FTP
Parse the CSV
And I can even create new records in airtable sucesfully
We use our codes for every product (and it is unique). I amy trying to setup that it will “Create new” record if it doesnt exist and “Update” if it does. I am trying to use “Upsert a Record” in Make.com scenario. But that only let me to pair it with Airtable “Record ID”… which the CSV of course can’t have.
Does anyone figured out how to pair the records by OUR id? (which is IN the CSV and also Airtable first column)
After parsing a row from the CSV (but before creating the new record in Airtable), you would need to use Make.com to perform a search of your Airtable base. If it finds a matching record, then you will have the Record ID to use for the Upsert module.