
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 at scale. If you regularly build reusable, multi-client n8n automations, this template will save you hours of manual work.
Manual lead handling is slow and inconsistent:
This workflow solves the problem by creating a reliable pipeline from capture → enrichment → verification → CRM sync → Outlook draft, cutting handoffs and preserving auditability.
Capture and batching - Triggers on new/updated leads in HubSpot or pulls "ready" rows from Google Sheets; processes items sequentially to stay rate-safe.
Normalize and score (ICP) - Cleans names, company, and domains; applies configurable ICP rules and writes score plus reasoning back to HubSpot/Sheets.
Enrich contacts - Confirms official company details and identifies likely decision-makers via focused people searches; dedupes and role-normalizes.
Verify emails - Finds work emails, checks deliverability, and logs confidence and timestamps to a tracking sheet immediately after each result.
Compose outreach - Calls the approved template in Email content; personalizes only the first name; validates structure via Structured Output Parser.
Draft in Outlook - Uses Microsoft Graph to create an HTML draft; embeds an inline signature image fetched from Google Drive.
CRM sync and tasks - Creates/updates HubSpot contacts and associations, stores the composed email in properties, and opens a next-day follow-up task for the owner.
Safety and observability - Deterministic prompts, strict parsing, idempotent writes, and clear flags prevent duplicates; optional Slack/Teams alerts for failures.
Connect your accounts:
Level 2 Orchestrator and Email content)Set your credentials in the respective nodes.
Adjust the Google Sheet IDs to match your own sheet structure.
Map HubSpot properties (owner, contact/company IDs, custom fields for score, reasoning, and email content).
Paste your approved HTML in Email content and upload your signature image to Drive.
Configure schedule, batch size, and any Slack/Teams webhooks for notifications.
Email content or add A/B variants while keeping structure validation.✨ With this workflow, you go from messy inbound leads → verified contacts → synchronized HubSpot records → ready-to-send Outlook drafts in just minutes, with almost no manual work.
Contact me for consulting and support:
click here