Split shared rental utility bills with gpt-5.6-terra Vision, Postgres and Gmail

by Khairul Muhtadin ✓ · 3 views · created 2026-09-03 · Invoice Processing, AI Summarization

What this workflow does

This workflow has 29 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Postgres, Discord and Gmail. It also calls api.openai.com over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

1. Normalize forwarded bill (Edit Fields (Set)): sets 8 fields: bill_id, source, received_at…
2. Find bills from yesterday or older (Postgres): run a query
3. Has a bill image attached (If): checks a condition and branches into true / false
4. Build follow up summary (Code): runs custom JavaScript code
5. Build GPT-4o vision request (Code): runs custom JavaScript code
6. Alert missing image on Discord (Discord): work with message
7. Email missing image notice (Gmail): uses Gmail
8. Are there open bills (If): checks a condition and branches into true / false
9. Read the bill with GPT-4o vision (HTTP Request): calls api.openai.com (POST)
10. Post follow up on Discord (Discord): work with message

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

Services it uses

PostgresDiscordGmail

HTTP calls to: api.openai.com

Before you upgrade to n8n 3.0

Nodes used (9)

• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Postgresn8n-nodes-base.postgres
• Discordn8n-nodes-base.discord
• Gmailn8n-nodes-base.gmail
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

Split the utility bill fairly without spreadsheet drama. Snap a photo of the bill and this workflow reads it with AI vision, splits charges across rental units by occupancy weight, and notifies owners and tenants. A daily sweep catches anything left unpaid.…

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