Workflow · version 1.0

Verify a Google Sheet, then send to the clean rows

Read addresses from a sheet, verify each with ValidReach, write the result back, and prepare a Gmail draft only for rows that pass.

Starts when: A new row is added to a Google Sheet, or you run the flow on demand.

Steps

1. Read row (trigger)
Read the email address from the sheet row.
2. Verify address (http)
POST the address to /api/v1/verify/single.
3. Check status (branch)
Branch on data.status.
4. Mark clean and draft email (action)
Write status to the sheet and create a Gmail draft for you to review.
5. Mark rejected (action)
Write status to the sheet; do not send.
6. Queue retry (action)
Mark the row for a later retry; unknown is not billed.

Connections

Read row → Verify address
Verify address → Check status
Check status → Mark clean and draft email (valid)
Check status → Mark rejected (invalid, disposable)
Check status → Queue retry (unknown)

Credentials you provide

ValidReach API key YOUR_API_KEY: Create it under Settings → API keys and store it in your automation tool’s secret storage.
Google account CONNECT_YOUR_OWN_ACCOUNT: Authorise Sheets and Gmail with your own account in your automation tool.

Sample

POST https://validreach.dev/api/v1/verify/single
Authorization: Bearer YOUR_API_KEY
Content-Type: application/json

{"email":"user@example.com"}

{
  "success": true,
  "data": {
    "email": "user@example.com",
    "status": "valid",
    "is_deliverable": true,
    "reason": "accepted_email",
    "credits_used": 1,
    "retryable": false
  }
}

Before you run it

Create drafts, not sent messages, while you test, and use addresses you own. Do not test by mailing real recipients. Decide your own policy for catchall, risky and role results.

Verification status. Schema: checked in unit tests. Import: not tested on any platform. Sandbox run: not run. The download is this ValidReach definition, not an importable file for an automation platform.