Google Forms + Mailchimp Integration

Create MailChimp member/contact from Google Form submission

What is Form Director?

Form Director is a Google Workspace add-on that directs data submitted from Google Forms to applications like Google Docs, Forms, Sheets, Contacts, Calendar, Tasks, Email, Trello, Slack, QuickBooks etc.


It is available in the Google workspace Marketplace.

Please check installation instructions to install the add-on.

What is Mailchimp?

Mailchimp is a marketing automation platform and an email marketing service.

Get the Tools You Need to Grow Your Business and Automate Your Marketing. Mailchimp Makes It Easy to Find New Audiences and Reach People When It Matters Most. Predicted Demographics. Audience Targeting. Multi User Account Access. Remarketing Ads. Real-Time Data Reports.

Google Forms to Mailchimp: Use Case(s)

> Create Member in List on Google Form Submission

Google Forms

Create Member in List on Form Submit

Form Director

Demo Video: How to add member in MailChimp list from Google Form?

Setting up Mailchimp in Form Director

  • Choose Mailchimp from the list of apps

  • Name your service

  • Choose Create Member under services

Configuring Mailchimp


  • Click on Connect to Mailchimp to Authorize

Login with credentials

  • Login with your credentials to authorize

Inputting Data Center Id

  • Provide your Data Center id (Usually starts with US)

Where can you find your Data Center Id?

You can see the Data Center in the url, once you have logged in

  • Once you enter the data center id Click on Get Lists to get your lists

Choosing List

  • Choose the list from the dropdown in which you need to create member


  • Click Setup Mapping and setup the mapping.

  • Mapping of form fields to that of app fields is to be done in order to create member on form submission.

  • Click on the add icon to add new mapping

  • Once you have done mapping you can save the service

  • Note : Mapping should be done between app field and form field of same type.


  • Notify your audience with success or error notifications.

  • Switch on Send Email to send email during execution.

Email Template

  • Send your own customized emails on form submission to your audience.


  • Select the attachment to email from file upload in Google Form.

  • Click Pick Drive Files to attach files to Email.

Finish setting up

  • Save service

You are all set to create member in Mailchimp list on your Google Form submission

Submit the Form

Submit the Google Form

Note : App field Status is mandatory for creating Member and it can have the following values and the values are case sensitive

  • subscribed

  • unsubscribed

  • cleaned

  • pending

See Mailchimp List

You can see a new member in the Mailchimp list