Automated lead intelligence: enrich Google Sheets with Clearbit & sync to Notion and ClickUp
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, ClickUp and Notion.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Check If Unbooked (If): checks a condition and branches into true / false
- Extract Domain from Email (Function): runs custom JavaScript (legacy Function node)
- Get Company Logo (HTTP Request): calls an HTTP API
- Clearbit Company Enrichment (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Merge Enrichment Data (Function): runs custom JavaScript (legacy Function node)
- Create a database page (Notion): uses Notion
- Create a task (ClickUp): uses ClickUp
- Append to Enriched Leads Sheet (Google Sheets): uses Google Sheets
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Extract Domain from Email, Merge Enrichment Data: replace with Code node, mode 'Run Once for All Items'.
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Extract Domain from Email, Merge Enrichment Data | Code node, mode 'Run Once for All Items' |
Nodes used (8)
- Function
n8n-nodes-base.function - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - ClickUp
n8n-nodes-base.clickUp - If
n8n-nodes-base.if - Manual Trigger
n8n-nodes-base.manualTrigger - Merge
n8n-nodes-base.merge - Notion
n8n-nodes-base.notion
From the author
Description Give your sales team a competitive edge with this Lead Profile Enrichment automation! This workflow automatically enriches lead data by fetching company details, logos, and brand colors, then syncs everything into Notion, ClickUp, and Google…