Quick overview
Quick overview When a buyer misses a scheduled viewing, this workflow automatically sends an AI-personalized follow-up by email and WhatsApp using Google Gemini, then logs the outcome to Google Sheets, recovering leads that would otherwise go cold. How it works Triggers every 15 minutes when a Google Calendar event is updated in the selected viewings calendar. Checks the event title/summary and continues only if it contains the tag “no-show”. Extracts the lead’s name, email, phone, property address, and scheduled viewing time from the calendar event details. Sends the lead and viewing context to Google Gemini to generate an email message and a WhatsApp message in JSON format. Parses and cleans the AI output into safe HTML for email and a trimmed plain-text WhatsApp message. Sends the re-engagement email via Gmail and appends the follow-up outcome to a Google Sheets log. If a phone number is available, sends the WhatsApp message and updates a Google Sheets status field to record that WhatsApp was sent. Setup Connect credentials for Google Calendar, Gmail, Google Sheets, and a Google Gemini (PaLM) API key. Select the correct Google Calendar (viewings calendar) and ensure missed appointments are consistently tagged with “no-show” in the event summary. Create or choose a Google Sheets document and sheet, then fill in the document ID/URL, sheet name, and the columns expected by the append/update logging steps. Configure WhatsApp credentials in n8n (or disable the WhatsApp branch) and ensure lead phone numbers are stored in the calendar event description in the expected format (e.g., Name: ... | Email: ... | Phone: ... |). Requirements Before running this workflow, create a Google Sheet with these exact column headers: Record ID | Lead Name | Email | Phone | Property Address | Original Viewing Time | Email Sent | WhatsApp Sent | Email Message Text | WhatsApp Message Text | Timestamp Customization Edit the AI prompt in "Draft Re-Engagement Messages" to change tone or language Add SMS or other channels by duplicating the WhatsApp branch pattern Adjust the "no-show" tag keyword if your calendar uses different terminology Additional info WhatsApp is optional. If you don't have WhatsApp Business Cloud API credentials, disable that branch — the email follow-up will still send normally. This template assumes calendar events are tagged with "no-show" in the title and include lead contact info in the event description (Name: ... | Email: ... | Phone: ... |). An n8n automation workflow template by Hassan.
Hassan
web
free
Others in the same category, ranked by how often they are opened.
