Mailchimp
Google Forms + Mailchimp Integration
Create MailChimp member/contact from Google Form submission
How to integrate your Google Form with Mailchimp?
You can integrate Google Forms with Mailchimp using Form Director. Form Director enables you to connect Google Forms with Mailchimp, allowing you to create member/contact based on form responses.
When a user submits a Google Form, the responses are automatically sent to Mailchimp, where member/contact are created accordingly.
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.
Installation:
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
Authorize
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
Mapping
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.
Notification
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.
Attachment
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