BillionVerify
Sign In
← All Cold Outreach Workflows
Google SheetsBillionVerifyGmail

Verify before batch emails from a sheet (Google Sheets → Gmail)

A one-off or recurring batch send loops through a Google Sheet, verifies each recipient, and emails only the deliverable ones via Gmail.

Get a free API keyInstall the n8n node

Why verify before the send

Mail-merge style batch sends from a sheet are the easiest way to nuke your deliverability — one stale column and a quarter of the batch bounces. A per-row verification gate makes batch sends safe.

The workflow

Google Sheets → BillionVerify → Gmail — verification sits right before the send.

Trigger
google-sheets
Get rows
billionverify
Verify Email
IF deliverable
gmail
Send personalized email
google-sheets
Record skipped

Node by node

  1. 1
    TriggerTrigger· n8n

    Manual or scheduled start for the batch run.

  2. 2
    Get rowsSource· google-sheets

    Reads every recipient row for this batch.

  3. 3
    Verify EmailVerify· billionverify

    The BillionVerify node, operation "Verify Email". Map its Email field to the address from the previous node. It returns status (valid / invalid / risky / catch-all / role / disposable), is_deliverable, a confidence score, and the reason — all before anything is sent.

  4. 4
    IF deliverableLogic· n8n

    Branches on the verification result. Condition: is_deliverable is true. The true branch continues to the send; the false branch skips the send and flags the contact.

  5. 5
    Send personalized emailSend· gmail

    Sends the merged, personalized email via Gmail for each deliverable recipient.

  6. 6
    Record skippedLogic· google-sheets

    For the false branch: write the status back so skipped rows are visible and fixable.

When to use this

  • Operational batch emails: invoices, payslips, statements, reminders.
  • Personalized announcements to a list kept in a spreadsheet.
  • Recurring digests where the recipient list changes each run.

Three ways to connect

n8n node

Install the BillionVerify community node and drop it into this workflow.

Integrately

1-Click connect BillionVerify with 1500+ apps, no code.

REST API

Call the verification API directly from any stack.

FAQ

Is this a mail-merge replacement?

It is a safer mail merge — same per-row personalization, plus a verification gate so bounces do not wreck the batch.

How big a batch can I send?

As large as your sending limits allow. Verify per row, or pre-verify the whole sheet in bulk for very large runs.

What if many rows are invalid?

They are skipped and recorded. A high skip rate is a signal to clean the source list before the next run.

Add verification to your workflow

Create a free account, grab your API key, and stop bounces before they happen.

Get started free