Mail Merge from Google Form Responses (Gmail + Sheets)

Q: 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. The add-on reads addresses from a column headed exactly Email, so copy the Form's Email Address column into an Email column on your mail merge tab.

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

Link the Form to a Sheet and open the responses spreadsheet.
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). Forms names that column “Email Address”, but the add-on reads addresses from a column headed exactly Email.
Make a mail merge tab. Leave the Form’s own tab as it is. On a new tab, type Email, First Name, Last Name and Mail Merge in cells A1 to D1 (the add-on looks for these four headers in the first four columns), then add short headers for the answers you need, such as “Session” or “Score”, from column E. Copy each respondent’s address and answers into it, or pull them in with formulas that point at the responses tab.
Open Mail Merge for Gmail and Sheets on that tab (Extensions → Mail Merge for Sheets™ Gmail™ → Launch).
Write your template as a Gmail draft. Insert placeholders from the answer columns where they add context.
Check the rows for empty answers and long text.
Send a test. Send Test Email sends one message to you, filled with row 2’s data. 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.” An empty cell becomes empty text, so fill in blanks in the Sheet before you send and 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 — attach it to your Gmail draft and every respondent gets it. Open and click tracking (on every plan) then shows who opened the confirmation: the add-on writes EMAIL_SENT in the Mail Merge column, and EMAIL_OPENED or EMAIL_CLICKED after you click Refresh Email Status. A follow-up to anyone who missed it is a separate send you set up yourself. For different files per respondent (for example, a unique certificate), personalized attachments on paid plans match Google Drive files to each person by the email address in the file name; see the attachments guide linked below.

Emailing new responses as they arrive (and limits)

The add-on doesn’t watch your Form and has no trigger for new responses, so new respondents are not emailed automatically. When new rows come in, add them to your mail merge tab and run the campaign again yourself: rows that already have a status in the Mail Merge column are skipped, so only the new respondents get the email. Google’s daily quota still applies: about 100 recipients a day on a @gmail.com account and 1,500 on Google Workspace. For high-volume forms, lower “Maximum emails per launch” and run the campaign again later 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), copy the respondents’ addresses and answers to a new tab with the headers Email, First Name, Last Name and Mail Merge in A1 to D1, write a Gmail draft using the answer columns as placeholders, launch Mail Merge for Gmail and Sheets on that tab, send yourself a 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. The add-on reads addresses from a column headed exactly Email, so copy the Form’s Email Address column into an Email column on your mail merge tab.

Can I attach a confirmation PDF to each email?

Yes. Attach the PDF to your Gmail draft and every respondent gets it. For a different file per respondent, personalized attachments (paid plans) match Google Drive files to each person by the email address in the file name.

Will it email new respondents automatically?

No. The add-on has no Google Forms trigger. When new responses arrive, add them to your mail merge tab and run the campaign again: rows that already have a status are skipped, so only new respondents are emailed. Google’s daily sending quota still applies.

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 →