Telegram Bot + Google Sheets Automation System
Enterprise Resource Planning (ERP)
Built a full-stack business automation system:
• Telegram bot (Node.js + Telegraf) with a 4-step wizard for lead collection
• Real-time input validation (name, phone format, company, task)
• Google Sheets integration via service account API — auto-saves leads with status tracking
• Google Apps Script automation — triggers on new rows, generates styled PDF, sends email with attachment
• Manager receives dual notifications: Telegram message + email with PDF
• Dockerized deployment with docker-compose
Github: https://github.com/yura2787/automation_hub
Stack: Node.js, Telegraf v4, googleapis, Google Apps Script, Docker
• Telegram bot (Node.js + Telegraf) with a 4-step wizard for lead collection
• Real-time input validation (name, phone format, company, task)
• Google Sheets integration via service account API — auto-saves leads with status tracking
• Google Apps Script automation — triggers on new rows, generates styled PDF, sends email with attachment
• Manager receives dual notifications: Telegram message + email with PDF
• Dockerized deployment with docker-compose
Github: https://github.com/yura2787/automation_hub
Stack: Node.js, Telegraf v4, googleapis, Google Apps Script, Docker