Automation library · Lead generation

Qualify real estate WhatsApp leads with Gemini and Airtable

Started by an incoming WhatsApp message, and works across Airtable, Google Calendar, Google Sheets and WhatsApp. It puts Gemini behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 23 steps, 3 branches: large, and worth reading before you trust it with anything live.

LargeCalls a model: GeminiRetrieval

Download free
23 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
0Loops or waits
4Services it connects to

The flow

Starts it 1Model 5Logic 6Service 11

The steps in the order they run, from what starts it.

  1. 1WhatsApp TriggerWhats App triggerStarts it
  2. 2Gemini Chat ModelLm Chat Google GeminiModel
  3. 3Per-User MemoryMemory Buffer WindowModel
  4. 4check_availabilityGoogle Calendar ToolService
  5. 5book_appointmentGoogle Calendar ToolService
  6. 6Lead Output ParserOutput Parser StructuredModel
  7. 7search_propertiesAirtable ToolService
  8. 8Is Valid Message?IfLogic
  9. 9Real Estate AssistantAgentModel
  10. 10Route by Message TypeSwitchLogic
  11. 11Send WhatsApp ReplyWhats AppService
  12. 12Log Lead to SheetGoogle SheetsService
  13. 13Hot Lead or Escalation?IfLogic
  14. 14Fallback Reply TextSetLogic
  15. 15Normalize Input TextSetLogic
  16. 16Get Audio FileWhats AppService
  17. 17Send Unsupported NoticeWhats AppService
  18. 18Deduplicate EscalationCodeLogic
  19. 19Notify Developer (Error Alert)Whats AppService
  20. 20Download Audio BinaryHttp RequestService
  21. 21Notify Agent (Escalation)Whats AppService
  22. 22Send Fallback Reply to CustomerWhats AppService
  23. 23Analyze audioGoogle GeminiModel

How it's built

Starts on
An incoming WhatsApp message
Steps
23, with 3 branches
Size
Large: read it before trusting it with anything live
Connects to
Airtable, Google Calendar, Google Sheets, WhatsApp
Model
Gemini
Retrieval
Answers are drawn from documents you supply, not from the model alone

Questions

What does it need to run?

An n8n account, plus your own Airtable, Google Calendar, Google Sheets and WhatsApp accounts, and a key for Gemini. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an incoming WhatsApp message.

Does it use AI?

Yes. It calls Gemini. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 23 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 23 steps before you point it at anything that matters.