Update Google Sheets after Cogniform update

I would like to update a row in google sheets if an entry in a Cognito form has been updated. The Google Sheets update module asks me for the rowid to update, which makes sense. How can I find this rowid (to pass it to the module) in my spreadsheet based on a common identifier (present in my form and in my spreadsheet)?
Thank you for your help,

Marc

You need to use search record module that give you row_id of updated sheet row

2 Likes