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.

Hi there,

I would like add tags in mailchimp according the client answer at a checkbox question from Google Form.

The client can check all boxes or only several of them.

On Zapier, when i extract the google form, for this checkbox question i obtain a text with coma.

I would like add a tag for each box checked.

Exemple to be more clear:

ON GOOGLE FORM, the client selected

A1
A2
A8
A12


ON ZAPIER EXTRACT, i have these answere in one text, like this : A1, A2, A8, A12

I want add tag in Mailchimp for this client with all answere he gave:

He aswered A1 => i want add the tag AM1 on Mailchimp
+
He aswered A2 => AM2 on Mailchimp
…


But an other client can anwser A4, A7, A12. So i want to add tags AM4, AM7, AM12 for this client.

 

Could you explain me how can i do that ?

 

Thanks a lot

Hi @Remi de bougetoilecul.fr 

Good question.

Try adding a lookup table.

Formatter > Utilities > Lookup Table

This Zap step works with line items.

Hi Troy,

 

Thanks for your answer.

I tried this, but…

I will include some print screen to show you my results.

 

First test :

I used the Look up Table with the answer of my client. But Zapier detecte nothing (see the 2 print screen below)

 

 

 

 

Second test :

I tried to reformat the answer of my client in “text to line-item” and after make a look up table with the result of "text to line-item".

The result is only the first answer of my client is detected by Zapier. But i need all his answer and i want to add 1 tag by answer (see the result below by print screen)

 

ACTION 1

ACTION 2 

 

 

So, no one of these tests is working as i want.

 

Thanks in advance for your help 😃 

@Remi de bougetoilecul.fr 

This worked with line items when I tested. (see screenshots below)

 

Otherwise, you can try these options to do the data translation.

  1. Ask AI: ChatGPT / OpenAI
    1. Prompt AI
    2. Guidance:

       

  2. Code step
    1. Within the Code step you can generate code with the help of AI
    2. OR you can ask ChatGPT to help you generate the code

 

 

 

Terms & Conditions