Google Sheets to Gmail

Send an email to each row in Google Sheets

When each row in a spreadsheet represents a recipient, FormMerge can turn the row data into a personalized Gmail message with merge tags, a test send, batch delivery, and row-level status.

Install FormMerge Open setup guide Personalized email guide

Quick answer

Prepare one row per recipient, keep an email column and clear merge-field columns, write the message template, send one test email to yourself, then run the batch only after the preview is correct.

Best sheet layout

Use columns such as Email, First name, Program, Amount, Date, Status, and Next step so the message template stays readable.

Best first send

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

This is best for operational messages such as confirmations, reminders, applicant updates, internal handoffs, and small batch follow-ups.

Setup pattern

Clean the Google Sheet so every row has one recipient and one valid email address.
Open FormMerge and choose the recipient column.
Write the subject and body using merge tags from the column headers.
Send one test email and inspect the rendered message.
Run the batch and review row-level send status in the sheet.

Before you send the batch

Recipient column

Confirm the email column is the real destination and not a helper or alternate contact field.

Merge tags

Check every tag in the subject and body against the exact column headers in the sheet.

Small first batch

For a new workflow, send a tiny batch first instead of the full list.

Status review

Use the send status columns to see which rows were sent, skipped, or failed.

Next steps

Install from Marketplace FormMerge support Mail merge from Sheets with Gmail Personalized email guide More workflow guides