Run an AI SDR sales pipeline with OpenAI, Google Sheets, Gmail and Calendar
n8n31 modulesv1.0This 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 meeting no-shows. Instead of manually tracking who needs to be emailed next or cross-referencing your calendar with your spreadsheet, this workflow handles the entire outreach lifecycle in the background. How it works This template is divide
At a glance
Run an AI SDR sales pipeline with OpenAI, Google Sheets, Gmail and Calendar is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI, Google Calendar. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, OpenAI, Google Calendar, LinkedIn
- Modules
- 31
- Price
- Free
- Version
- v1.0
About this workflow
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 meeting no-shows. Instead of manually tracking who needs to be emailed next or cross-referencing your calendar with your spreadsheet, this workflow handles the entire outreach lifecycle in the background. How it works This template is divided into four autonomous processes: 1. The CRM Agent: A scheduled trigger runs daily to pull fresh leads from a temporary "Lead List" Google Sheet, adds them to your master CRM Sheet, formats the data, and then resets the temporary list so it's ready for the next batch. 2. The Follow-Up Agent: A scheduled trigger checks your CRM for active leads who haven't booked a call yet and haven't been emailed in the last 48 hours. Using an OpenAI language model, it customizes one of three sequential follow-up templates based on the prospect's name, role, company, and industry. It sends the email via Gmail and automatically logs the follow-up count and date in your CRM. 3. The Concierge Agent: Whenever a new event is created in Google Calendar, this flow intercepts it. If it matches your criteria, it finds the attendee's email in your CRM and updates their status to indicate a call is scheduled—instantly pulling them out of the automated follow-up sequence. 4. The No-Show Agent: Every 6 hours, a trigger checks your CRM for anyone explicitly marked as a "No Show." It sends them a polite, automated email via Gmail offering to reschedule and updates their CRM status so they aren't emailed twice. How to use 1. Duplicate the required Google Sheets structure (a basic Lead List and a CRM with columns for contact info, sequence tracking, and call statuses). 2. Authenticate your Google Sheets, Google Calendar, and Gmail accounts within n8n. 3. Update the Google Calendar trigger to point to your specific booking calendar. 4. Open the AI LLM Chain nodes to customize the email copy, replacing the placeholder calendar links and my sign-off with your own details. 5. Activate the workflow and let your automated sales pipeline run. What you get Automated data entry from lead list to CRM 3-step, AI-personalized email sequence Automatic sequence halting when a prospect books a call Automated rescheduling emails for missed meetings A completely self-updating Google Sheets CRM Requirements Google Sheets access Gmail account Google Calendar account OpenAI API credentials for email personalization Need help? Ask in the n8n Forum or shoot me a DM on LinkedIn. Happy automating 🚀
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create Tasks from e-mails in Tallyfy
Export all messages from dialogs in Chatforma
DNB company search & extract with Bright Data and OpenAI 4o mini
Automate job search and matching with Adzuna API, GPT-3.5, and Google Sheets
Generate course certificates from Google Sheets with Stencil PDF and Outlook
YouTube to WhatsApp sales automation with WordPress, FluentCRM and Whinta
Automate a Tally form: store with Airtable, notify via Slack
Scrape AI news from multiple sources to Markdown & Google Drive with RSS.app
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you