How do I search only one row of Google Sheets and send Slack message

Question

Right now I have the following set up. So I want a slack message to send whenever one column of sheets is updated. I added the filter since my zap was in an infinite loop and I saw this message:

So the filter only moves forward if the column is true the column looks like this:

Problem I originally had sections in my sheets and I saw that Zapier stops when it sees a blank row so I changed that and added check boxes to my section titles which is why the top check box is highlighted blue. Once I added that the zapier trigger did work and sent a slack message based on the section title column being set to true! So I tried checking other boxes in the column but it did not work or send a slack message so now I am stuck.

How do I make it so that whenever any column in that sheet is checked off and set to ‘True’ a slack message is sent?

icon

Best answer by Troy Tessalone 12 July 2023, 03:03

View original

Troy Tessalone · Accepted Answer

@zendesk_userAs an alternative to GSheets, try using Airtable.Airtable has Views.Views can have Filters.Views can be used to trigger Zaps.Airtable also has Automations with a native integration with Slack.

Troy Tessalone · Answer

Hi @zendesk_userGood question.The "Updated Spreadsheet Row" trigger stopped triggeringIf you're watching for changes to a column, we only see new values in that column. If you update the column of an existing row to a value that Zapier previously saw in that column, in that row, we won't see the new value. You will need to either choose a column that will only have unique values, or make a new one which will.For example, if you had X in the Trigger column, then changed it to Y, the Zap would trigger. If you then changed it back to X it would not trigger again, because the Zap has already seen X in that column.The Google Sheets trigger is marked "instant" but it still takes a few minutes to triggerThe triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this. After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods. This process takes about 3 minutes overall.While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.“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.

The "Updated Spreadsheet Row" trigger stopped triggering

The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger

“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