Skip to main content

UPDATE: I solved this. 

=====

Hi,

I want to update a merge field in MailChimp using data from a Google Sheet.

When I choose "Add/Update Subscriber," I don't want to overwrite the First Name and Last Name of the Subscriber. However, since these fields are mandatory, I'm having trouble figuring out a workaround for this.

Thanks!

Hey @Atifexual ,

 

I can suggest a solution to you. 

 

Use Find or Create subscriber action on mailchimp with First Name, Last Name and Email.

Than use Google Sheet action - Lookup row in Google Sheet. If not than create the row and add first name, last name and email

Than use Update Subscriber in Mailchimp and use first name and last name from Google Sheet.

 

 

 


Hey @Atifexual ,

 

I can suggest a solution to you. 

 

Use Find or Create subscriber action on mailchimp with First Name, Last Name and Email.

Than use Google Sheet action - Lookup row in Google Sheet. If not than create the row and add first name, last name and email

Than use Update Subscriber in Mailchimp and use first name and last name from Google Sheet.

 

 

 

thank you! :)