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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

Zap filters fault - Google Sheet to Mailchimp

S

I have a collection of Spotify playlists that artists submit their songs for consideration. Each time I receive a new submission, a Google sheet is updated with the relevant information. Once I have decided which playlist the song will added to, I add a tag which I hoped Zapier could send to Mailchimp to distribute a specific email to each person who submitted.

I setup individual zaps for each playlist so when the trigger contained the exact keywords, it would send the tag to mailchimp.

Unfortunately in the second part at “only continue if” when testing it says it has a “missing value”. I do not alway add a keyword to each cell in the selected column from Google sheets as can be seen below. 

Column e is where I add the keyword. How can I fix this as I setup for it only to trigger for the keyword “no” when the text exactly matches it.

icon

Best answer by ponvaskon 8 July 2020, 18:50

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

ponvaskon
Userlevel 3
Badge

Hi Sandford,

As I understood, you have such an automation workflow:

  1. The trigger is a new or updated spreadsheet row. 
  2. Filter that looks up into the column E (playlist) and continues only if it exactly matches the tag value.
  3. Add a subscriber to tag in Mailchimp.

In your case, the playlist cell should contain the "No" value to proceed. So, you have to add it to the cell if you want to use the exact match logic.

Best Regards,

Vasyl

Business Automation & Apps Integration expertise: creation of complex, multi-step automations; integration of applications into a single ecosystem; optimization and debugging of existing integrations and automations. Please feel free to contact me if any help needed - vp@upscaleninjas.com.
S

Hi Vasyl

 

Thank you very much for replying and I understand your response. Are you saying that if I add no to the test cell then it should work fine as it just needs to pass the test?

Not all the cells will contain “no” as I have other tags I will also be using.

ponvaskon
Userlevel 3
Badge

Hi Sandford,
You are welcome! Correct, if you will add the "No" value, the test should be successful.
Don't worry about such kind of responses from Zapier when testing zaps. If you see that from the logical side everything should work, it will work even if you didn't have the test data when you created the zap.
Best Regards,
Vasyl

Business Automation & Apps Integration expertise: creation of complex, multi-step automations; integration of applications into a single ecosystem; optimization and debugging of existing integrations and automations. Please feel free to contact me if any help needed - vp@upscaleninjas.com.
Terms & Conditions