Enrich company websites in Google Sheets with contact data via Weio
Ready for 3.0What this workflow does
This workflow has 23 nodes and runs on a schedule (every day at 07:00) (plus 2 other triggers). Along the way it connects Google Sheets and Gmail. It also calls weio.ai over HTTP.
How it runs
Trigger: On a schedule (every day at 07:00) (plus 2 other triggers).
- Settings (Edit Fields (Set)): sets 7 fields: sheet_url, sheet_tab, re_enrich_after_days…
- Email: workflow failed (Gmail): uses Gmail
- Read leads (Google Sheets): read
- Has a website (Filter): keeps only the items that match a condition
- Pick rows due for enrichment (Code): runs custom JavaScript code
- Cap lookups per run (Limit): keeps the first few items
- Loop over leads (Loop Over Items (Split in Batches)): loops over the items in batches
- Build run summary (Code): runs custom JavaScript code
- Look up website facts (HTTP Request): calls weio.ai
- Summary email on? (Filter): keeps only the items that match a condition
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: weio.ai
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Limit
n8n-nodes-base.limit - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Stop and Error
n8n-nodes-base.stopAndError - Wait
n8n-nodes-base.wait - Gmail
n8n-nodes-base.gmail - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview This workflow runs daily (or manually) to read company websites from Google Sheets, enrich them via the Weio Site-Info API with emails, phone numbers, and social links, writes results back to the same sheet, and sends a run summary (and failure…