What This Workflow Does
This automation acts as a complete "AI receptionist" for mortgage brokers and high-ticket service providers. It solves the messy, time-consuming process of manually qualifying leads, getting internal approvals, and collecting sensitive client documents. The workflow automatically filters incoming leads based on configurable criteria (like income >$80k), engages the broker for a quick Approve/Decline decision via Telegram, then handles the entire client onboarding sequence.
Once approved, the system uses Google Gemini AI to write personalized welcome emails, creates dedicated Google Drive folders for document collection, and monitors for uploaded files. It maintains a complete audit trail in Supabase, ensuring no lead falls through the cracks while saving brokers 10-15 hours of administrative work per week.
How It Works
1. Lead Capture & Initial Screening
The workflow triggers when a new lead submits information through a web form or API. It immediately evaluates the lead against your qualification criteria (income, loan type, location, etc.). Unqualified leads are automatically filtered out with a polite rejection email, while promising leads proceed to the next stage.
2. Human-in-the-Loop Broker Approval
Qualified leads trigger an instant notification to the broker via Telegram, containing key lead details and "Approve/Decline" buttons. With one tap, the broker makes the final decision. This maintains crucial human judgment while eliminating email chains and calendar checks.
3. AI-Personalized Onboarding
Upon approval, Google Gemini AI generates a warm, personalized welcome email addressing the client by name and referencing their specific loan inquiry. Simultaneously, a unique, organized Google Drive folder is created for that client, with the upload link automatically inserted into the email draft in Gmail.
4. Automated Document Collection & Verification
The system monitors the client's dedicated Drive folder for required documents (ID, payslips, bank statements). It validates file types and sends reminders if items are missing. Once all documents are received, the broker gets a completion notification. All actions are logged in Supabase for full transparency and compliance.
Who This Is For
This template is ideal for mortgage brokers, loan officers, financial advisors, and any high-ticket service provider dealing with client onboarding. It's particularly valuable for solo brokers or small teams looking to scale their operations without adding administrative staff. Real estate agencies processing multiple loan referrals weekly will see immediate efficiency gains. Even larger financial institutions can use this as a blueprint for digitizing and automating manual intake processes.
What You'll Need
- n8n instance (cloud or self-hosted) with webhook access
- Google Cloud Project with Drive, Gmail, and Gemini APIs enabled
- Telegram Bot Token and your personal/team Chat ID
- Supabase Project or alternative database (Airtable, PostgreSQL)
- Basic understanding of connecting APIs (credentials setup in n8n)
Quick Setup Guide
- Download & Import: Click the download button above and import the JSON file into your n8n instance.
- Configure Credentials: Set up credentials in n8n for Google (Drive, Gmail, Gemini), Telegram, and Supabase.
- Database Setup: Create a
leads_consolidatedtable in Supabase using the schema provided in the workflow's sticky notes. - Customize Thresholds: Adjust the income and qualification criteria in the "IF" node to match your business rules.
- Update Contact Points: Replace the Telegram Chat ID with your own and customize the AI email templates.
- Test & Activate: Use the webhook trigger URL to simulate a lead submission and verify the entire flow works end-to-end before connecting to your live lead sources.
Pro tip: Start by testing with a single lead source (like your website contact form) before connecting all your channels. Use the Supabase logs to monitor each step during initial testing.
Key Benefits
Response time drops from hours to minutes. Leads receive personalized communication immediately after broker approval, dramatically increasing conversion rates. The 24/7 automated qualification means you never miss a lead, even after business hours.
Eliminate manual document chasing. Automated folder creation, upload links, and reminder systems ensure complete document packages are collected faster. Brokers save 5-7 hours weekly previously spent on email follow-ups and file organization.
Maintain quality with human oversight. The Telegram approval step ensures brokers retain final decision authority on all leads. This balances automation efficiency with the necessary human judgment for complex financial decisions.
Full compliance and audit trail. Every action—from initial submission to document upload—is timestamped and logged in Supabase. This creates an immutable record perfect for regulatory compliance and internal process analysis.
Scalable architecture. The modular design allows easy swapping of components. Replace Gemini with OpenAI, Supabase with Airtable, or Telegram with Slack based on your existing tech stack and preferences.