Separate First Name, Last Name in Zapier for MailChimp Subscribers

Use Formatter by Zapier to Separate First and Last Name Fields

MailChimp Lists prefer Subscriber Names to be separate fields: "First Name" and "Last Name"

Squarespace Forms, left unchanged, use a combined "Name" field.

Using Formatter by Zapier, you can separate the "First" and "Last" name segments from the "Name" field, and assign them to the correct MailChimp fields. 

 

Formatter - Get First Name

Inside of your Zap, placed before the MailChimp Action create a "Formatter" Action to grab the "First" name. 

Inside of the Formatter Action, use Transform:Split Text and set the Input to the "Name" field from Google Sheets. Leave the rest of the options at their default values.

RECOMMENDED: Rename this Formatter "Get First Name" for ease of use later

 
 

Formatter - Get Last Name

Create another "Formatter" Action, after the first, to grab the "Last" name. 

Inside of the Formatter Action, use Transform:Split Text and set the Input to the "Name" field from Google Sheets. Leave the Separator options at their default values. Set Segment Index: Last

RECOMMENDED: Rename this Formatter "Get Last Name" for ease of use later

 

MailChimp Field Assignments

Now, in the MailChimp Action, you can assign the Outputs of these two Formatters to the "First Name" and "Last Name" fields, by:

  • Under "First Name", click the Dropdown and choose the "Get First Name" formatter, then click the variable below that:
 
  • Under "Last Name", click the Dropdown and choose the "Get Last Name" formatter, then click the variable below that:
 

Then you can complete the Zap as you would normally. Pretty cool, right? 

 Zapier-First-Name-Last-Name-Split-Formatter