CRM-bot for order processing: Telegram + Trello + Google Sheets

Developed a "turnkey" custom CRM system for a digital artist that fully automates the process from order receipt to delivery. The system connects Google Forms, Google Sheets, Telegram, and Trello into a single entity.
Implemented functionality:
Omnichannel Intake - orders enter the system in two ways: automatically through Google Forms or through manual creation directly in the Telegram bot interface (step-by-step questionnaire).

Telegram Bot (Admin Panel):
- Instant notifications about new orders.
- One-click status management.
- Financial analytics: automatic calculation of income for the week/month and determination.

Trello Automation (Public Queue):
- Automatic creation of cards in Trello upon order receipt.
- The bot automatically changes color labels in Trello to indicate the order status.
- Auto-moving cards to the "Done" list upon order completion through the bot.
- All data is synchronized and stored in Google Sheets for security and reporting.

Technologies: Google Apps Script, Telegram Bot API, Trello REST API, JSON, Webhooks.