Airtable and HubSpot integration

Graceful Client Onboarding Concierge — Pro A warm, reliable onboarding system for small businesses and studios. Captures a form submission via webhook, creates a Client record in Notion, sends a concierge-style welcome email (with scheduler + optional contract link), optionally pings the owner on Telegram, mirrors the lead to Airtable/HubSpot, places a temporary Google Calendar hold, and includes a double opt-in confirmation link. Made for: coaches, designers, boutique agencies, e-commerce and service providers who want consistent follow-up without manual busywork. What it does (flow) Trigger:** Form ➜ POST /client-intake (or Manual Trigger for instant demo) Normalize & Score:** Map fields, auto-generate optInToken, compute score and tier Create in Notion:** Clients page (Name, Email, Package, Notes, Status, Score, Tier, OptInToken, Consent=false) Welcome Email:** industry-tuned copy + scheduler link (+ contract link for Growth/Pro/Custom packages) Owner Notify (optional):** Telegram ping with tier + score CRM Mirrors (optional):** Create Airtable row and/or HubSpot contact Calendar Hold (optional):** 30-min “Intro Hold” event (e.g., now + 48h) Double Opt-In:** /optin-confirm?token=...&email=... sets Consent=true & Status=Confirmed in Notion Error Handling:** On failure, send an email to the owner flowchart TD A[Form → Webhook /client-intake] --> B[Map Intake + Score Lead] B --> C[Notion: Create Client] B --> D[Build Welcome Email] D --> E[Email: Send Welcome] D --> F{Optional actions} F -->|Telegram| G[Telegram: Notify Owner] F -->|Airtable| H[Airtable: Create Row] F -->|HubSpot| I[HubSpot: Create Contact] F -->|Calendar Hold| J[Google Calendar: Create Hold] K[GET /optin-confirm] --> L[Find Notion by OptInToken] --> M[Update: Consent=true, Status=Confirmed] ER[Error Trigger] --> EH[Email Owner] Prerequisites Notion* database Clients* with properties: Name (title), Email (email), Package (select), Notes (rich text), Status (select), Score (number), Tier (select), OptInToken (text), Consent (checkbox) (CSV header provided in the Sticky note on canvas.) Email** (SMTP or Gmail OAuth) Optional:** Telegram Bot + Chat ID, Airtable (Base ID + Table), HubSpot (Contacts), Google Calendar (Calendar ID) Configuration (Set these in Set: User Config) NOTION_DB_ID = your Notion Clients DB ID FROM_EMAIL = sender address for welcome email OWNER_EMAIL = where error notifications go SCHEDULER_URL = booking link (Calendly, Once, etc.) BASE_URL = your public n8n domain (for opt-in link) CONTRACT_BASE_URL = (optional) proposal/contract URL base ENABLE_TELEGRAM = true|false TELEGRAM_CHAT_ID = (if enabled) ENABLE_AIRTABLE = true|false AIRTABLE_BASE_ID = (if enabled) AIRTABLE_TABLE = (if enabled) ENABLE_HUBSPOT = true|false ENABLE_CAL_HOLD = true|false CALENDAR_ID = "primary" or calendar ID HOLD_HOURS_FROM_NOW = number of hours (default 48) INDUSTRY = coaching | design_studio | ecommerce | services Credentials: Attach in node credentials panels (no secrets in JSON). How to use Import the workflow JSON. Open Set: User Config and fill required values (see above). Attach credentials: Notion + Email; optional Telegram/Airtable/HubSpot/Google Calendar. Run Manual Trigger to simulate an intake and verify: Notion page created Welcome email received Optional Telegram/CRM/Calendar actions Switch your form to the Production Webhook URL shown in the Client Intake Webhook node. Sample JSON (for testing the live webhook): {"name":"Ava Laurent","email":"[email protected]","package":"Growth","message":"Excited to begin!"} Double opt-in: The welcome email includes a link like https://YOUR-N8N-DOMAIN/webhook/optin-confirm?token=...&email=... Clicking it sets Consent=true and Status=Confirmed on the Notion record. Industry-tuned welcome copy Set INDUSTRY to control phrasing automatically: coaching – gentle goals/blocks framing design_studio – asset handoff + milestone language ecommerce – store link + quick-win focus services – general service language Submission compliance ✅ Manual Trigger path for instant demo ✅ Markdown sticky notes with clear H2 sections (README, Prereqs + CSV, Setup, Testing, Compliance, Changelog) ✅ No hardcoded API keys (credentials only) ✅ Timezone-safe ISO times for calendar hold ✅ Clear placeholders and copy-paste CSV headers included Troubleshooting (quick) No email:** attach Email creds; ensure FROM_EMAIL is allowed by your provider. No Notion page:** verify NOTION_DB_ID and property names; check Notion permissions. Webhook issues:* ensure your form sends JSON*; adapt mapping for form-encoded payloads. Opt-in link fails:** BASE_URL must be your public n8n domain; workflow must be active. Calendar hold not created:** set ENABLE_CAL_HOLD=true, attach Google Calendar creds, confirm CALENDAR_ID. Tags: onboarding, notion, email, crm, telegram, airtable, hubspot, calendar, double-opt-in, small business, concierge, women-led brands Version: v3 (see Changelog sticky on canvas)

