How to Mail Merge in Gmail (100% Free + Attachments), by Kevin Stratvert on YouTube. 5 min 3 s.
- Video length
- 5 min 3 s
- Time to do it
- 20 minutes
- Difficulty
- Easy
- Steps
- 9
What you need
Steps
Open the Google Workspace Marketplace and search for the Mail Merge add-on by Kevin Stratvert. Click Install, sign in with your Google account and approve the permissions it asks for.
Open Gmail, click the Mail Merge icon in the right side panel to launch the add-on. If you do not see the panel, click the side panel arrow at the bottom right.
Add your recipients and merge fields. Type the fields you want to personalize, such as first name or company, so the add-on knows which columns to pull from your sheet.
To include attachments, click the attach option and pick files from Google Drive. Choose the PDFs or documents you want each recipient to receive.
Add any custom merge fields you need beyond the defaults. This lets you insert extra columns from your spreadsheet into the email body.
Connect your spreadsheet. Paste the Google Sheets link or select the file, then confirm the sheet and tab that hold your recipient rows.
Write your email subject and body in the add-on editor. Insert merge fields where personal details should appear, and add CC or BCC recipients if needed.
Click preview to check a few personalized emails. Confirm names, fields and attachments look right before you send anything.
Click send to run the mail merge. The add-on sends each email individually from your Gmail account.
Tips and common mistakes
Gmail has daily sending limits, so split large lists across several days to avoid your account being blocked.
Keep your spreadsheet columns named clearly and remove blank rows so merge fields do not come out empty.
Send a test merge to your own address first to check formatting and attachments.
Do not close the browser tab while the merge is running or some emails may not go out.
Questions
Do I need a paid add-on to mail merge in Gmail?
No. The Mail Merge add-on by Kevin Stratvert is free to install from the Google Workspace Marketplace. You only need a Google account and a spreadsheet.
Can I attach different files to each email?
Yes. You can attach files from Google Drive, and the add-on can match attachments to rows in your spreadsheet if you set up a file column.
How many emails can I send at once?
Gmail limits how many emails you can send per day, and the exact number depends on your account. Split big lists into smaller batches to stay under the limit.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
