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 ROWIDThe 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.

Question

Zap creates duplicate rows in Google Sheets instead of updating row when triggered by Smartsheet.

Forum|Forum|2 years ago
August 29, 2023
1 reply
80 views

ng67
Beginner

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.