Sync and enrich HubSpot leads from Google Sheets and Telegram with Gemini and Lusha
Ready for 3.0What this workflow does
This AI workflow has 32 nodes and runs on Google Sheets events (plus 1 other trigger). Along the way it connects HubSpot, Telegram, Google Gemini and Google Sheets. It also calls api.hubapi.com and api.lusha.com over HTTP.
How it runs
Trigger: On Google Sheets events (plus 1 other trigger).
- Filter: keeps only the items that match a condition
- Parse Telegram Message (Google Gemini): uses Google Gemini
- Get HubSpot data (HTTP Request): calls api.hubapi.com
- Domain Resolver (Google Gemini): uses Google Gemini
- Append Resolved Domain to Lead (Merge): merges the data from its input branches
- Format Telegram Lead Data (Code): runs custom JavaScript code
- Split HubSpot Search Results (Split Out): splits a list into separate items
- Combine Lead with CRM Reference Data (Merge): merges the data from its input branches
- Mark as HubSpot Reference Data (Code): runs custom JavaScript code
- Match Lead to Existing Company (Code): runs custom JavaScript code
…plus 20 more steps. See the full node list below.
Services it uses
HTTP calls to: api.hubapi.com, api.lusha.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 (13)
- HubSpot
n8n-nodes-base.hubspot - Switch
n8n-nodes-base.switch - Telegram Trigger
n8n-nodes-base.telegramTrigger - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Filter
n8n-nodes-base.filter - Telegram
n8n-nodes-base.telegram - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Merge
n8n-nodes-base.merge - Split Out
n8n-nodes-base.splitOut
From the author
This workflow automates lead ingestion from Google Sheets and Telegram, leveraging Gemini AI and Lusha for intelligent matching and deep data enrichment. By normalizing incoming data into a standard structure, it uses custom fuzzy logic to identify existing…