---
title: 'How to Mail Merge in Gmail (100% Free + Attachments)'
source: 'https://youtube.com/watch?v=Y3pu30IpypU'
video_id: 'Y3pu30IpypU'
date: 2026-08-04
duration_sec: 302
---

# How to Mail Merge in Gmail (100% Free + Attachments)

> Source: [How to Mail Merge in Gmail (100% Free + Attachments)](https://youtube.com/watch?v=Y3pu30IpypU)

## Summary

This video demonstrates how to send personalized emails to multiple recipients in Gmail using a free add-on called 'Mail Merge by Kevin Stratvert'. The tutorial covers setting up a spreadsheet with recipient data, composing emails with merge fields, and sending them with attachments, CC, and BCC options.

### Key Points

- **Introduction to Mail Merge Add-on** [00:00] — Kevin introduces the free Gmail add-on 'Mail Merge by Kevin Stratvert' that enables sending personalized emails to many recipients, including custom subject lines, attachments, CC, and BCC.
- **Installing the Add-on** [00:28] — To install, open Gmail's side panel, click the plus icon to browse add-ons, search for 'Mail Merge by Kevin Stratvert', click install, sign into Google account, and grant required permissions.
- **Creating the Spreadsheet** [00:57] — The add-on opens a sidebar; clicking 'open mail merge' leads to the main interface. Users can create an example spreadsheet containing personalized data. The 'email' column is required; other columns are optional and customizable.
- **Entering Sample Data** [01:44] — Users can enter email addresses, first/last names, company, CC/BCC, and attachment links. Multiple email addresses must be separated by commas. Attachment column accepts Google Drive file links.
- **Adding Attachments** [02:17] — To attach a file, copy the Google Drive link (via right-click > Share > Copy link) and paste it into the attachment cell in the spreadsheet.
- **Custom Columns** [02:33] — Users can rename or add custom columns, such as 'due date', to include additional personalized data in emails.
- **Selecting the Spreadsheet** [02:47] — In the mail merge interface, click 'pick sheet from Drive', allow cookies, and select the prepared spreadsheet from the Google file picker.
- **Composing the Email** [03:04] — Compose the email by typing a subject and message, inserting merge fields (e.g., company, first name, due date) that correspond to spreadsheet columns.
- **Previewing and Sending** [03:34] — Before sending, preview each personalized email to ensure accuracy. Authorize access if needed, then click 'send all' to send all emails at once.
- **Sending Limits** [04:20] — The add-on has no sending limits, but Google imposes daily limits: 500 emails per day for personal Gmail, 1,500 per day for Google Workspace accounts.

### Conclusion

The Mail Merge add-on simplifies sending personalized bulk emails in Gmail, with no cost and flexible features. Users should be mindful of Google's daily sending limits to avoid issues.

## Transcript

In this video, I'll show you how to send&nbsp; personalized emails to lots of people in Gmail&nbsp;&nbsp; using a free add-on that I built. In just a few&nbsp; simple steps, you'll learn how to send standard&nbsp;&nbsp;
mail merges, use custom subject lines, include&nbsp; attachments, add CC and BCC recipients and more.&nbsp;&nbsp; Best of all, it's 100% free. I'm Kevin and let's&nbsp; dive in. First, head to Gmail. On the right-hand&nbsp;&nbsp;
side, open the side panel, and right over here,&nbsp; click on the plus icon to browse add-ons. At the&nbsp;&nbsp; top, search for Mail Merge by Kevin Stratvert.&nbsp; That's my add-on. Right over here, click on&nbsp;&nbsp; install. Here, sign into your Google account.&nbsp; I'll click on continue. Then you'll need to grant&nbsp;&nbsp;
the required permissions. Right up on top, I'll&nbsp; click on select all and then down at the bottom,&nbsp;&nbsp; I'll click on continue. And just like that, we've&nbsp; installed it. I'll click on done. And then over&nbsp;&nbsp; here, let's close out of this window. You'll now&nbsp; see a new mail merge icon over on the right-hand&nbsp;&nbsp;
sidebar. Let's click on that. This opens the mail&nbsp; merge sidebar. Right up on top, let's click on&nbsp;&nbsp; open mail merge. This opens up the main interface.&nbsp; Let's start by creating an example spreadsheet.&nbsp;&nbsp; I'll click here. This opens a new Google Sheet.&nbsp; This spreadsheet contains all the personalized&nbsp;&nbsp;
information that you want to insert into your&nbsp; emails. Let's walk through it together. First,&nbsp;&nbsp; and this one is required, is the email column.&nbsp; This contains the recipients of your mail merge.&nbsp;&nbsp; You can enter one email address, or you could&nbsp; even enter in multiple email addresses. If you&nbsp;&nbsp;
include multiple email addresses, you just have&nbsp; to make sure to separate them with commas. All the&nbsp;&nbsp; remaining columns that you see here are optional.&nbsp; If you don't need them, you can delete them,&nbsp;&nbsp; you can rename them, or you could even add more&nbsp; here at the end. Let's enter in some sample data&nbsp;&nbsp;
to see how it works. Right over here, I'll enter&nbsp; in an email address, a first name, a last name,&nbsp;&nbsp; a company. And right over here, I could enter&nbsp; in a CC or a BCC email address. I'll leave&nbsp;&nbsp; those blank for now. Now, next to that is the&nbsp; attachment column. To attach a file, all you have&nbsp;&nbsp;
to do is paste in a Google Drive file link. As an&nbsp; example, here I am in Google Drive, and I want to&nbsp;&nbsp; attach this PDF file to my mail merge. To do that,&nbsp; I'll right click on this file, go down to share,&nbsp;&nbsp; and right over here, you have the option to copy&nbsp; the link. I'll click on that. Now, let's go back&nbsp;&nbsp;
to Google Sheets. Back within Google Sheets, let's&nbsp; paste the link into the attachment cell. Right up&nbsp;&nbsp; above, let's remove this sample data. Finally,&nbsp; right over here, you'll see a custom column.&nbsp;&nbsp; You could rename this to whatever you'd like. For example, I'll change this to due date and&nbsp;&nbsp;
then right down below, I'll enter in some sample&nbsp; dates. You can add as many additional columns as&nbsp;&nbsp; you need. With the spreadsheet ready now, let's&nbsp; head back to mail merge. Now that we've prepared&nbsp;&nbsp; the spreadsheet, let's select it in mail merge.&nbsp; Over here, click on pick sheet from Drive. Here,&nbsp;&nbsp;
click on allow cookies. This opens the Google file&nbsp; picker. Right here, I see my spreadsheet. I'll&nbsp;&nbsp; click on it and then select. Next, let's compose&nbsp; the email starting right here with a subject. I'll&nbsp;&nbsp; type in invoice for, and then I want to insert&nbsp; the company name. So right up here, I'll click&nbsp;&nbsp;
on the company merge field from the spreadsheet,&nbsp; and that inserts it here as a placeholder. Notice&nbsp;&nbsp; that each merge field corresponds to one of&nbsp; the columns in the spreadsheet. Below that,&nbsp;&nbsp; we can type in the email message. I'll&nbsp; type in my message, and I'd like to say hi,&nbsp;&nbsp;
and then the person's first name. So, I need&nbsp; to insert a merge field again. Right up on top,&nbsp;&nbsp; I'll click on the first name, and that inserts&nbsp; a tag. Here it says your invoice is due on,&nbsp;&nbsp; and then I want to insert the due date. So up on&nbsp; here, I'll click on due date. Now I'm not going to&nbsp;&nbsp;
use the last name merge field, and that's okay.&nbsp; Now before sending, let's preview the emails by&nbsp;&nbsp; clicking on preview. The first time you do this,&nbsp; especially if you're including attachments,&nbsp;&nbsp; you'll need to authorize access. So right&nbsp; up on top, I'll click on authorize. Here,&nbsp;&nbsp;
let's click on allow cookies. And there I see my&nbsp; attachment. I'll click on select. Here, you can&nbsp;&nbsp; preview each personalized email exactly as your&nbsp; recipients will see it. If you spot any issues,&nbsp;&nbsp; simply click on back to edit, and you can make&nbsp; changes. Now, I think everything looks good here,&nbsp;&nbsp;
so I'll click on send all. Up on top, let's&nbsp; click on okay to confirm sending the emails.&nbsp;&nbsp; And look at that, three emails sent, perfect. If&nbsp; I open my inbox, there's one of the personalized&nbsp;&nbsp; emails. Here, I have a custom subject. We also&nbsp; have all the personalized details, the message,&nbsp;&nbsp;
and down below, we have the attachment, nice.&nbsp; There you go. As you can see, sending personalized&nbsp;&nbsp; emails in Gmail is quick and easy. The add-on&nbsp; doesn't impose any sending limits, but Google does&nbsp;&nbsp;
have daily sending limits itself. As of filming,&nbsp; you can send up to 500 mail merge emails per day&nbsp;&nbsp; with a personal Gmail account, and up to 1,500&nbsp; per day with a Google workspace account. If you&nbsp;&nbsp;
have any feedback or ideas for new features,&nbsp; you could submit them directly in the app,&nbsp;&nbsp; or you could simply leave a comment right down&nbsp; below on this video. I'd love to hear from you.&nbsp;&nbsp; I hope you find this add-on useful. Thanks for&nbsp; watching, and I'll see you in the next video.