In MailChimp v4.2, we’ve added a number of list import options, including Google Docs, Google Contacts and Google Forms. Google Forms is a powerful and free tool that you can use to quickly and easily create a custom signup form that links directly to your MailChimp account.
To begin, you’ll want to head over to Google Docs and login using your Google account information. Then, under the New Document menu, select Form. Go ahead and give your form a name and then include some information as to what the signup form is for or about.
From there, you’ll begin adding fields. By default, the blank form starts out with two “Sample Questions” for you to modify. For this example, we just added a separate field for First Name, Last Name and Email Address, and went ahead and made them all required fields. It’s also important to ensure that you select “Text” for the Question Type.
Once you have your fields created and organized the way you want them, you can work on changing the visual design of the signup form. Google Forms is pretty limited in this aspect, but they currently provide 69 different stock themes for you to choose from.
Since we’re creating a signup form for our burgeoning Picnic Club, we went with the “Picnic” theme. To see how this will look once it’s published, just click on the link at the very bottom of the Form Edit page. This will open a preview of your published form in either a new tab or a new window, depending on how you have your browser set up.
The second part of this tutorial is setting up MailChimp to import your signup form into a new list. First, login to your MailChimp account and click the Account link at the top left. This will take you to your account settings, and you want to click on Integrations.
Click on the first option: Google Analytics, Contacts, Docs and select Authorize Connection. This will take you away from your MailChimp account and over to Google (very briefly), and you will need to click Grant Access.
Once you click Grant Access, you’ll be taken back to your MailChimp Integrations page. You’ll see a green dot for your Connection Status, but may see a yellow dot representing Data Status. This is fine for now.
The next step is to head over to your Lists, and you want to click the huge orange button to Create a New List.
On the first page, you’ll need to go ahead and set up all the basic information, such as Sender Name and Permission Reminder. Next, select the Import My List option, and then select the source that you want to import from. In this case, Google Docs.
A dialog box will appear, telling you that MailChimp can connect to your Google Docs account. Just select the appropriate Form from the pull-down menu, and proceed with list import.






If I hadn’t seen this post, I wouldn’t have known about the Forms. I’ve been sending interview questions to musicians pasted on email when all the while this option was available. thanks!
thank you – this helped me loads!
yea… this really saved me alot!
Thanks this is a huge time saver for us – like many ppl we keep our contact list in a google spreadsheet. But here’s the curve-ball – our contact list is constantly changing. We are either removing or adding or updating the spreadsheet – is there any way that mailchimp lists will automatically reload the data from our google doc?
That would be sa-weet! This would be a very powerful feature to support b/c it would mean my mailchimp lists would always be up to date with zero extra effort.
Please help! we are almost there
Thanks in advance
~Badi
Hi, do you know if I can use GoogleDocs integration with MailChimp with my site created with GoogleSites? GoogleSites seems to have a lot of limitations, but it would really help me out if you know for certain if I can use MailChimp and this integration with it and not fear violating some Google policy or something won’t work…
Any answer to Gary’s questions?
I tried to do this and it doesn’t work
I am really careful about not importing, because these people may not have given me “permission” to send an email. I would however, like to put in groups (segments) not getting my customer email, but other announcements. Can I import certain names to segments. I do get emails from other groups I am in and really appreciate the professional look.
Also, I would like to put just first and last name, but when I try to enter a name myself, it has all fields and says I must fill address fields out. Help?
I’m also trying to set up an auto-import between a Google Form and my MailChimp list. I need to figure this out before I can make dcacm.wordpress.com into our main website, dcacm.org.