A convenient solution for residential buildings to collect and manage hot water meter readings via Telegram, with automatic Google Sheets integration.

Example of interaction with a bot

• Automated collection of hot water consumption data
• Data validation (numeric values, ranges, proper formats)

The bot consists of two separate Google Apps Script projects:

1. LibrarySheet (Core Library)

• Contains all utility functions and core logic
• Files: All files from LibrarySheet folder
• Deployment: As a library via Deployment Manager
• Versioning: Update library version after significant changes

2. MainBot (Web App)

• Contains only main.gs file
• Must link the deployed LibrarySheet as library
• Deployment: As web app via Deployment Manager

1. Configure Variables:

• Open config.gs in LibrarySheet
• Initialize all required variables (reference param.gs for complete list)
• Example configuration:

  const CONFIG = {
    TOKEN: 'your_telegram_bot_token_from_BotFather',
    WEBAPP_URL: 'pubic_endpoit_of_your_deployment',
    ...
  };

2. Deployment Steps:

   1. Deploy LibrarySheet first (Library type)
   2. Note the library's deployment ID
   3. In MainBot project:
      a. Add LibrarySheet as a library
      b. Deploy as web app (Execute as: Me, Access: Anyone)
   4. Set web app URL as Telegram bot's webhook in config LibrarySheet
   
   

• Mandatory consent agreement flow
• Telegram ID based authentication
• Session timeout (configured) with resume options

The "Settings" sheet controls all bot behavior parameters

📬 If you encounter any issues or have questions about the bot, contact the maintainer directly: