GPT for Google Sheets, Docs AI, Slides, Forms

Mail Merge from Google Form Responses (Gmail + Sheets)

Turn Google Form responses into personalized emails. Step-by-step mail merge from the linked Google Sheet — merge answer columns, add attachments, track sends, and respond at scale.

Mail Merge from Google Form Responses (Gmail + Google Sheets)

Collecting signups, applications, or RSVPs through Google Forms — and now you need to email each respondent a personalized reply? Because every Form feeds a linked Google Sheet, you can run a mail merge from Google Form responses in minutes: use the answer columns as merge fields and send a tailored Gmail message to each person. Mail Merge for Gmail and Google Sheets is built for exactly this Sheet-in, Gmail-out workflow.

Turn Form responses into personalized emails — start free →

Google Forms, Google Sheets, and Gmail are trademarks of Google LLC, used here descriptively; this page implies no affiliation or endorsement.

Why send personalized emails to Form respondents

A generic “thanks for submitting” auto-reply is fine for a receipt, but it cannot reference what someone actually answered. A mail merge from the responses sheet lets you:

  • confirm an event or appointment with the specific date/time the person chose;
  • acknowledge an application and restate the role or program they applied to;
  • send a tailored resource based on a respondent’s selection or score;
  • reply to survey participants with relevant next steps.

Personalized replies feel like real communication, lift open and reply rates, and scale to hundreds of respondents without manual copy-paste.

How Google Forms feed a linked Google Sheet

Every Google Form can write responses to a Google Sheet. In the Form editor, open the Responses tab and choose Link to Sheets (or “View in Sheets”). Each submission becomes a new row; each question becomes a column, plus an automatic Timestamp column. That responses sheet is the data source for your mail merge — including the respondent’s email address, either captured automatically by the Form or asked as a question.

Step-by-step: mail merge from the responses sheet

  1. Link the Form to a Sheet and open the responses spreadsheet.
  2. Confirm an email column. Make sure each row has the respondent’s email address (enable “Collect email addresses” in Form settings, or add an email question).
  3. Tidy the headers. Rename long question headers to short, clean merge-field names (e.g., “First name”, “Session”, “Score”).
  4. Open Mail Merge for Gmail and Sheets on that responses sheet.
  5. Write your Gmail template. Insert merge fields from the answer columns where they add context.
  6. Preview rows to check empty answers and long text.
  7. Send a test to yourself, then send to the respondents.

Personalizing with answer columns (name, choice, score)

Treat each question column as a variable. A confirmation email might read: “Hi {{First name}}, you’re registered for the {{Session}} workshop on {{Preferred date}}.” A results email might say: “Your quiz score was {{Score}} — here’s what to review next.” Only merge fields that have a value in every row you send to; guard against blanks so no message reads “Hi ,”.

Adding attachments (e.g., a confirmation PDF) & tracking

If respondents should receive a document — an event ticket, a confirmation PDF, an information pack — you can include an attachment with the send. Open and click tracking then show you who opened the confirmation, so you can follow up with anyone who missed it. For different files per respondent (for example, a unique certificate), see the per-recipient attachments workflow linked below.

Automating sends as new responses arrive (and limits)

You can re-run the merge periodically to email new respondents, sending only to rows you have not contacted yet (a simple “Sent?” column helps you track this). Whatever the cadence, Gmail and Google Workspace sending limits still apply — automation works within those caps, not around them. For high-volume forms, batch sends across the day rather than firing hundreds at once.

Example templates

Event confirmation

Subject: You’re confirmed for {{Session}} Hi {{First name}}, thanks for registering. You’re confirmed for {{Session}} on {{Preferred date}}. We’ll send a reminder the day before. Reply to this email if you need to change anything.

Application acknowledgment

Subject: We received your application for {{Role}} Hi {{First name}}, thank you for applying to {{Role}}. Your application is in review and we’ll follow up by {{Decision date}}. In the meantime, feel free to reply with any questions.

Send personalized replies to every respondent — start free →

Mail merge from Google Forms FAQ

How do I mail merge from Google Form responses?

Link your Google Form to a Google Sheet (Responses → Link to Sheets), make sure each row has the respondent’s email, open Mail Merge for Gmail and Sheets on that responses sheet, write a template using the answer columns as merge fields, preview, test, and send.

Do I need an email address column?

Yes. Enable “Collect email addresses” in the Form settings, or add an email question, so every response row includes an address to send to.

Can I attach a confirmation PDF to each email?

Yes. You can include an attachment with the send. For a different file per respondent, use a per-recipient attachments workflow keyed from a Drive-link column in the sheet.

Will it email new respondents automatically?

You can re-run the merge to email new rows, sending only to people you have not contacted yet. Sends still operate within Gmail/Workspace daily limits.

How do I keep these emails compliant?

Email respondents only about what they submitted, keep messages relevant and non-spammy, include opt-out where appropriate, and respect privacy and sending limits.

Reply to every respondent — at scale

Your Form responses are already structured data in a Sheet. Turn them into personalized, on-topic emails with a quick test send first, then use Mail Merge for Gmail and Sheets to handle the volume.

Try Mail Merge for Gmail and Sheets →