Tech‎ > ‎

How to Use Google Forms to Gather Mailing Addresses

posted Jul 12, 2016, 2:12 PM by Anjuan Simmons   [ updated Jul 21, 2016, 4:43 PM ]
I received a question about gathering mailing addresses for sending holiday cards from a friend:

Hi Anjuan - I'd like to tap into your expertise. I've always used Plaxo for maintaining addresses, but they were wiped out. As I prepare to send holiday cards to my huge family, I need a tool/app. But I don't want to have to enter every address myself. Is there a good tool/app that I can use to send to my family and ask them to upload their info for me to have?

Here's my response:

Hi, I like this question because it is a problem I need to solve myself! I've searched for online solutions, but I think the best one is free and easy to use: Google Forms.

You probably don't use GMail, but you can create a Google account which gives you access to Google Drive (Google Forms is a service in Google Drive). You can create a form with fields like "First Name", "Last Name", "Address Line 1", "Address Line 2", "City", "State/Province", "Country", etc. You can then email a link to the form to your friends and family and ask them to fill it out.

Their responses will be recorded in a Google Drive spreadsheet which you can download in Excel format. You can then use this Excel spreadsheet for your holiday card list. 

Also, you can go to the next level and use third party sites that let you create greeting cards from templates or custom photo cards. Some of them will even scan your spreadsheet of addresses and do a mail merge which will automatically address and stamp the envelopes. You'll just need to stuff, seal, and mail them out. I think some may even mail them for you to their target addresses.

You can see a form I created to gather information to update my holiday card mailing address spreadsheet here.