Templates / Handle real estate SMS inquiries with Twilio, Google Sheets, Gemini, and Calendar

Handle real estate SMS inquiries with Twilio, Google Sheets, Gemini, and Calendar

Ready for 3.0

by iamvaar ✓ · 59 views · created 2026-07-08 · Support Chatbot, AI Chatbot

Ready 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 18 nodes and runs on Twilio events (com.twilio.messaging.inbound message.received). Along the way it connects Twilio, Google Sheets, Google Calendar and Redis Chat Memory and 1 more.

How it runs

Trigger: On Twilio events (com.twilio.messaging.inbound message.received).

  1. Fetch Lead Info (Google Sheets): uses Google Sheets
  2. Check Lead Exists (If): checks a condition and branches into true / false
  3. Initialize Output Array (Code): runs custom JavaScript code
  4. Upsert Lead Info (Google Sheets): append or update
  5. Fetch Property Details (Google Sheets): uses Google Sheets
  6. Aggregate: combines items into one
  7. Parse Lead Data (Code): runs custom JavaScript code
  8. If: checks a condition and branches into true / false
  9. Property Inquiry Agent (AI Agent): runs an AI agent, with model: Gemini Pro Model; 5 tools (Update Email Tool, Fetch Property Info Tool, Create Calendar Event Tool, Update Interested Property Tool…); memory: Redis Chat Memory
  10. Send Twilio Reply (Twilio): uses Twilio

Services it uses

TwilioGoogle SheetsGoogle CalendarRedis Chat MemoryGoogle Gemini Chat Model

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 (11)

From the author

Quick overview Youtube Explanation: https://youtu.be/e07nGFmVs0 This workflow replies to inbound Twilio SMS messages with property details and viewing scheduling help by looking up leads and properties in Google Sheets, using a Google Gemini agent with Redis…

Excerpt from iamvaar's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.