{"product_id":"gpt-4o-vision-utility-bill-splitter-n8n-webhook-postgres-gmail","title":"GPT-4o Vision Utility Bill Splitter | n8n Webhook + Postgres + Gmail","description":"\u003ch3\u003eSplit Utility Bills Automatically with GPT-4o Vision (n8n Webhook + Postgres + Gmail)\u003c\/h3\u003e\n\u003cp\u003eSend a utility bill image to an n8n webhook and this workflow will automatically extract key fields using \u003cstrong\u003eGPT-4o Vision\u003c\/strong\u003e, split the total across your rental units using \u003cstrong\u003ePostgres tenant weights\u003c\/strong\u003e, and notify both \u003cstrong\u003eowners and tenants via Gmail\u003c\/strong\u003e—with daily follow-ups until every bill is completed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives bill submissions via webhook:\u003c\/strong\u003e Accepts a POST request containing a utility bill image (URL or base64) plus basic metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts bill details using GPT-4o Vision:\u003c\/strong\u003e If an image is present, the workflow parses returned JSON fields such as provider, dates\/period, and total amount.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and handles errors:\u003c\/strong\u003e Rejects unreadable bills, missing totals, or non-positive totals—logging issues to \u003cstrong\u003ePostgres\u003c\/strong\u003e and alerting the team via \u003cstrong\u003eDiscord\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates per-unit charges:\u003c\/strong\u003e Loads the tenant roster from \u003cstrong\u003ePostgres\u003c\/strong\u003e and computes a deterministic split proportional to each unit’s occupancy weight, using cent-accurate rounding.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves records and communicates:\u003c\/strong\u003e Stores the bill and per-unit charge records in \u003cstrong\u003ePostgres\u003c\/strong\u003e, posts a summary to \u003cstrong\u003eDiscord\u003c\/strong\u003e, emails the owner a detailed breakdown, and emails each tenant their individual charge.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarks completion:\u003c\/strong\u003e Updates the bill status as “done” in \u003cstrong\u003ePostgres\u003c\/strong\u003e after tenant notifications are sent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily for follow-ups:\u003c\/strong\u003e Scheduled execution finds older bills not marked done and emails\/posts a follow-up list (or an all-clear) to \u003cstrong\u003eDiscord\u003c\/strong\u003e and the owner.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProperty managers splitting monthly utilities across multiple rental units without manual spreadsheets.\u003c\/li\u003e\n  \u003cli\u003eTeams needing reliable bill extraction from forwarded email images or form uploads.\u003c\/li\u003e\n  \u003cli\u003eOperators who want automated reminders for incomplete bill processing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools:\u003c\/strong\u003e webhook, if, set, code, Gmail, Discord.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eOpenAI GPT-4o Vision\u003c\/strong\u003e for extraction, \u003cstrong\u003ePostgres\u003c\/strong\u003e for tenant roster + bill\/charge storage, \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e for notifications, and a \u003cstrong\u003eDiscord bot\u003c\/strong\u003e for alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e Configure credentials for OpenAI, Postgres, Gmail, and Discord, and ensure Discord server\/channel IDs match your workflow settings.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950255202483,"sku":"N8N-19125","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/usZSrLqTc7yCLAG7lEx17_d8Kox7fw.png?v=1788514218","url":"https:\/\/buyflowscripts.com\/products\/gpt-4o-vision-utility-bill-splitter-n8n-webhook-postgres-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}