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.

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.

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

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.

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

Terms & Conditions