n8n Real Estate SMS Campaign Automation: GPT-4.1, Twilio

Automate your real estate SMS campaigns end-to-end with an n8n assistant using GPT-4.1, Twilio, Apify, and Google Sheets

This n8n workflow turns chat conversations into a ready-to-send SMS campaign: it collects campaign details, drafts messages with an OpenAI chat model agent, pulls real estate agents by postcode via Apify, sends personalized SMS through Twilio, and logs delivery outcomes to Google Sheets.

What this workflow does

• Captures campaign requests via webhook: Receives chat messages through a webhook (POST /sms-campaign-assistant) and maintains session-based conversation memory.
• Drafts an SMS with approval: Uses an OpenAI chat model agent to collect budget, requirements, and target postcodes, then drafts an SMS and waits for explicit approval before sending.
• Sends only after confirmation: After approval, triggers the send branch with the finalized message and a comma-separated list of postcodes.
• Finds real estate agents by postcode: Splits the postcode list into individual items and calls an Apify actor for each postcode to retrieve matching local agents with contact details.
• Sends personalized texts with Twilio: Sends each agent an SMS via Twilio, including the agent’s name and a normalized AU phone number format, then captures Twilio’s delivery response.
• Logs results to Google Sheets: Appends message content, recipient details, postcode, and delivery status/error fields to a Google Sheets tab, pausing briefly between sends.

Use cases

• Real estate teams launching targeted outreach by suburb/postcode segments.
• Automation engineers deploying repeatable SMS lead-generation campaigns with human approval steps.
• SaaS operators managing campaign tracking and delivery visibility in Google Sheets.

Technical details

• Integrations/credentials: OpenAI, Twilio, Apify, Google Sheets.
• Workflow behavior: webhook intake, session memory, AI drafting + wait for approval, branching after approval, postcode splitting, per-postcode Apify actor calls, Twilio send with delivery capture, and Google Sheets logging.
• Setup requirements: Provide YOUR_TWILIO_PHONE_NUMBER, YOUR_APIFY_API_TOKEN, and YOUR_GOOGLE_SHEET_ID; ensure a tab named “Send SMS List” with matching columns.