Enrich Google Sheets domains with verified decision makers via Apify
Ready for 3.0What this workflow does
This workflow has 31 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set workflow configuration (Edit Fields (Set)): sets 9 fields: google_sheet_id, input_sheet_name, results_sheet_name…
- Read ready company domains (Google Sheets): read
- Prepare one Actor batch (Code): runs custom JavaScript code
- Has valid domains? (If): checks a condition and branches into true / false
- Prepare in-progress row updates (Code): runs custom JavaScript code
- Summarize empty input (Code): runs custom JavaScript code
- Classify invalid-only input (Code): runs custom JavaScript code
- Mark input rows in progress (Google Sheets): update
- Upsert successful run log (Google Sheets): append or update
- Prepare result sheet rows (Code): runs custom JavaScript code
…plus 20 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Stop and Error
n8n-nodes-base.stopAndError
From the author
Quick overview This workflow reads company domains queued in Google Sheets and enriches them with verified decision-maker contact details using the Apify Decision Maker Finder Actor, then writes classified results to a Results sheet and an audit trail to a…