Skip to main content
Best answer

Updating a merge field in MailChimp but not the first and last name

  • April 19, 2023
  • 2 replies
  • 159 views

Atifexual

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!

Best answer by jayeshkumarbhatia

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.

 

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

jayeshkumarbhatia
Forum|alt.badge.img+7
  • Zapier Solution Partner
  • Answer
  • April 19, 2023

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.

 

 

 


Atifexual
  • Author
  • Beginner
  • April 19, 2023

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! :)