bot_report — Telegram bot for exporting reports from Google Sheets

The bot provides a summary report of the company stored in Google Sheets. It is implemented using pure requests: a custom long polling loop getUpdates with offset management and deduplication of updates by update_id (a set of processed ids trimmed to the last 1000 to avoid memory accumulation).

Password authentication

Access to the bot is password-protected. The list of authorized users is persisted in a JSON file (authorized_users.json); the password check normalizes input (removing spaces and converting to lowercase). After authorization, the user is provided with a permanent ReplyKeyboard featuring an export button.

Export via Google Drive API

The sheet is protected, so downloading occurs via the Google Drive API: a service account (api_gg.json) is authorized in the drive.readonly scope, the file is exported using the files().export_media method in xlsx format (preserving all sheets and styles) and downloaded in chunks through MediaIoBaseDownload to a temporary file, which is then sent as a document and deleted. Errors at each stage are caught and returned to the user with clear messages.