Skip to content

Add Personalized Attachments

Personalized attachments send each recipient their own file, such as an invoice, a payslip, a certificate or an offer letter. They are available on the Plus and Pro plans.

You set them up in the campaign’s Attachments tab, which offers three sources:

Source How it works
None Send only the template attachments, which everyone receives.
Files from Google Drive Recommended. Pick the files in Google Drive and BetterMerge matches them to rows by file name. Files stay private.
Links in the sheet Paste one Google Drive link per row in an attachment column. Files must be shared with anyone who has the link.

To send the same file to everyone, use template attachments instead. The Attachments tab lists them under Template attachments · sent to everyone, so you can see everything an email will carry.

The Attachments tab in the campaign editor, with the Files from Google Drive source (1) and the Template attachments section (2)

Your files stay private in your Google Drive. You don’t share them and you don’t paste any links. BetterMerge reads only the files you pick, using your own Google account, when each email is sent.

Step 1: Name Your Files So They Match a Column

Section titled “Step 1: Name Your Files So They Match a Column”

Put the files in Google Drive and give each one a name that contains a value from your sheet. For example, with an Invoice No column:

Invoice No Email File in Drive
1042 alex@example.com Invoice-1042.pdf
1043 sam@example.com Invoice-1043.pdf

Files can be in My Drive, a shared drive, or Shared with me.

  1. Open your campaign and go to the Attachments tab, between Template and Delivery.
  2. Choose Files from Google Drive.
  3. Click Select files. Google Drive opens.
  4. Open the folder and select the files. To select many at once, use Shift-click or Ctrl+A (⌘+A on Mac).

The Files from Google Drive panel with Select files (1), File name rules (2), When a row has no matching file (3) and the Match review (4)

The numbers in the screenshot match the next steps: (1) select the files, (2) set the rule, (3) choose what happens when a file is missing, and (4) check the match review.

The tab shows how many files are selected. Click View selected files to see the list, Add more to pick more, or Clear to start again. You can select up to 10,000 files for one campaign.

A rule tells BetterMerge which file belongs to each row. Write the file name with merge tags for the parts that change, for example Invoice-{{Invoice No}}.

  • Matching ignores upper and lower case.
  • You can leave out the file extension. Add one, such as .pdf, only when two files differ just by extension.
  • * matches any text. For example, {{Invoice No}}* matches 1042 - March.pdf.

BetterMerge suggests a rule from the column whose values match the most selected files. Check it before you continue.

Each rule attaches one file. To send more than one file per email, click Add another attachment and add another rule. Your plan’s attachment count per email includes template attachments.

Step 4: Choose What Happens When a File Is Missing

Section titled “Step 4: Choose What Happens When a File Is Missing”

Under When a row has no matching file, choose one:

  • Skip the row and mark it “Attachment missing”, the default. Use it when the file is the point of the email.
  • Send without the missing attachment, when the file is optional.

If more than one file matches a rule for the same row, BetterMerge never guesses. It skips the row and marks it “Attachment ambiguous”.

The Match review shows the result for the whole sheet, for example:

482 rows matched · 3 missing · 1 ambiguous · 12 files not used

Expand it to see each problem row with its row number, recipient and reason. Fix the file names or the rule, and the review updates.

  • The Preview tab shows each row’s attachment names, or why the row will be skipped.
  • A test email carries the real files, so you can open them before you launch.

Then launch the campaign as usual. See Create a campaign.

  • Files you can pick: PDF, Word, Excel, PowerPoint, CSV, images, and Google Docs, Sheets and Slides.
  • Google files are sent as PDFs.
  • Size per file: up to 5 MB on Plus and 10 MB on Pro.
  • Size per email: all attachments together must stay under Gmail’s 25 MB limit.

A row skipped because of its attachment gets a status in your Google Sheet, such as ATTACHMENT MISSING, and the campaign report lists it under Rows skipped for attachments. The other rows keep sending. The reasons are:

Reason What to do
Attachment missing No file matched. Add the file or fix the rule.
Attachment ambiguous More than one file matched. Make the rule or the file names more specific.
Attachment not accessible Select the file again, or reconnect your Google account.
Attachment too large The file is over your plan’s size limit.

If BetterMerge loses access to your Google account while sending, the campaign pauses rather than sending emails without their files. Reconnect your Google account, then resume the campaign.

Use this source for campaigns that already have Drive links in the sheet.

  • For one attachment, add a column named Attachment.
  • For more than one, add Attachment 1, Attachment 2, and so on.

Adding a single column for one personalized attachment in Google Sheets Adding multiple columns for more than one personalized attachment in Google Sheets

  1. In Google Drive, open the file’s Share dialog.
  2. Set General access to Anyone with the link.
  3. Click Copy link, then Done.

To share many files at once, put them in one folder and share the folder the same way. The files inside inherit its access.

Adjusting sharing settings in Google Drive

Paste each link into its row’s attachment column. Leave the cell blank for recipients who shouldn’t get a file.

Pasting the link in Google Sheets

In the campaign’s Attachments tab, choose Links in the sheet.

With links, Google Docs, Sheets and Slides are sent as Microsoft Office files, and each file can be up to 5 MB.

Not with Files from Google Drive. The files stay private, and BetterMerge reads them with your own Google account. Only Links in the sheet needs files shared with anyone who has the link.

Section titled “Can I switch a campaign from links to Drive files?”

Yes. In the Attachments tab, choose Files from Google Drive, select the files and set a rule. A campaign uses one personalized source, so the old links are ignored.

What if I add or rename files after setting up the campaign?

Section titled “What if I add or rename files after setting up the campaign?”

Click Add more to pick new files. The match review updates when the files, the rules or the sheet change, and BetterMerge checks each file again when its email is sent.

Can I track whether recipients open the attachments?

Section titled “Can I track whether recipients open the attachments?”

No. BetterMerge tracks email opens and link clicks, not attachment downloads.

New to BetterMerge?Start free — 50 emails/day, no credit card. Questions? Contact support.

BetterMerge is an independent product not affiliated with, endorsed by, or connected to Google LLC. Gmail, Google Sheets, Google Workspace, and Google Workspace Marketplace are trademarks of Google LLC.