GPT for Google Sheets, Docs AI, Slides, Forms

Mail Merge with Attachments in Gmail and Google Sheets

Gmail mail merge with attachments from Google Sheets: one file for all in the draft, or each recipient's own Drive file on paid plans. 25 MB per email.

Yes, you can send a Gmail mail merge with attachments from Google Sheets. With Mail Merge for Gmail and Google Sheets, a file attached to your Gmail draft goes to every recipient, on every plan. To send each recipient their own file, such as an invoice or a certificate, use Personalized Attachments on a paid plan: the add-on matches Google Drive files to rows by the email address in the file name. Google allows up to 25 MB of attachments per email.

Try Mail Merge for Gmail and Sheets →

When attachment mail merge is useful

Attachment campaigns are common when the file is part of the message:

  • creators, nutritionists and coaches sending ebook PDFs, meal plans or client handouts;
  • sales teams sending proposals; recruiters sending role details or candidate packets;
  • finance and admin teams sending notices or invoices;
  • educators sending certificates; event teams sending tickets or schedules;
  • customer success teams sending onboarding guides or account documents.

If everyone gets the same PDF, attach it to the draft. A personalized attachment matters when the file differs per person.

Two ways to attach files

  Same file for everyone A different file per recipient
How Attach the file to your Gmail draft Personalized Attachments on the Campaign Options tab
Plan Every plan, including free Paid plans
Where files live In the draft Google Drive, with the recipient’s email address in the file name
Sheet column None Attachments (the add-on fills it in)

With both, each recipient gets the files in their row plus the draft’s files.

Send a different attachment to each recipient

  1. Name each file with the recipient’s email address, for example [email protected] or [email protected], and keep the files in Google Drive.
  2. Start a new campaign. Click Start New Campaign and pick your draft.
  3. Pick the files. On 2. Campaign Options, click Select Files from Drive under Personalized Attachments. Hold Ctrl (⌘ on a Mac) to select several.
  4. Match them. Click Match Files to Corresponding Emails. The add-on writes each matched file’s Drive link into a column named Attachments (created if missing). Several files for one person are separated by commas.
  5. Check, test and send. Review the Attachments column (below), send yourself a test, then start the campaign.

Google allows up to 25 MB of attachments in total per email. Plans and prices: Mail Merge pricing.

Prepare your Sheet, files, and recipient fields

Column Purpose
Email Required. The recipient address, and the text each file name must contain
First Name Greeting
Mail Merge Required. The add-on writes each row’s status here
Company or Account Context for the email
Attachments Filled by the add-on with the matched Drive links

Keep file names clear and avoid ambiguous duplicates such as proposal-final.pdf and proposal-final-v2.pdf. If files contain private data, keep them in a private Drive folder.

Attach the right file to the right recipient

Wrong-file mistakes are the biggest risk in attachment mail merge:

  1. One address per file name. Each file name should contain exactly one recipient’s email address.
  2. Watch for overlapping addresses. A file named for [email protected] also contains [email protected], so it can match both rows. Rename files if you see this.
  3. Spot-check the Attachments column. Open several links and confirm each file belongs to the person in that row.
  4. Hold back rows you’re unsure about. Type SKIP in their Mail Merge cell; remove it when the row is ready.
  5. Send a test, then a small first batch with a low Maximum emails per launch.

The rule is simple: check every recipient-file pairing before a bulk send.

Test delivery before sending the full campaign

  • Send yourself a test (it goes only to you) and confirm the attachment opens on desktop and mobile.
  • Explain in the email body why the file is attached.
  • Stay under 25 MB per email and avoid unusual file types.
  • Add an opt-out line where appropriate; the add-on doesn’t add one.
  • Respect Google’s daily limits: about 100 recipients a day on @gmail.com and 1,500 on Google Workspace.

Start a tested attachment campaign →

Attachment mail merge examples

Each placeholder below needs a column with exactly that header.

Proposal after a call

Subject: Proposal for {{Company}}

Hi {{First Name}},

Attached is the proposal we discussed for {{Company}}. The main section to review is {{Proposal Section}}.

If helpful, I can walk through it this week.

Best, Ana

Recruiting packet

Subject: Details for the {{Role}} role

Hi {{First Name}},

Attached is the role overview for {{Role}}. Based on your background in {{Skill Area}}, the most relevant section is {{Highlight}}.

Would you like to discuss it?

Thanks, Ana

Event document

Subject: Your {{Event Name}} information

Hi {{First Name}},

Attached is the information for {{Event Name}}. Please review {{Specific Note}} before arriving.

See you soon, Ana

Ebook, nutrition, and client-resource examples

Ebook launch

Subject: Your {{Ebook Title}} guide

Hi {{First Name}},

Here is the {{Ebook Title}} guide we talked about. I included the section on {{Topic Interest}} because it is most relevant to your goal.

If you want the next checklist or workshop invite, just reply and I will send it.

Nutrition or coaching handout

Subject: Your {{Program Name}} resource

Hi {{First Name}},

Attached is the {{Resource Name}} for {{Goal}}. Start with {{First Step}} and let me know if you want the next worksheet.

Invoice or client update

Subject: {{Document Type}} for {{Account}}

Hi {{First Name}},

Attached is the {{Document Type}} for {{Account}}. Please review {{Specific Note}} before {{Deadline}}.

This one fits personalized attachments well: name each file like [email protected].

Compliance and deliverability cautions

Attachment campaigns deserve extra care:

  • use consented or clearly relevant recipients;
  • don’t attach sensitive documents until the recipient-file match is checked;
  • avoid misleading subject lines or unexplained attachments;
  • watch your inbox for bounce messages and replies, and honor opt-outs;
  • consider whether a secure link is safer than an attachment for sensitive files.

Mail merge with attachments FAQ

Can I do a Gmail mail merge with attachments from Google Sheets?

Yes. With Mail Merge for Gmail and Sheets, files attached to your Gmail draft go to every recipient on every plan. On paid plans, Personalized Attachments sends each recipient their own Google Drive files.

Can each recipient get a different attachment?

Yes, on paid plans. Name each file in Google Drive so it contains the recipient’s email address, pick the files under Personalized Attachments, and click Match Files to Corresponding Emails. The add-on writes the matched links into an Attachments column.

How large can attachments be?

Google allows up to 25 MB of attachments per email in total. For bigger files, share a link instead.

How do I avoid sending the wrong attachment?

Put exactly one recipient’s email address in each file name, check the Attachments column after matching, open a few files, type SKIP on rows you’re unsure about, send yourself a test, and start with a small batch.

Are attachments bad for deliverability?

Not automatically, but large files, unusual formats, irrelevant messages or high-volume sending can hurt performance. Keep files expected, relevant and reasonably sized.

For sensitive or frequently updated documents, a secure link may be safer than an attachment. Choose the method that best protects the recipient and the data.

Send attachment campaigns carefully

When attachments are part of the campaign, accuracy matters more than speed. Check the file matches and send in controlled batches.

Try Mail Merge for Gmail and Sheets →