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
View original
+14
Please 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.
+9
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
