Automated lead follow-up system with Gmail, Google Calendar & Sheets sync

Description Boost your meeting conversion rates with this Automated Meeting Booking Sequence! This workflow automatically follows up with unbooked leads after 24 hours, sends personalized emails with calendar links and alternate time slots, and confirms bookings via replies or webhook triggers—ensuring you book more meetings with less manual effort.

What This Template Does

📅 Runs every hour to check for unbooked leads 📋 Fetches lead details (name, company, contact info) from Google Sheets 📧 Sends personalized follow-up emails with booking links + alternate time slots 🗓 Creates placeholder events in Google Calendar for reserved slots ⏳ Waits 24 hours to monitor lead responses 📩 Analyzes replies for booking confirmations 🔄 Updates Google Sheets with confirmed “BOOKED” status

Prerequisites

- Google Sheets with lead details (Name, Email, Status, Initial Reply Date) - Gmail API credentials (for follow-up emails) - Google Calendar API credentials (for placeholder events) - n8n instance (self-hosted or cloud)

Step-by-Step Setup

- Use a schedule trigger to run the workflow hourly. - Fetch lead records from Google Sheets. - Add an IF condition to detect leads with status = “Unbooked” OR >24 hrs since reply. - Send a Gmail follow-up email with booking link + 2 alternate time slots. - Create a Google Calendar placeholder event (e.g., 24 hrs from now). - Add a 24-hour delay node to wait for responses. - Fetch Gmail threads to check replies or webhook responses. - If confirmed → update Google Sheets status to “BOOKED.”

Customization Ideas