Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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

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 

 

 

Hi @Michael Bricklane 

The 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 headers
  • Value in Cell A1
  • Column A not hidden
  • No merged rows/columns
  • If you have formulas in rows, then that may be causing the issue for which rows are returned by the Zap trigger step to test with

 

You 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.

 

 

Thanks, I will have another go!

Thank you, it’s working now! 

That’s fantastic news @Michael Bricklane! Thanks for confirming that did the trick. And a big thank you to @Troy Tessalone for helping out here - always greatly appreciated! 🤗

Do reach back out in the Community if you run into further issues at all. Until then, happy Zapping! ⚡️

Reply


Terms & Conditions