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.

8 months ago
29 August 2023
1 reply
52 views

ng67
Beginner
9 replies

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.

1 reply

Userlevel 7

+14

Troy Tessalone
Certified Zapier Expert
24207 replies
8 months ago
29 August 2023

Hi @ng67

Good question.

Can you post screenshots with how each of your Zap steps are configured to give us full context?

Reply

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded