Is there a way to update an Airtable record with changes made by API to a row in Google Sheets?
I know Integromat has a ‘Watch Records’ module that does this but I believe it only works with manual changes to a Google Sheet.
I have a JotForm that I use as a sort of approval workflow. The JotForm gets sent back and forth to different people and every time a JotForm is edited, JotForm makes the changes to Google Sheets but these changes don’t make it to Airtable as these changes are done by JotForm by API.
Integromat does make updates to Airtable records when there are Google Sheets changes (using the Integromat Google Sheets extension) but only works with changes done manually. If there are any changes to a Google Sheet row by API, such as when JotForm makes a change, then Integromat does not detect this change.
JotForm updates rows in Google Sheets but on Airtable, JorForm only creates new records.