Run a full lead-to-meeting pipeline with Google Sheets, Gmail, Gemini and OpenAI

by Ayaan Sheikh ✓ · 44 views · created 2026-07-22 · Lead Generation, AI Chatbot

What this workflow does

This AI workflow has 52 nodes and runs when an HTTP GET request hits its webhook URL (plus 5 other triggers). Along the way it connects Google Gemini, Google Sheets, Gmail and OpenAI and 1 more.

How it runs

Trigger: When an HTTP GET request hits its webhook URL (plus 5 other triggers).

1. Normalize Lead Data (Edit Fields (Set)): sets or maps fields
2. Lookup Lead by Contact (Google Sheets): uses Google Sheets
3. Read Leads Awaiting Reply (Google Sheets): uses Google Sheets
4. Mark Status: Meeting Booked (Google Sheets): uses Google Sheets
5. Read All CRM Rows (Google Sheets): uses Google Sheets
6. Read Today's Meetings (Google Sheets): uses Google Sheets
7. Enrich Lead (Clearbit/Apollo) (HTTP Request): calls an HTTP API
8. AI: Classify Reply Intent (OpenAI): uses OpenAI
9. Filter: keeps only the items that match a condition
10. Get Full Lead History (Google Sheets): uses Google Sheets

…plus 36 more steps. See the full node list below.

Services it uses

Google GeminiGoogle SheetsGmailOpenAISlack

Before you upgrade to n8n 3.0

Nodes used (13)

• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Gmailn8n-nodes-base.gmail
• Switchn8n-nodes-base.switch
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Filtern8n-nodes-base.filter
• Waitn8n-nodes-base.wait
• Slackn8n-nodes-base.slack

From the author

Quick overview This workflow captures new leads via webhook, enriches and scores them with Apollo and Google Gemini, logs everything in Google Sheets, and automates outreach, reply handling, follow-ups, meeting prep, weekly reporting, and no-show…

View the original on n8n.io → Check your own copy