Shopify & WooCommerce inventory sync with Google Sheets alerts
Pull contacts, verify each address with BillionVerify, and continue to Shopify โ 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 Shopify 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
- 1โฐ Hourly Reconciliation TriggerTriggerยท n8n
Starts the workflow โ on a schedule, a webhook, or manually while you test.
- 2๐ฅ Platform Webhook ReceiverSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 3๐ Parse Trigger DataSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 4๐ Prepare Update ActionsSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 5๐๏ธ Fetch Shopify InventorySourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 6๐ Fetch WooCommerce InventorySourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 7๐จ Needs Manual Review?Logicยท n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 8๐ Merge All Platform DataSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 9๐ Log to Google Sheets AuditSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 10๐ Split Updates by PlatformSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 11๐ Compare & Identify DiscrepanciesSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 12๐ง Send Notification?Logicยท n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 13๐ Route Updates to PlatformsLogicยท n8n
Routes items based on the workflow logic.
- 14โ Has Discrepancies?Logicยท n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 15Verify 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.
- 16๐ค Return ResponseSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 17๐๏ธ Update ShopifySourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 18๐ Update WooCommerceSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 19๐ Split Discrepancies for AI ReviewSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 20IF deliverableLogicยท n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 21๐ Merge Update ResultsSourceยท n8n
Provides or transforms the contact data flowing through the workflow.
- 22โ๏ธ Send Alert 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 Shopify send or sync.
- Protecting Shopify deliverability and sender reputation.
- Keeping bounce rates low so your sending is never throttled.
FAQ
Why verify before sending in Shopify?
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