Automate water bill calculations with Telegram, Gemini AI, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (9)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Switch
n8n-nodes-base.switch - Telegram
n8n-nodes-base.telegram - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set
What it does
Automate Water Bill Calculations with Telegram, Gemini AI, and Google Sheets !Screen Shot 20250911 at 20.48.18.png(fileId:2357) This workflow automates the calculation of monthly water bills. Residents can send a photo of their water meter along with their name via Telegram. The workflow uses Gemini AI to extract the meter reading, calculates the usage difference compared to the previous month, and updates a Google Sheet with the billing details. Finally, the workflow sends a summary back via Telegram. Don’t hesitate to reach out if you have any questions or run into issues! 🙌 Requirements - A Telegram bot token (created via BotFather). - A Google account with access to Google Sheets. - A Gemini API key ((Google AI Studio)). - A pre-created Google Sheet with the required columns. Google Sheet Setup Create a new Google Sheet with the following columns: Nama, Volume Sebelumnya, Volume Saat Ini, Harga/m³, Jumlah Bayar, Beban, Total Bayar, Tanggal Input Workflow Setup Instructions 1. Connect Google Sheets - Add your Google Sheets credentials in n8n. - Link the workflow to your sheet with the structure above. 2. Set Up Telegram Bot - Create a Telegram bot via BotFather. - Copy your bot token into the Telegram Trigger node. 3. Configure Gemini AI - Obtain a Gemini API key from Google AI Studio. - Add it to your n8n credentials. - The workflow will parse the meter reading from the uploaded image. Example Calculation Previous Volume: 535 m³ Current Volume: 545 m³ Usage: 10 m³ Price per m³: Rp3.000 Fixed cost: Rp3.000 Total Bill: Rp33.000 How It Works - User sends a photo of the water meter with caption (name). - Telegram Trigger receives the message. - Gemini AI reads the meter number from the photo. - Workflow fetches previous volume from Google Sheets. - Usage and total bill are calculated. - Data is stored back into Google Sheets. - Bot replies in Telegram with detailed bill info. Customization - Change Harga/m³ in the sheet to match your community’s water price. - Update Beban if your community uses a different fixed fee. - Edit the Telegram reply message node to adjust wording. With this workflow, you can streamline water billing for residents, ensure accuracy, and save time on manual calculations.