Hi. I am trying to do a one-way sync from Google Sheets to Airtable. I noticed there is an ‘Upsert a record’ module, which sounds ideal for what I need.
I would like to either update an existing record, or insert a new one. I would like to do this based on the Primary Key value, not the actual record ID. From what I’ve understood, there is the feature “Smart Links” which when turned on, allows you to work with names (primary key values in Airtable) rather than the more obscure 17-character internal record id of Airtable.
However, when I put the RecordID as the primary key value, it gives me a 404 Not found error. Is this intended behaviour?
Just to be clear, I tried the traditional approach of first searching for record in AirTable, then getting the actual internal record ID, and updating using that, and it works. However, this would be much more inconvenient to work with this way.
You can refer to this video for a visual explanation: Temp: Make explanation Airtable Upsert.webm - Google Drive