About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Filtered email from google sheets using go canvas

  • 12 August 2020
  • 3 replies
  • 94 views
J

I having difficulty filtering spreadsheet rows to send emails (outlook) on specific issues. I have two separate zaps running concurrently one zaps a data dump of information (from go canvas) onto a spreadsheet as a new row.

My second zap will then send an email if there is an issue with a field in the column.

Whenever I set these up I always get the error message on the filter without fail, however the email may work 8/10

The types of filters I'm applying are as follows:

  1. Number >1.99
  2. Contains "Not" or Equals “Not OK” - same issue for both
  3. Set up True booleans to trigger it and it is sporadic also.

Could this be because spreadsheet is updating more than 1 row in google sheets and is instantly trying to run a zap to email information hence cancelling each other out?

Is there a way to make this work every time, or more smoothly?

icon

Best answer by Liz_Roberts 19 August 2020, 17:53

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

nicksimard
Userlevel 7
Badge +11

Hi @jdmillar!

It would be super helpful if you could provide some examples of what came into the filter, what that filter is set to do and then the result not being what you would have expected. 

So if you have it set up to filter for numbers greater than 1.99 and 2.5 came in but it got stopped by the filter, for example. Screenshots would be great, as long as they don’t contain any personally identifiable information.

Thanks!

J

Hey @nicksimard 

The best example I can give is below

I have a pre-start checklist in GoCanvas which prompts the user to answer OK or Not OK if the specific item is at fault. This will then auto populate every result on a google sheets database as below:

Most submissions will be adding approximately 19 rows of data to the spreadsheet in google drive.

I then have another zap that is filtering the ‘Evaluation’ Column in order to send an email when it is deemed ‘Not OK’

 

 

This will work sporadically, however if there were 3 Not OK rows updated in one batch, it might miss a few. When I test the zap I always get the ‘would not continue’ error message, but this is something I seem to get  with all of the filtered outlook zaps I'm doing. I seem to get better results when filtering by number.

I have also tried setting up my sheets with True/False booleans to update and have the same issues. Just wondering if I am doing something wrong that is preventing full functionality?

Thank you

Liz_Roberts
Userlevel 7
Badge +8

Hi @jdmillar ,

Thanks for the example! In this instance, our Support team would be best suited to assist as they can take a look at your specific configuration to troubleshoot.

You can reach them here and they’ll be happy to get you squared away!

Terms & Conditions