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
Create Member in List on Form Submit
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
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
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.
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
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
See Mailchimp List
You can see a new member in the Mailchimp list