How to trigger Slack notification when update in Google Sheet

Question

Hello there,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 youTeresa

Troy Tessalone · Accepted Answer

Hi@teresaCheck out this help article:“New or Updated Spreadsheet Row” trigger behaviorIf 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.NoteZaps 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.###Alternative is to use Airtable: https://zapier.com/apps/airtable/integrations#triggers-and-actionsAirtable Zap app has a trigger for New Record in View.Airtable has Views: https://support.airtable.com/hc/en-us/articles/202624989-Guide-to-viewsAirtable has Forms: https://support.airtable.com/hc/en-us/articles/206058268-Guide-to-using-the-form-viewAirtable has Automations: https://support.airtable.com/hc/en-us/articles/360050974153-Automations-overview

jayeshkumarbhatia · Answer

Hey,You should user below triggerThan add a step of Filter. Filter will execute the Zap further, only when the filter condition is matched.

“New or Updated Spreadsheet Row” trigger behavior

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded