Write one email, and everyone on your list gets a version addressed to them. Mail Merge takes a draft from your Gmail™ account and a list in Google Sheets™, fills in each person's details, and sends the emails from your own address. Test it on yourself, send now or later, and see who opened and clicked right in the sheet.

QUICK START
Open any spreadsheet and choose Extensions > Mail Merge for Gmail Sheets > Try with an example. The add-on creates a sample list with you as the only recipient, a sample draft, and sends you a test email, so you see the whole flow in a minute.

HOW TO USE
1. Click Install and allow access.
2. Open a spreadsheet, then Extensions > Mail Merge for Gmail Sheets > Launch.
3. Click Check Sheet Setup. It adds the columns Email, First Name, Last Name and Mail Merge. Paste your contacts or import them. Add more columns, such as Company, on the right.
4. In your mailbox, write the email and save it as a draft. Put column names in double braces, for example "Hi {{First Name}},". The name must match the column header exactly. This works in the subject too.
5. In the sheet, click Start New Campaign and select the draft.
6. Optional: set a sender name or reply-to address. Open and click tracking is on by default.
7. Click Send Test Email. The test comes to you, filled in with the first row.
8. Click Start Campaign, or choose "Schedule for later" and pick a date and time.
9. Watch the Mail Merge column: EMAIL_SENT, then EMAIL_OPENED or EMAIL_CLICKED. Click Refresh Email Status for the latest.

FEATURES
- Any column can be a {{placeholder}} in the subject or body.
- Your draft's formatting, links and attachments are kept.
- Schedule in your time zone, or cancel a scheduled send from the report.
- Opens and clicks in the sheet, plus a Campaign Report.
- A different file for each person, matched by the email address in the file name (files from Google Drive™).
- Delay between emails and a cap per launch, to send long lists in batches.
- Rows already sent, or marked SKIP, are skipped when you run it again.
- Sent emails stay in your Sent folder; replies come to your inbox.

TRIAL, PLANS AND DAILY LIMITS
New accounts get 11 emails to try it, plus a few more during the first week. Tracking is included. Trial emails end with a one-line note about the add-on. Paid plans remove the note, raise your sending volume and add scheduling and personalized attachments: https://docgpt.ai/mail-merge-for-gmail-and-sheets/
Google limits how many recipients an add-on can email: 100 a day on personal accounts, 1,500 a day on Google Workspace™ accounts. The count resets 24 hours after your first send. If a campaign hits the limit, the remaining rows wait in the sheet and Mail Merge sends them automatically when the limit resets. Long lists are sent in batches, and an interrupted campaign can be continued with Continue Campaign.

WHO USES IT
Small businesses send invoices and payment reminders. Recruiters send interview invitations with a file for each candidate. Schools write to parents, nonprofits thank donors, and shops send welcome and abandoned cart emails.

PRIVACY
Your list stays in your spreadsheet, and emails go out through your own account. To report opens and clicks, our server records the recipient's address and the time of each open or click. Turn tracking off and no tracking data is collected. The add-on passed an independent CASA Tier 2 security assessment. Privacy policy: https://docgpt.ai/privacy_mail_merge

TROUBLESHOOTING
- Draft not listed: save it as a draft, then click Refresh.
- {{...}} shows in the email: the text in braces must match the column header exactly.
- A row says INVALID_EMAIL or "Error": check that row's email address; invalid rows are skipped and the rest are sent.
- Help center: https://docgpt.ai/docs/mail-merge/

Names marked ™ are trademarks of Google LLC. Mail Merge is made by docgpt.ai and is not affiliated with Google.