How to send bulk emails with personalized google forms prefill link?

"How could I use my email list from google sheets"- Google Docs Editors Community

This is a common question from Google Workspace users who keep their contacts in Google Sheets. For example, you might want feedback from your recent customers while their memory is still fresh. You want to send them a feedback form you built using Google Forms. Google Forms lets you prefill the form one at a time and then send it to your customers. You can use a mail merge add-on instead, but prefilling the form is still a pain. With Formfacade, you can select the list of customers and then send bulk emails to them with individual prefilled links. Your customers will see a feedback form with their details already prefilled. Even better, the form will have your own branding instead of Google's, but the responses will be collected on your Google Forms. This way, you can sync the responses to Google Sheets and share them with your team who are comfortable with Sheets.

Let's start. Create your form and follow the steps below.

How to add your customers?

  • On the page that opens, name your form, click Create form and click Proceed.
  • Once you create the form, you will land on the form's "Edit" tab. If it asks "Do you want to prefill this form and send them as email to your contacts?", click No.
  • Click on "Share" tab
The tabs Edit, Preview, Share and Responses, with Share marked
  • Click Add contacts under More options
The More options panel on the Share page, with Add contacts marked
If this is your first day and you do not see Add contacts, it will show up once your form has 2 responses.
  • Contacts page will be displayed with no contacts
  • Click Add contact, then click Add new contact
The Contacts page saying No contacts available, with the Add contact menu open and Add new contact marked
  • Enter the name and email of the customer and click Save
  • Do this for each customer
The Add contact panel with Maria Lopez and maria@example.com filled in

How to import your list from Google Sheets?

  • In the Contacts page, click Add contact, then click Import contacts
  • Click "this google sheet" in the popup. Your contacts sheet will open.
  • Enter the email, name and phone for all the customers
  • The first time, click Extensions > Add-ons > Get add-ons, search for "Formfacade - Prefill & email" and click Install
  • Click Extensions > Formfacade - Prefill & email > Import contacts
  • Click "Sync now" in the panel on the right

How to send bulk emails with prefilled links?

  • In the Contacts page, click on the checkbox to select all customers or select a specific set of customers
  • Click Compose
The Contacts page with 3 customers ticked and Compose (3) marked
  • Email page will be displayed with the selected customers
  • Click Send email to send the emails to the selected customers
The Email tab with the 3 customers in To, the message and Send email marked
Each customer gets the email with their name in it and their own link. When they click on it, the form opens with their name and email already filled in.

Summary

If your list is already in a Sheet and everyone needs their own prefilled link, making the links one at a time takes too long. With Formfacade, you select the list of customers and send bulk emails to them with the prefilled link. Create your form and complete the steps above. If you have any questions, write to support.

Last updated: