Automate real estate marketing with Llama AI, VAPI calls & Gmail campaigns
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 12 nodes and runs on Google Sheets events (plus 1 other trigger). Along the way it connects Ollama Chat Model, Google Sheets and Gmail. It also calls api.vapi.ai over HTTP.
How it runs
Trigger: On Google Sheets events (plus 1 other trigger).
- Get Client Contact List (Google Sheets): uses Google Sheets
- Delay for Lead Parsing (Wait): pauses before continuing
- Trigger Voice Campaign via VAPI (HTTP Request): calls api.vapi.ai (POST)
- Generate Promo Content with Llama (AI Agent): runs an AI agent, with model: Llama 3.2 - Promo Content Model
- Save Lead to CRM Sheet (Google Sheets): append or update
- Delay to Sync Data (Wait): pauses before continuing
- Send Acknowledgement to VAPI (Respond to Webhook): sends the response back to the webhook caller
- Create Personalized Email Template (Code): runs custom JavaScript code
- Email Promo to Clients (Gmail) (Gmail): uses Gmail
Services it uses
HTTP calls to: api.vapi.ai
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 (10)
- Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
This automated n8n workflow streamlines real estate marketing by combining voice campaigns and email outreach with AI-powered lead generation. The system monitors real estate offers, generates personalized promotional content using AI, creates targeted email…