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 created a Zap to automatically transfer any new contact added to a Google sheet to Mailchimp. So when a new row is created a Zap occurs.
One of the columns is a filter of predefined values you have to select from. I tested it out and the Zap works, however it copies all the filter values (5) instead of the 1 had selected.
Appreciate any help.

Hi ​@KOTL 

For us to have more info, post screenshots showing:

  • how your Zap steps are outlined and configured in EDIT mode with the field mappings visible
  • the top 3 rows of your GSheet worksheet

Hi ​@KOTL,


We just wanted to see how everything is going with your Zap. If you need any assistance, feel free to reach out. 

We're happy to address any concerns and assist you.

The worksheet and the dropdown of filter option 
Only one tag was selected in the filter worksheet but all them were passed on to Mailchimp

 

Hi ​@KOTL,

 

To troubleshoot your Google Sheets to Mailchimp Zap, import all predefined values instead of the selected one, ensure the Google Sheets cell contains only the desired value, and map the correct column in the Zap. If the issue persists, add a Formatter by Zapier step to extract the specific value using the 'Text' transform and 'Extract' operation.

 

I hope this helps. Feel free to contact us if you need further assistance.

Thank you ​@JammerS could you show me a screenshot of the Google sheets set-up you suggest please?

Hi ​@KOTL, 

 

Here is a screenshot of an example Zap.

 

 

Reply


Terms & Conditions