A bill from a meter photo — calculated automatically

A resident sends a meter photo to the messenger, AI reads the numbers, the scenario computes usage and the amount from past data in the table and sends the finished bill back.

  • Readings are taken straight from the photo
  • The amount is computed from past data in the table
  • The bill arrives in the messenger at once
  • New readings are appended to the table by themselves
Google Sheets

How it works

Automating WhatsApp Business Cloud and Google Sheets takes no code: a ready-made scenario does the routine for you.

  1. Starts when: Telegram Trigger
  2. Check: Redirect Message Types
  3. If yes: Get a file
  4. Then: Image Explainer
  5. Then: Get row(s) in sheet
  6. Then: Find Latest Row
  7. Then: Calculate Bill
  8. Then: Prepare Data for Sheet
  9. Then: Append row in sheet
  10. Then: Format Bill Message
  11. Then: Send Bill to Telegram
  12. Then: Google Gemini Chat Model
  13. Then: Structured Output Parser

You can launch this WhatsApp Business Cloud + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.