Collect and reconcile rent with Google Sheets, Gmail, Twilio, and OpenAI

by Luca ✓ · 2 views · created 2026-10-03 · Invoice Processing, AI Chatbot

What this workflow does

This AI workflow has 30 nodes and runs on a schedule (every hour) (plus 3 other triggers). Along the way it connects Twilio, Gmail, Google Sheets and OpenAI Chat Model.

How it runs

Trigger: On a schedule (every hour) (plus 3 other triggers).

1. Set Rent Settings (Edit Fields (Set)): sets 41 fields: sheet_id, business_name, manager_name…
2. Alert on Workflow Failure (Gmail): uses Gmail
3. Set Message Texts (Edit Fields (Set)): sets 16 fields: subject_default, heads_up_subject, heads_up…
4. Read Leases (Google Sheets): uses Google Sheets
5. Aggregate: combines items into one
6. Read Owners (Google Sheets): uses Google Sheets
7. Aggregate: combines items into one
8. Read Index (Google Sheets): uses Google Sheets
9. Aggregate: combines items into one
10. Read Bank (Google Sheets): uses Google Sheets

…plus 15 more steps. See the full node list below.

Services it uses

TwilioGmailGoogle SheetsOpenAI Chat Model

Before you upgrade to n8n 3.0

Nodes used (13)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Twilio Triggern8n-nodes-base.twilioTrigger
• Gmail Triggern8n-nodes-base.gmailTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Aggregaten8n-nodes-base.aggregate
• Switchn8n-nodes-base.switch
• Coden8n-nodes-base.code
• Twilion8n-nodes-base.twilio
• Gmailn8n-nodes-base.gmail
• Information Extractor@n8n/n8n-nodes-langchain.informationExtractor
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Error Triggern8n-nodes-base.errorTrigger

From the author

Quick Overview This workflow runs hourly to calculate rent due from Google Sheets leases, match incoming bank statement lines to tenants, and automatically chase arrears via Twilio SMS and Gmail email, using OpenAI to classify tenant replies and pause,…

View the original on n8n.io → Check your own copy