Hello,
I made a zap that sends a Team message to a specific Teams Channel regarding a cell in Google Sheets, but Zapier send multiple messages everyday regarding that cell. Is there a way to limit the notification/message to one time only?
I just need the zap to send a message to the channel one time and that’s it, is there an extra step that I need to add to my zap? or is this not possible yet?
Best answer by andywingrave
Hello there! Hope you're well.
My recommendation here would actually, if possible just use something like Airtable because you can control your zap triggers in a much more elegant way.
Google sheets is going to trigger every time you update a row - Because that's how the Zapier integration has been configured. My advice is to never use Google Sheets as both a Zap powering spreadsheet in addition to one that's used for general tasks - Because this problem is so pervasive.
Here's a really tacky workaround if your system relies on Sheets though:
First we want to add a column in our sheet - Called "triggered" (or something) which will be a date and time field
Trigger as normal
Filter based on Triggered - Was the timestamp in the last 24 hours or not?
If it passes continue and update as normal
End your zap by updating the column with a new timestamp of the current time
This should ensure it triggers only once per 24 hours...
So very hacky - But it should work.
Hope that helps!
+14Please provide screenshots of how your Zap steps are configured.
May need to add a Filter step to the Zap and/or adjust or change the trigger event.
+9Hello there! Hope you're well.
My recommendation here would actually, if possible just use something like Airtable because you can control your zap triggers in a much more elegant way.
Google sheets is going to trigger every time you update a row - Because that's how the Zapier integration has been configured. My advice is to never use Google Sheets as both a Zap powering spreadsheet in addition to one that's used for general tasks - Because this problem is so pervasive.
Here's a really tacky workaround if your system relies on Sheets though:
First we want to add a column in our sheet - Called "triggered" (or something) which will be a date and time field
Trigger as normal
Filter based on Triggered - Was the timestamp in the last 24 hours or not?
If it passes continue and update as normal
End your zap by updating the column with a new timestamp of the current time
This should ensure it triggers only once per 24 hours...
So very hacky - But it should work.
Hope that helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
