Trello and Telegram integration

Telegram Tasker Bot — это сценарий n8n, который принимает голосовые сообщения в Telegram, автоматически превращает их в текст, извлекает из него ключевые поля задачи и создаёт карточку в нужной доске Trello. Пользователь просто говорит задачу — бот сам оформляет её и присылает ссылку на готовую карточку. Для использования вам потребуется telegram bot. Его можно создать через бота BotFather Так же понадобится доступ к API chatgpt - он используется только для транскрибции аудио в речь. Вы можете использовать любой другой сервис, по вашему выбору. И аккаунт в trello, с доступом к API. !Внимание! ID доски в trello можно взять из url ID столбца на доске трелло можно взять через инструменты разработчика (по крайней мере я так получал эти данные)

Trello Task-Sync Assistant Description This n8n workflow automates task management by integrating Trello, Supabase, and Telegram to streamline card creation, user assignment, and due date notifications. It ensures seamless synchronization of Trello card data with a Supabase database and sends timely Telegram notifications to keep team members informed about task assignments and deadlines. Key Features Trello Card Syncing**: Automatically registers new Trello cards in Supabase and keeps card details (e.g., due dates, URLs) updated. User Management**: Tracks Trello user assignments in Supabase, creating new user entries and linking them to cards as needed. Real-Time Notifications**: Sends Telegram messages when users are added to or removed from Trello cards, using dynamic, engaging message templates. Due Date Reminders**: Schedules daily checks to notify users via Telegram about tasks due on the current day. Workflow Structure Trello Trigger Flow: Trigger: Activates when a new Trello card is created. Actions: Registers the card in Supabase (cards table) with details like ID, name, and board. Sets up a Trello webhook for real-time updates on the card. Syncs due date changes to Supabase. Detects member additions/removals, checks for existing users in Supabase, creates new user entries if needed, and links users to cards in the card_user table. Webhook Event Flow: Trigger: Processes Trello webhook events (e.g., member changes, due date updates). Actions: Validates event types (add/remove member). Maps Trello usernames to Telegram handles. Sends formatted Telegram notifications with card details and playful, randomized messages for engagement. Due-Date Notification Flow: Trigger: Runs twice daily (every 12 hours) via a scheduled trigger. Actions: Fetches cards due on the current day from Supabase. Retrieves assigned users for each card. Sends Telegram reminders with urgent, formatted messages including card name, board, URL, and due date. Technical Details Tools Used**: Trello: Triggers on card creation and updates via webhooks. Supabase: Stores card, user, and card-user relationship data in cards, users, and card_user tables. Telegram: Sends notifications using a bot. Credentials Required**: Trello API key and token. Supabase URL and key. Telegram bot token and chat ID. Scheduling**: Due date checks run every 12 hours (adjustable). Error Handling**: Includes checks for user existence and conditional logic to manage add/remove events. Use Case Ideal for teams using Trello for project management, this workflow ensures real-time data syncing with Supabase and keeps members informed via Telegram, reducing manual oversight and improving task accountability. It’s particularly useful for remote or distributed teams needing automated task tracking and reminders. Setup Requirements Configure Trello webhooks to point to the n8n webhook URL. Set up Supabase with the required tables (cards, users, card_user). Provide Telegram bot token and chat IDs Test the workflow by creating a Trello card, assigning a member, and setting a due date to verify Supabase entries and Telegram notifications. This workflow enhances productivity by automating task synchronization and communication, ensuring no deadline is missed.

Daily Sales Metrics Auto-Insight with Gemini, Google Sheets, Calendar, Telegram, Trello and Gmail Who’s it for This workflow is ideal for sales managers, operations teams, and business owners who need daily automated sales summaries and team notifications. It eliminates the hassle of manually gathering, analyzing, and reporting daily sales data, providing instant insights and proactive notifications to keep your team aligned. How it works / What it does This advanced workflow automates the entire daily sales reporting pipeline with actionable team alerts: Webhook captures new sales entries in real-time. The data is logged into Google Sheets. It retrieves all rows to compile current sales metrics. A custom node concatenates the data into an AI-friendly format. The Google Gemini Chat Model generates concise sales insights. HTML tags are cleaned up with a Remove HTML Tags node. The insights are classified (Good, Bad, Very Bad) using AI. Based on the classification: -- Teams are alerted via Telegram group messages. -- For negative insights, a Trello card backlog is created for follow-up. -- A Google Calendar meeting is scheduled automatically to discuss issues. An email summary is also sent out via Gmail to ensure no update is missed How to set up Import the workflow into your n8n instance. Configure the Webhook URL in your data source (POS, CRM, etc.). Connect Google Sheets, Google Gemini API, Trello, Telegram, and Google Calendar. Adjust classification logic inside the Classify Insight node if needed. Customize the message templates for email and Telegram. Test the workflow with sample data to validate automation flow. Requirements n8n account with active workflows. Google Sheets API credentials. Google Gemini API access. Telegram Bot Token & Group ID. Trello API Key & Token. Google Calendar API setup. Gmail or SMTP credentials for email notifications. How to customize the workflow Adjust the Concat Sales Data node if you want to include more fields or different data formats. Modify the Gemini prompt for personalized insight summaries. Change the classification thresholds (Good, Bad, Very Bad) based on your business KPIs. Update the notification messages in Telegram and Email nodes. Add or remove post-classification actions, like creating different task cards or sending escalations to other platforms (Slack, Microsoft Teams, etc.). Automate daily sales insights from Google Sheets using Gemini AI, classify results, and notify your team via email, Telegram, Trello, and Google Calendar instantly. Email Preview