Qualify Google Sheets leads by website domain age using RDAP lookups
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Settings (Edit Fields (Set)): sets 5 fields: sheet_id, sheet_tab, website_column…
- Read Leads (Google Sheets): read (sheet)
- Prepare Domains (Code): runs custom JavaScript code
- Loop Over Rows (Loop Over Items (Split in Batches)): loops over the items in batches
- Collect Results (Code): runs custom JavaScript code
- Needs Lookup? (If): checks a condition and branches into true / false
- Write Back Ages (Google Sheets): update (sheet)
- Wait: pauses before continuing
- RDAP Lookup (HTTP Request): calls an HTTP API (GET)
- Check RDAP Response (Code): runs custom JavaScript code
…plus 1 more step. See the full node list below.
Services it uses
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 - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview This workflow reads lead rows from Google Sheets, extracts each website’s registrable domain, and uses rdap.org RDAP lookups to calculate domain registration age, then writes the results back to the same sheet as domaincreated, yearsregistered,…