Who is this for? This template is perfect for Gumroad creators, solopreneurs, digital product sellers, and freelancers who want to track and thank customers automatically — without spending time on manual work. What problem does this solve? Every sale is a moment to build trust. But manually checking your inbox for new orders, logging clients, and remembering to send a thank-you note? It’s time-consuming and inconsistent. This workflow handles it all: From sale → to sheet → to ping → to personalized “thank you” — all fully automated. What this workflow does: ✅ Triggers on each new sale on Gumroad 📋 Extracts buyer details, amount paid, and product purchased 📈 Logs the sale to a Google Sheet for tracking 📲 Sends a Telegram approval message to notify you 💌 (Optional) Sends a Gmail thank-you email to the buyer 🔁 Keeps your workflow organized with color-coded notes and sample data ⚙️ Setup Instructions: Create Gumroad API and connect the trigger node Authenticate with Google Sheets to store each client Connect your Telegram bot for real-time alerts (Optional) Setup Gmail API for sending thank-you emails Customize the email copy & sheet headers (e.g. % cut, timestamps) 🗒 Color-coded workflow notes: To make customization smooth, the workflow includes a color-coded sticky note system: 🟩 Green Notes – Main building blocks (trigger, logging, ping, email) 🟦 Blue Notes – Setup guidance and editable fields (e.g. your email or brand name) 🟨 Yellow Notes – Optional upgrades (e.g. swap Gmail, use AI email generator, change to WhatsApp) Each step has comments or hints to make your setup easy — whether you're new to n8n or a seasoned automator. 🔧 How to customize this workflow? 🎯 Swap Gmail with Outlook, SMTP, or Mailgun 🤖 Use AI (e.g. OpenAI or Claude) to draft personalized emails dynamically 📞 Replace Telegram with WhatsApp, Discord, or Slack 🗃️ Log to Airtable or Notion instead of Google Sheets 🧠 Add approval logic or advanced tagging in Gmail 🧾 Licensing & Support This template is built by Velebit from Innovatio. External links (Gumroad store or support email) are included in the notes for optional help and upgrades. A separate license applies to the paid version on Gumroad, which includes additional modules and commercial use rights. 📩 Support & customization: [email protected]

Enterprise Legal Vault: AI Classification & Multi-Jurisdictional Security 🎯 Description This enterprise-grade legal document management system provides end-to-end automation for securing, classifying, and managing the lifecycle of sensitive documents. It is designed to handle high-stakes data across multiple jurisdictions (GDPR, CCPA, HIPAA) with AI-powered intelligence. ✨ What This Workflow Does Intelligent Intake & Deduplication - Monitors Google Drive, Email, and Webhooks. It uses SHA-256 fingerprinting to ensure every document is unique and to prevent redundant processing. AI-Powered Analysis Engine - Utilizes OpenAI/Claude to classify documents (NDA, MSA, Employment Agreements), detect jurisdiction, and assign a composite Risk Score (1-100). Dynamic Security Enforcement - Translates business rules from Airtable into technical enforcement using the HTML to PDF (Lock) node: Ultra-High Risk (90+): AES-256 encryption with disabled Print, Copy, and Modify permissions. High Risk (50-89): AES-128 encryption with dynamic recipient-specific watermarking. Public Filings: Timestamped watermarking with no encryption. Lifecycle & Retention Automation - Automatically calculates retention expiry dates based on legal requirements. It sets Google Calendar renewal reminders at 90, 60, and 30-day intervals. Intelligent Distribution Matrix - Verified: Attached to HubSpot Deals and synced to Dropbox client folders. Review: Flagged items are sent to a manual review queue with a Slack preview. Failed: Isolated in a Quarantine folder with incident logging in Airtable. 💡 Key Features Jurisdictional Logic:** Automatically adapts security and retention rules based on regional laws fetched from Airtable. Forensic Watermarking:** Embeds tracking data (User ID, Timestamp) to deter and identify data leaks. Fail-Safe Quarantine:** Prevents unverified or risky documents from ever entering the primary company storage. 📦 Requirements HTML to PDF Node* - Essential for tiered Lock* operations. Airtable** - Acts as the central "Business Rules Engine." Google Drive & HubSpot** - For storage and CRM synchronization. OpenAI/Claude API** - For document classification and risk assessment. 🚀 Benefits ✅ Zero Manual Security Setup - Documents are locked according to corporate policy the moment they are uploaded. ✅ Regulatory Compliance - Meets strict GDPR "Right to be Forgotten" and data localization standards automatically. ✅ Proactive Risk Management - High-liability clauses and auto-renewals are flagged instantly to the legal team. Tags: #legal #compliance #pdf-lock #encryption #gdpr #sec-ops #hubspot #airtable Category: Legal & Compliance Difficulty: Advanced

