Run an AI SDR sales pipeline with OpenAI, Google Sheets, Gmail and Calendar
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 31 nodes and runs on a schedule (every 24 hours) (plus 3 other triggers). Along the way it connects Google Sheets, Gmail, OpenAI Chat Model and Google Calendar.
How it runs
Trigger: On a schedule (every 24 hours) (plus 3 other triggers).
- Email List (Google Sheets): uses Google Sheets
- Get rows from CRM (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Check for "No Shows" (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Filter: keeps only the items that match a condition
- Update CRM (Call Scheduled) (Google Sheets): update
- Send No-Show Follow-Up (Gmail): uses Gmail
- Count (Summarize): summarizes / groups the items
- Update CRM (Google Sheets): append or update
…plus 15 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Summarize
n8n-nodes-base.summarize - Filter
n8n-nodes-base.filter - Switch
n8n-nodes-base.switch - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Calendar Trigger
n8n-nodes-base.googleCalendarTrigger
From the author
This n8n template is a complete, automated sales operating system. It acts as an AI-powered sales development representative (SDR) that moves leads into a CRM, sends highly personalized follow-up sequences, tracks calendar bookings, and automatically handles…