I’m trying to add MailChimp audience to google sheet. I can select all the MailChimp columns except groups. Only way I can access groups by using these values but how can we access individual group values ?
If I use Merges Groupings it insert all group values together to google sheet column.
How can we add one group column of MailChimp to google sheet column ?
Best answer by SamB
View original
+14
Hi
Perhaps you can outline a specific example of how you are expecting the data to be sent to the GSheet to help give us better context on what you are trying to automate, thanks.
I’m trying to add MailChimp audience to google sheet. I can select all the MailChimp columns except groups.
In MailChimp I have User records like this .Patient type and entry product are group not a fields.
This my my zap (I have removed
irrelevant blocks )
I can access MailChimp merge values like this
The Issue is I can’t add Mailchimp group values corresponding to google sheet column because group values are not shown in MailChimp value list .As shown in the picture It only show group values for all groups not for individual groups. For example i can’t see anything like group->patient here.
Only way I can access groups by using these values but how can we access individual group values ?
If I use “Merges Groupings” it insert all group values together to google sheet column but not individual columns values.
How can I add one group column of MailChimp to google sheet column ?
+11
Hey
I’ve merged that duplicated topic into this thread so that we can keep the conversation going in one place! :)
In the screenshot of the sample data it appears to be a default sample from MailChimp so that might be why it’s not showing the fields as you’d expect. Can you try changing the selected sample in your Mailchimp trigger step to see if that then allows you to select the individual group?
+11
Ah ok, I think I can see the issue here now,
If so, and it’s a comma-separated list of values you’ll want to try using a Formatter (Text > Split Text) step to separate each value out into it’s own field.
And if it’s line items, then you could try using a Formatter (Utilities > Line-items to Text) action to split them into individual fields.
Hopefully that’ll do the trick and allow you to select those values individually for each column! :)
+14
Hi
Guide on using Line Items in Zaps: https://zapier.com/help/create/basics/use-line-items-in-zaps
Hi there!
My name is Lisa Orr and I’m a product manager at Zapier. We recently launched App Extensions a new tool that lets you build a custom action in the Editor.
We’re looking for users to join the App Extensions beta program, so if you want to learn more about building custom actions that fit exactly what you need, let’s chat.
I want to hear from you!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
