Skip to main content
Question

Zapier sends multiple notifications for each updated Google Sheet row


Hi,

 

CONTEXT: We have a Google Sheet file that is updated automatically a few times a week. One of the column records the timestamp of the update. 

OBJECTIVE: We would like to receive a Whats notification when the file has been updated

ISSUE: In the event trigger, we have selected “New or Updated spreadsheet row”. The problem is that Zapier is not sending one notification but wants to send a notification for each line of the file as each has been updated (There are thousands of lines).

 

Thanks for your help.

L.

Did this topic help you find an answer to your question?

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@Laurent H 

Help us have more info by posting screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.


Forum|alt.badge.img+3

You can add a filter step to your Zap that checks if the timestamp column has been updated. This ensures that the Zap proceeds only when there's a genuine update to the spreadsheet.


  • Author
  • New
  • 1 reply
  • January 27, 2025

Hi,

Thanks for the initial messages. Here is a copy of my initial simple ZAP. We need just one message when the file is updated. I cannot use a filter because all the lines are updated with a new timestamp.

Ideally, the trigger would be to take an action when the file itself has been updated independently of the content of the file.

 

Many thanks.

 

 


Troy Tessalone
Forum|alt.badge.img+14

@Laurent H 

The screenshots do not show how the Zap steps are configured in EDIT mode.

Also, post screenshots showing the top 3 rows of the GSheet worksheet.

 

The Zap trigger will fire for NEW rows AND for UPDATED rows.

If you only want the Zap to fire for UPDATED rows, then you need to add a Filter as Step 2.

You need to have a column in the GSheet that indicates the file was updated vs the content of the file was updated.

 

Most Zap triggers/actions work on a per record basis.

In your case, the Zap trigger will fire per GSheet row.
 

Help link for using Filter: https://zapier.com/apps/filter/integrations#help

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help