Best answer

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

  • 19 April 2023
  • 2 replies
  • 123 views

Userlevel 1

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!

icon

Best answer by jayeshkumarbhatia 19 April 2023, 18:11

View original

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

Userlevel 6
Badge +6

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.

 

 

 

Userlevel 1

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