Utility Bill Installment Request Automation (n8n) with Forms

Automate Utility Bill Installment Requests in n8n (with Forms + Google Sheets Verification)

Turn every utility bill installment request into a validated, email-notified, and fully logged process. This n8n automation workflow accepts submissions from an n8n form, verifies customer and bill details against Google Sheets, then sends outcome emails via Gmail while recording every result in a request log spreadsheet.

What this workflow does

Designed for utility bill installment request automation, it follows a strict verification flow:

• Receives a form submission and initializes configuration plus a unique Request ID.
• Validates required fields and customer consent; invalid submissions are rejected and trigger a Gmail notification and a Google Sheets log entry.
• Looks up the Consumer Number in a Customer_Master sheet; if the account is missing or inactive, the request is rejected with email + log.
• Verifies mobile number and email match the registered customer record; mismatches are rejected with email + logging.
• Fetches the customer’s current bill from Bill_Master; if no bill exists or there is no payable outstanding balance, the outcome is emailed and logged.
• Checks for active installments or billing disputes; active-installment cases are rejected, and disputed bills are marked for manual review, with email + logging.
• When all checks pass, it marks the request as verified and appends verified bill context to the installment request log in Google Sheets.

Use cases

• Reduce manual review for utility installment requests by automating identity and bill checks.
• Ensure consistent outcomes with a Request Log for every approval/rejection/dispute.
• Handle high-volume form submissions while keeping communications centralized through Gmail.

Technical details

• n8n nodes/workflow components: form trigger, if, set, gmail, sticky note, google sheets.
• Google Sheets: create/configure Customer_Master and Bill_Master (plus a request log spreadsheet/tab).
• Outcome handling: email the customer via Gmail and log every result to Google Sheets.