Project goal: Automate the process of managing partner leads and media submissions in Telegram, integrating it with Kommo CRM and Google Sheets for structured tracking and partner attribution
What was done:
Developed a custom Telegram bot for adding and managing partner leads
Upon being added to a group, the bot asks for the partner’s name, stores it, and links future leads to this partner
Saves all chat data and new client entries into Google Sheets
Creates leads in Kommo with the partner’s name saved in a custom field (Partner)
Supports the /update command to modify partner info if needed
Implements the /new_client command with a structured question flow to collect client details
Handles photo/video uploads using media_group_id, waits 5 seconds to collect full sets, and processes them as one submission
Sends all media for moderation, then edits the original post with moderation results and cleans up intermediate messages
Final client data and file IDs are saved in Google Sheets; optionally supports saving media to Google Drive
Achievements:
Streamlined client data collection and partner tracking
Ensured seamless integration with Kommo CRM and Google Sheets
Simplified media moderation and documentation workflow
Enabled non-technical real estate teams to manage lead flow directly from Telegram
