← All projects
AutomationUnited States·2024·3 months
Telegram to Google Sheets Bot
Python bot that continuously monitors a private Telegram channel and forwards messages to Google Sheets in a custom structured format.
Overview
Built a Telegram monitoring bot for a US-based client who needed to archive and structure messages from a private channel automatically.
How It Works
- Connects to the private Telegram channel via Telethon (user-level session)
- Listens for new messages in real time
- Parses and formats the content to match a specific spreadsheet schema
- Appends rows to Google Sheets via the Sheets API
Highlights
- Runs as a background daemon
- Handles media, text, and forwarded messages
- Custom format mapping per message type
- Error handling and retry logic for API rate limits
Tech stack
PythonTelethonTelegram APIGoogle Sheets API
★★★★★
"Ghandour made the bot I was requesting exactly how I wanted it and fixed any errors I had."
— Drew Hansen · United States