Handle real estate SMS inquiries with Twilio, Google Sheets, Gemini, and Calendar
Ready for 3.0What 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).
- Fetch Lead Info (Google Sheets): uses Google Sheets
- Check Lead Exists (If): checks a condition and branches into true / false
- Initialize Output Array (Code): runs custom JavaScript code
- Upsert Lead Info (Google Sheets): append or update
- Fetch Property Details (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Parse Lead Data (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- 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
- Send Twilio Reply (Twilio): uses Twilio
Services it uses
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)
- Twilio Trigger
n8n-nodes-base.twilioTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Aggregate
n8n-nodes-base.aggregate - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Google Calendar Tool
n8n-nodes-base.googleCalendarTool - Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - AI Agent
@n8n/n8n-nodes-langchain.agent - Twilio
n8n-nodes-base.twilio
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…