Conditions, not lists
Describe the state that deserves an email — Payment = Pending, Score > 80 — and Mailvern emails only those rows.
Mailvern is conditional mail merge. Choose rules like Payment = Pending and personalized Gmail emails go out only to the rows that match — never to your whole list.
3-day trial on paid plans · Works with Gmail and Google Workspace
Q3 — client invoices.gsheet
| Client | Amount | Payment | |
|---|---|---|---|
| Aarav Mehta | aarav@northloop.co | $1,240 | Pending |
| Sara Bright | sara@brightlabs.io | $860 | Paid |
| Devika Rao | devika@kadence.in | $2,100 | Pending |
| Tom Whitfield | tom@fieldwork.dev | $430 | Paid |
| Neha Kapoor | neha@sparkhr.com | $1,595 | Pending |
Condition
Matching rows
0of 5
Paid rows are skipped. Nothing leaves your sheet.
Traditional tools blast everyone and ask you to upload your customers first. Mailvern does neither.
Describe the state that deserves an email — Payment = Pending, Score > 80 — and Mailvern emails only those rows.
A sidebar in the sheet you already use. No exporting, no importing, no CSV files to babysit.
Campaigns send from your own Gmail. Your customer data never has to be uploaded to third-party servers.
Install, open your sheet, pick conditions, send. There is nothing new to learn.
Set conditions and fire campaigns from the Sheets sidebar. Compose in a dedicated email editor, and measure it all in a full analytics dashboard.
Condition builder
Supported operators
Multi-condition AND / OR groupsComing soon
27 rows match — everyone else is skipped.
Subject: {{Invoice}} is due on {{Due Date}}
Hi {{First Name}},
A quick note that invoice {{Invoice}} for {{Amount}} is still showing as pending on our side.
Pay invoiceCampaign analytics
Invoice reminders · last 7 days
1,284
Sent
71%
Opened
2,910
Total opens
Emails sent from Sheets
Inbox delivery via Gmail
Rows exported to our servers
Average time to first send
The difference is not features — it is whether you can send to a condition instead of a list.
| Capability | Mailvern | Traditional |
|---|---|---|
| Send only to rows matching conditions | Yes | No |
| Works entirely inside Google Sheets | Yes | No |
| No CSV export or import | Yes | No |
| Data uploaded to a third-party server | No | Yes |
| Auto Run on new matching rows | Yes | No |
| Duplicate protection built in | Yes | Partial |
| Send from your Gmail aliases | Yes | Partial |
| Open tracking written back to the row | Yes | No |
| Setup time | Under 5 minutes | Hours of list prep |
Invoices, follow-ups, admissions, hiring, renewals — if the state lives in a column, Mailvern can email it.
Finance teams
Keep invoices in a sheet and let Mailvern email only unpaid rows with the amount, invoice number and due date filled in.
Invoice = Unpaid
Operations
Auto Run re-checks the sheet daily and follows up on rows that are still pending — once each.
Payment = Pending
Sales teams
Score your leads in the sheet and send tailored emails to each band with the right message.
Score > 80
Schools & colleges
One sheet, one campaign: notify only the students in a given batch, section or status.
Batch = 2026
Recruiters & HR
Send interview invites to approved candidates and polite rejections to the rest — from the same sheet.
Status = Shortlisted
Success teams
Every new row marked Onboarding gets a personalized welcome sequence within the hour.
Stage = Onboarding
Real feedback from people running campaigns straight out of their sheets.
“We used to filter the invoice sheet by hand every Monday. Now auto-run emails only the unpaid rows and our collections cycle dropped by nine days.”
“Condition based sending is the whole thing. Shortlisted candidates get interview invites, everyone else gets a proper reply — from one tracker.”
“No CSV, no upload, no data leaving our Workspace. That was the only way our IT team would approve a mail merge tool.”
“I set up my first campaign in under five minutes and it looked like something our designer made. The editor is genuinely good.”
Mailvern never requires uploading customer data to third-party servers to send campaigns. It reads the sheet you opened it in and sends through your own Gmail account, using only the permissions sending actually needs.
Install Mailvern from the Google Workspace Marketplace and run your first conditional campaign in under five minutes.
3-day trial on paid plans · Works with Gmail and Google Workspace