Track commodity portfolio drift with Google Sheets, Gemini AI and Gmail alerts
Pull contacts, verify each address with BillionVerify, and continue to Drift — only deliverable addresses get through.
Why verify before the send
Sending to invalid, risky, catch-all, or disposable addresses spikes your bounce rate and erodes sender reputation. A verification gate before the Drift step removes that risk automatically — only deliverable addresses continue, the rest are flagged.
The workflow
BillionVerify — verification sits right before the send.
Node by node
- 1Daily Portfolio Rebalance CheckTrigger· n8n
Starts the workflow — on a schedule, a webhook, or manually while you test.
- 2Read HoldingsSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 3Workflow SettingsSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 4Synchronize InputsSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 5Prepare Portfolio ContextSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 6Validate Portfolio DataSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 7Check Validation StatusLogic· n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 8Calculate Portfolio AllocationSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 9Prepare Validation Failure LogSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 10Detect Portfolio DriftSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 11Log Validation FailureSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 12Check Rebalance RequirementLogic· n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 13Classify Alert SeveritySource· n8n
Provides or transforms the contact data flowing through the workflow.
- 14Prepare No Action LogSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 15Build Alert PromptSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 16Log No ActionSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 17Generate Alert MessageSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 18Merge Alert DataSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 19Prepare Alert PayloadSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 20Log Sent AlertSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 21Verify Email (BillionVerify)Verify· billionverify
The BillionVerify node verifies the address — status (valid / invalid / risky / catch-all / role / disposable), is_deliverable, and a confidence score — before anything is sent.
- 22IF deliverableLogic· n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 23Send Rebalance EmailSend· n8n
Sends only to verified, deliverable addresses. Swap in your own provider node if you send elsewhere.
Workflow JSON
Copy or download this workflow, then import it in n8n (Workflows → Import from File / Paste). Install the BillionVerify community node first, then add your API key credential.
When to use this
- Cleaning a list before a Drift send or sync.
- Protecting Drift deliverability and sender reputation.
- Keeping bounce rates low so your sending is never throttled.
FAQ
Why verify before sending in Drift?
Verifying first keeps your bounce rate low, which protects your sender reputation and your results.
How do I import this workflow?
Download the JSON, then in n8n go to Workflows → Import from File (or paste it). Install the BillionVerify community node and add your API key credential.
What happens to risky or catch-all addresses?
They are routed to the false branch and excluded from the send. You decide whether to retry, review, or drop them.
Add verification to your workflow
Create a free account, grab your API key, and stop bounces before they happen.
Get started free