Chapter 2 · Products
Prefill & email
Prefill Google Forms and send them as email. Make a named prefill link for a group, or email each contact their own link, and lock or hide the answers you prefill.
Quick Answer
How do I send a Google Form with answers already filled in?
Import your Google Form with Prefill & email. In the Share tab, use Create prefill links to make a named link with answers filled in, then copy it and send it. To email each person their own link, add them under Add contacts, click Compose, and send. Set a question's Appearance to Read only or Hidden so people can't change what you prefilled.
Prefill & email fills in the answers you already know, so people only answer
the rest. Unlike a Google Forms prefill link, the link carries only a name you
choose, such as near.tl/sm/AbC12dEf/intro-to-sheets. The values aren't in the
address, and you can lock them or hide them.
This guide follows one example: feedback for a workshop called "Intro to Google Sheets", where the workshop details are prefilled and locked.
How do I start?
Click Try it free on the Prefill & email page. The wizard has three steps: Import Google Form, Prefill this form, and Send prefilled links. To build a new form from its name or a PDF, click ← and pick another way to start.
When you name a new form, Formfacade asks Who are the prefilled links for?
| Choose | You get | Use it for |
|---|---|---|
| Contacts | A link for each person, with their name and email filled in | Renewals, follow-ups, anything personal |
| Groups | One named link, such as a promo code or a region | A workshop, a branch, a campaign |
How do I stop people changing a prefilled answer?
Every question is editable by default. Lock or hide it before you share:
- On the Edit tab, click the question, then its gear icon.
- Click Answer and change Appearance:
- Read only: people see the value as plain text and can't change it.
- Hidden: the question isn't on the form, but its value is saved with the response.
- Click Save.
Prefill every required read-only question
A read-only question has no answer box. If it's required and the link doesn't fill it in, people can't submit the form.
Question settings covers every Appearance option.
How do I create a secure prefill link?
Open Create prefill links
Click the Share tab. Under More options, click Create prefill links, then + Create new prefill.
Name the link and fill in the answers
Enter a Link name. Spaces become hyphens, so use letters, numbers, and hyphens. Fill in the answers you want prefilled, then click Create prefill link.
If you fill in a name or email here, it's replaced by each contact's own details when you send the link by email.
Copy the link
The link appears under Group prefill links. Click 3 fields to see what it fills in, Preview to open it, and Copy link to share it. The ⋮ menu has Compose email, Edit, and Remove.
What do people see when they open the link?
The form opens with your answers in place. Read-only answers show as plain text. Editable ones are filled in, and people can change them.
How do I send bulk emails with a personalized prefill link?
Add your contacts
Click the Share tab, then Add contacts under More options. Click Add contact, then Add new contact. Enter a Name and Email (required) and click Save.
To bring in a list, choose Import contacts instead. It opens a Google Sheet: add your contacts there, click Extensions > Formfacade - Prefill & email > Formprefill, then Sync now.
Compose the email
Tick the contacts you want, or click ⋮ > Compose on one contact.
The Email tab opens with To, Subject, and Message filled
in. The message uses ${name} for each person's name and
${prefilllink("Click here")} for their link. Click Prefill form to
choose the answers in the link, then Create prefill link.
Send
Edit the message if you like, then click Send email. The subject and message are saved under Mail template for next time. Each person gets their own link, with their name and email filled in.
Where do the responses go?
Prefilled answers are saved with each response, including hidden ones. See them on the Responses tab, or link a sheet in Google Forms and Sheets. Each contact's ⋮ > History shows what was sent to them.
Questions
Does Formfacade support pre-filled links like native Google Forms?
Yes. The difference is the link: a Google Forms prefill link carries every value in its address, while a Formfacade link carries only its name.
How do I edit the message before sending the email?
Change the Subject and Message in the Email tab before you click
Send email. Keep ${prefilllink("Click here")} in the message, or the
email won't include the link.
How do I connect two Google Forms?
Use the answers from the first form to prefill a link to the second. The step-by-step guide compares four ways to do it.
How do I set a field as protected health information?
On the question's Question tab, tick Mark this as Protected Health Information. See Question settings.
Next steps
- Lock, hide, or calculate answers: Question settings.
- Fill answers from a spreadsheet as people type: Autofill fields.
- Email each response after submit: Email notification.