Smartlead to HubSpot performance analytics
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 18 nodes and runs on a schedule (every day). Along the way it connects Postgres, HubSpot and Google Sheets. It also calls server.smartlead.ai over HTTP.
How it runs
Trigger: On a schedule (every day).
- SET SMARTLEAD API KEY (Edit Fields (Set)): sets 1 field: API KEY
- FETCH ALL CAMPAIGNS (HTTP Request): calls server.smartlead.ai
- Postgres: run a query
- SEARCH (Postgres): run a query
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Google Sheets: append or update
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- EXTRACT CAMPAIGN DATA (HTTP Request): calls an HTTP API
- UPDATE CAMPAIGN (Postgres): create or update
- HubSpot: get many
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: server.smartlead.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 (10)
- HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Postgres
n8n-nodes-base.postgres - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - HubSpot
n8n-nodes-base.hubspot - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets
From the author
Smartlead to HubSpot Performance Analytics A streamlined workflow to analyze your Smartlead performance metrics by tracking lifecycle stages in HubSpot and generating automated reports. Who is this for? (Outbound) Automation Agencies, Sales and marketing…