Mail merge guide

Mail merge from Google Sheets with Gmail

When your recipients and message fields already live in Google Sheets, a mail merge should stay close to that data. FormMerge turns sheet rows into personalized Gmail messages with merge tags, test sends, batch delivery, and row-level status tracking.

Quick answer

To run a mail merge from Google Sheets with Gmail, prepare one row per recipient, keep column headers stable, write a subject and body with merge tags, send a test email, then run the batch only after the preview is correct.

Best source sheet

Use clear columns such as Email, First name, Status, Amount, Date, or Next step so merge tags stay readable.

Best first run

Send one test message to yourself before sending to real recipients. It catches broken tags and wrong recipient columns early.

Good use cases

FormMerge is strongest when the message is operational and tied to records your team already reviews in a spreadsheet.

Program updates

Send personalized status updates, next steps, or reminders to applicants, students, members, or event participants.

Form follow-up

Use rows collected from Google Forms as the starting point for a controlled outbound email batch.

Internal operations

Email owners, reviewers, or assignees with row-specific details pulled from the sheet.

Small batch outreach

Send careful, personalized messages from your own Gmail account while keeping status visible in Sheets.

Setup path with FormMerge

  1. Open the Google Sheet that contains the recipient list.
  2. Confirm each recipient has one row and the email column is complete.
  3. Install FormMerge and open it from the spreadsheet.
  4. Write the subject and body using column-based merge tags.
  5. Send a test message to check formatting, personalization, and sender behavior.
  6. Run the batch and review status in the sheet after sending.
This workflow is for practical, permission-aware operational email. It should not be used for unsolicited bulk mail or messages that violate Gmail or Workspace sending rules.

Preflight checklist

Recipient column

Make sure the email column contains only the people who should receive the message.

Merge tags

Use column names that are easy to read and avoid duplicate headers.

Gmail limits

Keep your batch size aligned with your Gmail or Workspace sending limits.

Status review

After the run, review sent and failed rows so nothing important is missed.

FAQ

Can I use FormMerge with data from Google Forms?

Yes. If Google Forms writes responses into a linked sheet, that sheet can become the source for follow-up email after you confirm the recipient and merge columns.

Should I test before every batch?

Yes. A test send is the fastest way to catch a wrong recipient column, a missing merge tag, or formatting that looks different in Gmail.

Can I track status in the spreadsheet?

FormMerge is designed to keep send status visible from the sheet, so operators can review sent, skipped, or failed rows after a run.

Is this a marketing automation platform?

No. FormMerge is a lightweight spreadsheet-based email merge tool for practical Gmail workflows, not a full CRM or campaign automation suite.