Run real estate SMS campaigns with GPT-4.1, Apify, Twilio, and Google Sheets
Ready for 3.0Ready 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 16 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI Chat Model and Twilio. It also calls api.apify.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Campaign assistant (AI Agent): runs an AI agent, with model: Chat model; 1 tool (Find agents and send tool); memory: Conversation memory
- Split the postal codes (AI Transform): uses AI Transform
- Reply to the chat (Respond to Webhook): sends the response back to the webhook caller
- Loop over postal codes (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop over agents (Loop Over Items (Split in Batches)): loops over the items in batches
- Find agents in this area (HTTP Request): calls api.apify.com (POST)
- Log results to sheet (Google Sheets): append
- Send the SMS (Twilio): uses Twilio
- Keep the contact fields (Edit Fields (Set)): sets 6 fields: fullName, email, phoneNumber…
- Capture the delivery result (Edit Fields (Set)): sets 12 fields: account_sid, Body, Date Created …
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
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.
- Still check AI Transform (Split the postal codes): Automatically migrated to a Code node on upgrade, keeping the generated JavaScript. You can no longer add new AI Transform nodes.
Nodes used (14)
- Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow - Edit Fields (Set)
n8n-nodes-base.set - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Respond to Webhook
n8n-nodes-base.respondToWebhook - Webhook
n8n-nodes-base.webhook - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Transform
n8n-nodes-base.aiTransform - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Wait
n8n-nodes-base.wait - Twilio
n8n-nodes-base.twilio
From the author
Quick overview This workflow runs a chat-based assistant that drafts and approves an SMS campaign, finds real estate agents by postcode via Apify, sends personalized texts with Twilio, and logs delivery results to Google Sheets. How it works 1. Receives chat…