{"product_id":"n8n-real-estate-sms-campaign-automation-gpt-4-1-twilio","title":"n8n Real Estate SMS Campaign Automation: GPT-4.1, Twilio","description":"\u003ch3\u003eAutomate your real estate SMS campaigns end-to-end with an n8n assistant using GPT-4.1, Twilio, Apify, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures campaign requests via webhook:\u003c\/strong\u003e Receives chat messages through a webhook (POST \u003ccode\u003e\/sms-campaign-assistant\u003c\/code\u003e) and maintains session-based conversation memory.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts an SMS with approval:\u003c\/strong\u003e Uses an OpenAI chat model agent to collect budget, requirements, and target postcodes, then drafts an SMS and \u003cem\u003ewaits for explicit approval\u003c\/em\u003e before sending.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends only after confirmation:\u003c\/strong\u003e After approval, triggers the send branch with the finalized message and a comma-separated list of postcodes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds real estate agents by postcode:\u003c\/strong\u003e Splits the postcode list into individual items and calls an Apify actor for each postcode to retrieve matching local agents with contact details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends personalized texts with Twilio:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results to Google Sheets:\u003c\/strong\u003e Appends message content, recipient details, postcode, and delivery status\/error fields to a Google Sheets tab, pausing briefly between sends.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReal estate teams launching targeted outreach by suburb\/postcode segments.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying repeatable SMS lead-generation campaigns with human approval steps.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing campaign tracking and delivery visibility in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/credentials:\u003c\/strong\u003e OpenAI, Twilio, Apify, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow behavior:\u003c\/strong\u003e webhook intake, session memory, AI drafting + \u003cem\u003ewait for approval\u003c\/em\u003e, branching after approval, postcode splitting, per-postcode Apify actor calls, Twilio send with delivery capture, and Google Sheets logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e Provide \u003ccode\u003eYOUR_TWILIO_PHONE_NUMBER\u003c\/code\u003e, \u003ccode\u003eYOUR_APIFY_API_TOKEN\u003c\/code\u003e, and \u003ccode\u003eYOUR_GOOGLE_SHEET_ID\u003c\/code\u003e; ensure a tab named \u003cstrong\u003e“Send SMS List”\u003c\/strong\u003e with matching columns.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931000496307,"sku":"N8N-18994","price":71.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/E_QTDxuGPsV-zlYumXr5A_o3LHgZQG.png?v=1788253262","url":"https:\/\/buyflowscripts.com\/products\/n8n-real-estate-sms-campaign-automation-gpt-4-1-twilio","provider":"N8N Commerce","version":"1.0","type":"link"}