Who's it for This template is for sales teams, marketing operations (M-Ops), or freelancers who use Airtable as a "control panel" or staging area for new leads. If you're tired of manually copying and pasting approved leads into HubSpot, this workflow automates the entire process for you. How it works This workflow runs on a schedule (e.g., every 5 minutes) to check for new leads. Before: Your Airtable has new leads with a '📥 New Lead' status. The Trigger: You (or a teammate) manually review and change a lead's status to '👍 Ready to Sync'. The Workflow Runs: n8n fetches all leads in that view (up to 50 at a time) and loops through them one by one. For each lead, it: Finds (or creates) a Company in HubSpot based on the email domain. Creates (or updates) a Contact in HubSpot based on the email. Automatically associates that Contact with that Company. After: The workflow automatically updates the same Airtable row with the new HubSpot IDs and a '✅ Synced' status, completing the 2-way sync. This template includes a full batch-processing loop, robust error-handling (it logs failures back to Airtable), and detailed sticky notes to guide you. How to set up Setup should take less than 10 minutes. All detailed instructions are in the sticky notes inside the workflow. Copy the Airtable Base: This is a mandatory first step! You must use this template. ➡️ Click Here to Copy the Base Template (First time using Airtable? Sign up here with my link) Add Your Credentials: How to connect Airtable to n8n (Video) How to connect HubSpot to n8n (Video) Configure 3 Nodes: Schedule Trigger: Set how often you want it to run (e.g., every 5 minutes). get 👍Ready to Sync: Select your Airtable credential and the Base you copied. Also, Do this for the other Airtable nodes. Search company: Select your HubSpot credential. Also, Do this for the othe HubSpot nodes. Activate! Save and activate the workflow. To test it, just change a lead's 'Status' in Airtable to '👍 Ready to Sync'. Requirements An Airtable account. A HubSpot account (a free developer sandbox account is recommended for testing). n8n credentials for both Airtable and HubSpot (using a Private App Token for HubSpot). How to customize the workflow Add More Fields:** Easily sync more data (like 'Phone Number' or 'Lead Source') by adding columns in your Airtable, then adding those fields to the Create or update a contact node in n8n. Change the Schedule:** Adjust the Schedule Trigger to run more or less frequently. Add Notifications:** Connect a Slack or email node to the 👍Done! Going for next record (success) or specially 👎Failed! Going for next record1 (error) paths to get real-time alerts.

AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative — all powered by AI logic, sir. 💡 Key Advantages ⚡ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. 📊 Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. 💬 Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. 🔁 Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. ⚙️ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the “Leads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. 🛠️ Setup Steps Trigger Node:** HubSpot → Detect new leads. HubSpot Node:** Retrieve complete lead details. Code Node:** Clean and normalize data. Airtable Node:** Log lead info in the “Leads” table. AI Agent Node:** Process lead and match with sales team. Slack Node:** Notify the designated representative. Gmail Node:** Email the rep with details. HubSpot Node:** Update CRM with AI summary and allocation status, sir. 🔐 Credentials Required HubSpot OAuth2 API** – To fetch and update leads. Airtable Personal Access Token** – To store and update lead data. OpenAI API** – To power the AI qualification and matching logic. Slack OAuth2** – For sending team notifications. Gmail OAuth2** – For automatic email alerts to assigned reps, sir. 👤 Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir 💬 Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular — perfect for scaling across global sales teams, sir.

How it works • Webhook receives lead form submissions from your website • AI Agent (GPT-4o) analyzes lead quality using intelligent scoring framework • Clearbit enriches company data automatically (employee count, industry, revenue) • Qualification score (0-100) determines routing: high-quality leads → HubSpot CRM + Slack alert, low-quality leads → Airtable for manual review • Structured output parser ensures reliable JSON formatting every time Set up steps • Time to set up: 15-20 minutes • Import the Clearbit sub-workflow first (separate workflow file included) • Create 7 custom properties in HubSpot (qualification_score, buying_intent, urgency_level, budget_indicator, ai_summary, pain_points, recommended_action) • Create Airtable base with 14 columns for low-quality lead tracking • Get Slack channel IDs for sales alerts and review requests • Add credentials: OpenAI (GPT-4o), Clearbit API, HubSpot OAuth2, Slack OAuth2, Airtable Token • Replace placeholder IDs in Slack and Airtable nodes • Configure the Clearbit Enrichment Tool node with your sub-workflow ID What you'll need • OpenAI API - OpenAI model access for AI qualification • Clearbit API - Free tier available for company enrichment • HubSpot - Free CRM account works • Slack - Standard workspace • Airtable - Free plan works • Website form - To send webhook data Who this is for Sales teams and agencies that want to automatically qualify inbound leads before they hit the CRM. Perfect for B2B companies with high lead volume that need intelligent routing.