Mail merge for Gmail and Google Sheets

You can try it for free: every new account gets 11 free emails, with no credit card. Free emails include a small "Sender notified by Mail Merge for Gmail" footer.

Paid plans start at $4.99 a month or $49.99 a year. They remove the footer, raise your monthly allowance and add scheduling and a different attachment for each recipient. See plans.

About 100 recipients a day from a free @gmail.com account and 1,500 a day from a Google Workspace account. These are Google's Apps Script limits for add-ons, the same on every plan; Google resets them 24 hours after the first send that counted.

If you hit the limit, run the campaign again after the reset: rows already sent are skipped. More about Gmail sending limits.

Yes. The add-on sends one separate email per row through your Gmail account, so recipients see your address and don't see each other. Replies come to your inbox, or to the reply-to address you set for the campaign. You can also set the sender name for each campaign.

Put a column header in double curly braces in your Gmail draft, for example {{First Name}} or {{Company}}. It works in the subject and the body, and the text must match the header exactly, including capital letters and spaces.

Each email gets that row's value; an empty cell becomes empty text. Placeholder rules and tips.

Yes, on every plan. With tracking on, click Refresh Email Status in the sidebar and each row changes to EMAIL_OPENED or EMAIL_CLICKED, with the time in the cell note. Opens are approximate, because some email apps block or preload images.

Replies and bounces are not tracked yet: you see them in your Gmail inbox. How tracking works.

Yes, on any paid plan. In the campaign's Schedule tab choose "Schedule for later" and pick a date and time in your time zone. The campaign runs from your Google account even if the sheet is closed, and you can cancel it in the campaign report. How scheduling works.

Yes, on any paid plan. Put the recipient's email address in each file's name, for example [email protected], select the files from Google Drive in the campaign options and click "Match Files to Corresponding Emails". The add-on writes the matches into an Attachments column, and each person gets only their files.

Files attached to the Gmail draft itself go to everyone, on every plan.

Yes, if your Google Workspace administrator allows it. If Google shows "You do not have access to this Addon. Please contact your Organization Administrator", an admin has to install or allowlist the add-on (App ID 213303404172) first. The admin setup guide has the steps and an email you can forward.

Gmail's own mail merge is only available on some paid Google Workspace plans, not on free @gmail.com accounts. This add-on works on any Google account, writes a status for every recipient into your sheet, tracks opens and clicks, and on paid plans can schedule the campaign and attach a different file for each person.

Choose a plan above and pay with Stripe using the same email as your Google account, then close and relaunch the add-on in Google Sheets. Plans renew monthly or yearly until you cancel.

To cancel, contact us with the email you paid with. Your plan stays active until the end of the period you paid for. Plans and billing help.