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

About this video

Kevin shows how to send personalized mail merges in Gmail using a free add-on he built, Mail Merge by Kevin Stratvert, installed from Gmail’s side panel add-ons. After granting permissions, you create an example Google Sheet that holds personalization data. The email column is required and can contain multiple addresses separated by commas; other columns are optional and can be deleted, renamed, or added. Sample columns include first name, last name, company, CC, BCC, attachment, and a custom column he renames to due date. To attach a file, you paste a Google Drive file link copied via Share into the attachment cell. In Mail Merge you pick the sheet from Drive, compose a subject and message, and insert merge fields that correspond to spreadsheet columns, such as company in the subject and first name and due date in the body. You can preview each personalized email exactly as recipients will see it, authorize attachment access if needed, then send all and confirm. He notes the add-on imposes no sending limits itself, but as of filming Google limits personal Gmail accounts to 500 mail merge emails per day and Google Workspace accounts to 1,500 per day.

Key takeaways

• Install the free Mail Merge by Kevin Stratvert add-on from Gmail’s add-on side panel
• Build a Google Sheet with a required email column; other columns are optional and customizable
• Attach files by pasting a Google Drive share link into the attachment column for each row
• Insert merge fields into the subject and body, then preview each personalized email before sending
• Google’s own limits as of filming: 500 per day for personal Gmail and 1,500 per day for Google Workspace

Episode details: published July 20, 2026 · 5:03 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Kevin Stratvert’s own claims, shared for education — they are not typical or guaranteed.

← Previous: QuickBooks AI Agents Tutorial (2026) · Next: How to Use ElevenLabs AI (Complete Beginner Tutorial) →

All Kevin Stratvert videos · Kevin Stratvert profile · Kevin Stratvert on YouTube