Getting started with Mailvern
Mailvern is a Google Workspace add-on that sends personalized emails from a Google Sheet through your own Gmail account. This page takes you from install to your first send.
5 min read
What is Mailvern
Mailvern turns a normal Google Sheet into a mail merge tool. You pick the column that holds email addresses, write your message once, and Mailvern sends one personalized email per row.
Everything happens inside Google. Your rows stay in the sheet, the message goes out from your Gmail account, and campaign status is written back next to each row.
Runs in Sheets
A sidebar inside the sheet you already use. No CSV export, no import.
Sends from Gmail
Emails leave your own Gmail account and appear in your Sent folder.
Condition based
Email only the rows that match rules like Payment = Pending.
Why Mailvern
Most mail merge tools ask you to export a list, upload it somewhere else and maintain a second copy of your data. Mailvern removes that step.
| Task | Mailvern | Traditional mail merge |
|---|---|---|
| Prepare a list | Use the sheet you already have | Export and clean a CSV |
| Send only to matching rows | Built-in conditions | Manual filtering |
| Where data lives | Your Google Sheet | A third-party server |
| Who sends the email | Your Gmail account | A shared sending domain |
| Status of each row | Written back into the sheet | In a separate dashboard |
Key features
Built-in email editor
Rich text, images, links and HTML — not Gmail Drafts.
Read guidePersonalization
Every column header becomes a placeholder.
Read guideConditional sending
Send only to rows that match your rules.
Read guideAttachments
Attach a file from your own Google Drive.
Read guideOpen tracking
Optional opens, first open and last open.
Read guideAnalytics dashboard
Campaign performance and engagement trends.
Read guideScheduling & Auto Run
Send later or run campaigns on a schedule.
Read guideTemplates
Save a message once and reuse it anywhere.
Read guideInstall from the Google Workspace Marketplace
- 1
Open the Marketplace listing
Go to the Mailvern listing in the Google Workspace Marketplace.
- 2
Click Install
Choose the Google account you want to send emails from.
- 3
Review permissions
Google shows exactly what Mailvern can access. Approve to continue.
- 4
Done
Mailvern is now available in every Google Sheet on that account.
Open Mailvern
Open any Google Sheet, then choose Extensions → Mailvern → Open. The sidebar appears on the right.
Mailvern reads the header row of the active tab, so every column name becomes available as a field you can use for matching and personalization.
The Mailvern sidebar
Sending controls live in the sidebar next to your data.
Screenshot coming soon
Send your first campaign
- 1
Pick your email column
Tell Mailvern which column holds recipient email addresses.
- 2
Write the message
Use the built-in editor. Insert placeholders like {{First Name}} anywhere.
- 3
Add conditions (optional)
For example Status equals Approved, so only those rows are emailed.
- 4
Preview matching rows
Check the count and a sample email before anything leaves.
- 5
Send
Send now, schedule it for later, or turn on Auto Run.