Add Personalized Attachments
Introduction
Section titled “Introduction”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.

Files from Google Drive
Section titled “Files from Google Drive”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 | 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.
Step 2: Select the Files
Section titled “Step 2: Select the Files”- Open your campaign and go to the Attachments tab, between Template and Delivery.
- Choose Files from Google Drive.
- Click Select files. Google Drive opens.
- Open the folder and select the files. To select many at once, use Shift-click or Ctrl+A (⌘+A on Mac).

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.
Step 3: Set the File Name Rule
Section titled “Step 3: Set the File Name Rule”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}}*matches1042 - 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”.
Step 5: Check the Match Review
Section titled “Step 5: Check the Match Review”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.
Step 6: Preview and Test
Section titled “Step 6: Preview and Test”- 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.
File Types and Limits
Section titled “File Types and Limits”- 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.
After Sending
Section titled “After Sending”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.
Links in the Sheet
Section titled “Links in the Sheet”Use this source for campaigns that already have Drive links in the sheet.
Step 1: Add Attachment Columns
Section titled “Step 1: Add Attachment Columns”- For one attachment, add a column named Attachment.
- For more than one, add Attachment 1, Attachment 2, and so on.

Step 2: Share Each File and Copy Its Link
Section titled “Step 2: Share Each File and Copy Its Link”- In Google Drive, open the file’s Share dialog.
- Set General access to Anyone with the link.
- 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.

Step 3: Paste the Links
Section titled “Step 3: Paste the Links”Paste each link into its row’s attachment column. Leave the cell blank for recipients who shouldn’t get a file.

Step 4: Turn On the Source
Section titled “Step 4: Turn On the Source”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.
Frequently Asked Questions
Section titled “Frequently Asked Questions”Do I need to share my files with anyone?
Section titled “Do I need to share my files with anyone?”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.
Can I switch a campaign from links to Drive files?
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.