Skip to content

How Mailvern works

Every campaign follows the same path. Understanding it makes each feature page easier to place.

4 min read

The campaign flow

Google SheetsMailvernEmail editorConditionsPersonalizationAttachmentsGmailTrackingAnalytics

Each stage is optional except the sheet, the message and Gmail. You can skip conditions, attachments and tracking entirely.

Stage by stage

  1. 1

    Google Sheets

    Your recipients and their data. Mailvern reads the header row and the rows you select.

  2. 2

    Mailvern

    The sidebar where you choose the email column, the range and the campaign settings.

  3. 3

    Email editor

    Mailvern's own editor for subject, body, sender name, Reply-To and alias.

  4. 4

    Conditions

    Rules that decide which rows are eligible. Rows that fail are skipped and marked.

  5. 5

    Personalization

    Placeholders are replaced with each row's values right before sending.

  6. 6

    Attachments

    A file you selected is attached to the outgoing message.

  7. 7

    Gmail

    The email is sent through your own Gmail account and lands in your Sent folder.

  8. 8

    Tracking

    If enabled, opens are recorded and written back next to the row.

  9. 9

    Analytics

    Results roll up into the analytics dashboard for the campaign.

Status written back to the sheet

After a run, Mailvern writes a status for every row so you always know what happened.

StatusMeaning
SentThe email was handed to Gmail successfully.
OpenedTracking recorded at least one open.
Skipped – Already SentDuplicate protection prevented a second email.
Skipped – Condition Not MetThe row did not match your conditions.
Skipped – No EmailThe email cell was empty or invalid.
ScheduledThe row is queued for a future send.
ErrorSending failed. The reason is logged for that row.

Related guides

Popular articles