I have a zap set up as-
- Trigger: Smartsheets updated row
- Zapier Filter condition
- Lookup Spreadsheet row / create new row if not found
- Update spreadsheet Row / with the Custom set to ROW of the googlesheet in the lookup as the dynamic update- It use to be ROWID
The issue I am experiencing is that it keeps adding a row when there is a change in smartsheets and doesn’t make the update to the existing row in the Google sheet creating duplicate like entries.
When testing it works and updates that same row for the test.