Is there a way to trigger Slack message ONLY when a field in the Google sheet is updated to a specific value?
I’m using Google Form as my ticketing/requests system. It will then create entries in the Google sheet. I want to trigger notification to my team when a request is Completed, ie. the Status is Competed. So, they know their request has been completed.
There’s only “New or Updated Spreadsheet Row” in the Trigger Event available to me. It triggers too many notifications that I don’t want. Anyway to fix it?
Thank you
Teresa
Best answer by Troy TessaloneBest answer by Troy Tessalone
If you’re using the New or Updated Spreadsheet Row trigger and choose Any column to monitor, any change to a row will trigger your Zap. If you select a specific column, then the Zap will only trigger when there are changes on that column.
Note
Zaps using New or Updated Spreadsheet Row will also trigger for any new rows in the spreadsheet, even if the specified column is blank. To avoid triggering in those cases, add a Filter step to your Zap.
If you’re using the New or Updated Spreadsheet Row trigger and choose Any column to monitor, any change to a row will trigger your Zap. If you select a specific column, then the Zap will only trigger when there are changes on that column.
Note
Zaps using New or Updated Spreadsheet Row will also trigger for any new rows in the spreadsheet, even if the specified column is blank. To avoid triggering in those cases, add a Filter step to your Zap.
