Automate lead intelligence & outreach with GPT-4o, LinkedIn, HubSpot & Outlook
UnknownWhat this workflow does
This AI workflow has 93 nodes and runs on Google Drive events (file created) (plus 4 other triggers). Along the way it connects Google Drive, HubSpot, OpenRouter Chat Model and Perplexity and 3 more. It also calls graph.microsoft.com and api.hubapi.com over HTTP.
How it runs
Trigger: On Google Drive events (file created) (plus 4 other triggers).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Get many companies (HubSpot): get many (company)
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- apify_scraper (AI Agent): runs an AI agent, with model: OpenRouter Chat Model; memory: Simple Memory; output parser: Structured Output Parser
- Get many companies (HubSpot): get many (company)
- Filter: keeps only the items that match a condition
- Edit Fields (Edit Fields (Set)): sets 11 fields: country, hotelid, no_of_rooms…
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 28 more steps. See the full node list below.
Services it uses
HTTP calls to: graph.microsoft.com, api.hubapi.com
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Run an Actor1, Get dataset items).
Rarely used nodes in this template: n8n-nodes-base.hunterTool
Nodes used (26)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - HubSpot
n8n-nodes-base.hubspot - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Filter
n8n-nodes-base.filter - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Hubspot Tool
n8n-nodes-base.hubspotTool - Perplexity Tool
n8n-nodes-base.perplexityTool - Wait
n8n-nodes-base.wait - AI Agent
@n8n/n8n-nodes-langchain.agent - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Limit
n8n-nodes-base.limit - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - If
n8n-nodes-base.if - Apify
@apify/n8n-nodes-apify.apify - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Google Sheets
n8n-nodes-base.googleSheets - Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow - Hunter Tool
n8n-nodes-base.hunterTool - HTTP Request
n8n-nodes-base.httpRequest - Extract from File
n8n-nodes-base.extractFromFile - Google Drive
n8n-nodes-base.googleDrive
From the author
AI Lead Intelligence & Outreach: Verified Emails, HubSpot Sync & Outlook Drafts Who is this for? This workflow is designed for sales/RevOps teams, B2B founders, SDR/AE teams, and agencies who live in HubSpot and need consistent, compliant first-touch outreach…