Lead follow-up & inside sales

When you tag a showing "no-show" in Google Calendar, n8n has Gemini write a low-pressure reschedule email and WhatsApp message to the buyer and logs both to a sheet

An n8n template by Hassan watches a showings calendar in Google Calendar and continues only when an event title contains the tag "no-show". The workflow reads the buyer's name, email, phone, the property address, and the original showing time from the event description, then sends that context to Google Gemini, which returns a short, warm email and a casual WhatsApp message that offer to reschedule without guilt-tripping the buyer. Gmail sends the email and Google Sheets logs the outcome; if a phone number is present, the WhatsApp Business message sends and the sheet records that it went out. WhatsApp is optional and the email branch works on its own.

At a glance

Tools used
n8nGoogle GeminiGoogle CalendarGmailWhatsApp BusinessGoogle Sheets
Category
Lead follow-up & inside sales
Audience
buyer's agent, showing assistant, solo agent
Difficulty
Builder
Source
Re-engage missed property viewings with Google Calendar, Gemini, Gmail, and WhatsApp
Hassan (n8n creator) · n8n template · Jun 21, 2026
First step
Put buyer details in your showing events in one consistent format (Name: ... | Email: ... | Phone: ...), create the template's log sheet with its column headers, then add "no-show" to one past showing to test the email branch before you connect WhatsApp.

Compliance note: Text or WhatsApp a buyer only if the buyer gave you that number and consent to message there, and stop after one follow-up if the buyer does not reply.

Suggested prompt

Written by this directory, inspired by the source. Replace the [bracketed] parts.

A buyer missed a scheduled showing. Write two messages offering to reschedule. Tone: friendly, low-pressure, never guilt-tripping. Email: a greeting line ("Hi [first name],"), then one short paragraph that names the property address and the original showing time and offers two ways to pick a new time. WhatsApp: one short casual paragraph with the address and a reschedule offer, no greeting line. Return JSON with email_message and whatsapp_message. Buyer name: [name]. Property address: [address]. Original showing time: [time].

Share on X Read the source

← All use cases