Someone told me I could use Zapier to automate this task. I attempted, but quickly got lost.
I have an Airtable tab that has one column for Event, another column for team names (separated by commas) and a third column for member emails (separated by commas).
I think I can figure it out if the record has only one name and email in it, but not sure how to navigate with multiple information. Can Zapier be configured to look in specific columns and create new lines for each email (separate them itself)? Will I need another Zapier to first convert AT to Sheets, then from Sheets to MailChimp?
Is this making sense?
Column 1 (Event) = Wok this Way
Column 2 (Members) = John Doe, Jane Doe
Column 3 (Emails) = firstname.lastname@example.org, email@example.com
I want to be able to add/update two subscribers in Mailchimp:
firstname.lastname@example.org John Doe [tag: Wok this Way]
email@example.com Jane Doe [tag: Wok this Way]
Best answer by christina.dView original