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.

Three ways to start. Start a form explains each one.

When you name a new form, Formfacade asks Who are the prefilled links for?

1 Contacts: one link for each person, sent by email. 2 Groups: one named link you share with many people.
ChooseYou getUse it for
ContactsA link for each person, with their name and email filled inRenewals, follow-ups, anything personal
GroupsOne named link, such as a promo code or a regionA 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:

  1. On the Edit tab, click the question, then its gear icon.
  2. 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.
  3. 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.

Open Create prefill links

Click the Share tab. Under More options, click Create prefill links, then + Create new prefill.

1 Share, then 2 Create prefill links.

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.

1 The link's name, 2 the answers to prefill, 3 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.

1 The prefilled answers, 2 Preview, 3 Copy 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.

1 Read only: shown, not editable. 2 Editable: filled in, can be changed.

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.

1 Add contact, or 2 Compose an email to a 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

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