Zapier Filter Test Error when a certain Column in Google sheets is updated to “yes” a message sends in Slack.

Question

Hello all,

I am fairly new to Zapier and have encountered a snag whilst try to make a Zap which I feel should be fairly straight forward.

The purpose of this Zap is for when a certain Column in Google sheets is updated to “yes” a message sends in Slack.

The name of this Column is Trigger1.

Zapier seems to have no issues finding the spreadsheet and the correct Column but the Filter function keeps showing the same error message when i am testing it.

I have tried to add a Formatter Line-item to text but this encounters the same issues.

I have included some screenshots below - I would be grateful if a Zapier whizz could take a look and give me a nudge in the ridge direction.

Many thanks,

Michael

Troy Tessalone · Accepted Answer

Hi @Michael BricklaneThe Filter step warning is to indicate the step would not have passed because the Zap trigger step example row you are using had no value for the column.Check the Row for the chosen Zap trigger example to help you troubleshoot.NOTE: GSheets need to be configured in a certain way to be used in Zaps.Row 1 with headersValue in Cell A1Column A not hiddenNo merged rows/columnsIf you have formulas in rows, then that may be causing the issue for which rows are returned by the Zap trigger step to test withYou can try turning your Zap ON and testing live.Then check your Zap Runs history details to see the DATA IN/OUT for each Zap step.NOTE: If you change a cell value from X > Y > X, it will not trigger for previously seen values.I’d recommend using Airtable instead of GSheets.