OpenAI and Trello integration

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

AI Sales Analyst & Lead Router This n8n template handles the post-call process for your business. It uses the call recording to extract valuable data and handles the prospect based on their budget. Some use cases: Sales follow-ups, auto-qualifying leads based on budget, monetizing low-budget leads, and automatic data entry. How it works Ingestion: When a call recording is uploaded to a specific Google Drive folder, the workflow is triggered. Transcription: OpenAI's model transcribes the call recording. Analysis: The GPT-4o model analyzes the transcript and extracts crucial information. Lead classification: The extracted budget is checked against your defined threshold (e.g., $5,000). Hot leads (Budget > 5k): The workflow logs the data in Airtable (CRM), creates a high-priority task, and instantly alerts the team via a Slack channel. Warm leads (Budget < 5k): The workflow logs the data, creates a low-priority task, and emails the lead, offering a cheaper alternative. Logging: Every execution is logged in Airtable. How to use the workflow Configure Google Drive: Open the Trigger node and select the destination folder for the call recordings. Set your Threshold: Open the If node and set your desired budget (currently set to 5,000). Customize the email: Open the Gmail node in Phase 2B and modify the email according to your own preferences. Database mapping: Ensure that your Airtable base has the following columns: Client Name, Budget, Sentiment, Summary, Date, and Timeline. Test it out! Generate a sample audio file on ElevenLabs and upload it to your Google Drive folder. Requirements Google Drive** (For storing audio recordings) OpenAI API Key** (Access to OpenAI models) Airtable** (For CRM and System Logging) Trello** (For Task Management) Slack** (For Team Notifications) Gmail** (For sending automated emails)

How It Works ⚙️ This workflow is a comprehensive, AI-powered system that acts as a virtual support manager. It automates the entire process of handling incoming support tickets, ensuring speed, accuracy, and efficiency. Ticket Ingestion: The workflow starts when a new email arrives in your support inbox via the Gmail Trigger. AI Analysis & Triage: An OpenAI node acts as an intelligent agent, instantly analyzing the email to categorize the issue, assign a priority, and determine the customer's sentiment (e.g., "Angry," "Neutral"). Proactive Escalation: The workflow uses an If node to check for "Critical" priority or "Angry" sentiment. If these conditions are met, it takes a separate path to notify a manager immediately. Ticket Creation: Regardless of urgency, a Trello card is created for the ticket, including all the AI's analysis and the original email content. Automated Response: For low-priority tickets, a second If node and a Gmail node can send an automated, AI-generated response, completely freeing up your team. Performance Reporting: All ticket data, including the AI's analysis, is logged to a Google Sheets dashboard for real-time analytics and to track support trends. How to Set Up 🛠️ Import the Workflow: Copy the provided workflow JSON and import it into your n8n instance. Configure Credentials: Gmail: Add your OAuth2 credential for your support inbox. OpenAI: Add your API Key. Trello: Add your API Key and token. Slack: Add your Bot Token credential. Google Sheets: Add your OAuth2 credential. Customize Workflow Nodes: Node 1 (Gmail Trigger): Ensure this is connected to your official support email address. Node 2 (OpenAI): The prompt is pre-configured but can be customized to better fit your specific categories or tone. Node 4 (Trello): Replace [YOUR TRELLO BOARD LIST ID] with the list ID for new tickets on your board. Node 5 (Slack): Replace [MANAGER'S SLACK USER ID] and [YOUR SUPPORT TEAM SLACK CHANNEL ID] with the correct IDs. Node 9 (Google Sheets): Replace [YOUR SUPPORT DASHBOARD SPREADSHEET ID] with your spreadsheet ID and ensure your sheet columns match the workflow's data. Save & Activate: Once all settings and credentials are configured, save the workflow and click the "Inactive" toggle in the top-right corner to make it live.

⚙️ How It Works This workflow is a comprehensive, AI-powered system that transforms customer feedback into strategic business intelligence. It operates in a multi-stage process to ensure every review or mention is handled proactively and intelligently. 🔊 Multi-Channel Listening Triggers monitor platforms like Shopify, Twitter, and more for new reviews or mentions. 🧠 AI-Powered Analysis When feedback is detected, it's sent to an OpenAI node. The AI performs: Sentiment analysis: Positive, Negative, or Neutral Scoring & categorization (e.g., Shipping, Product Quality) Urgency assessment to prioritize response 🔀 Smart Conditional Logic An If node evaluates sentiment and urgency The workflow branches into customized response paths 🚨 Automated Escalation Negative or high-urgency feedback triggers: Slack alerts to the appropriate team channel Trello or Asana tasks for rapid issue resolution 📊 Centralized Logging All feedback + AI analysis is logged in Google Sheets Enables long-term trend analysis and strategic decision-making 💬 Proactive Engagement Positive reviews trigger a "Thank You" email Strengthens customer loyalty and boosts brand trust 🛠️ How to Set Up 1️⃣ Import the Workflow Copy and paste the workflow JSON into your n8n instance 2️⃣ Configure Credentials Set up access for: OpenAI**: Add your API Key Shopify**: Add your store's API credentials Slack**: Add Bot Token & Channel ID Trello**: Add API Key, Token, Board ID & List ID Google Sheets**: Add OAuth2 credentials 3️⃣ Customize Triggers Start with the Shopify Trigger node Add additional sources (e.g., Twitter, Webhook) and connect to the AI Analysis Node 4️⃣ Adjust AI Prompt In Node 2 (AI Analysis), update the prompt for: Custom business categories Specific analysis instructions 5️⃣ Update Conditional Logic In Node 4 (If Is Negative): Add conditions like urgency == "High" for critical issues 6️⃣ Replace Placeholders Replace all placeholder values: YOUR_SLACK_CHANNEL_ID YOUR_TRELLO_BOARD_ID YOUR_SPREADSHEET_ID ...with your actual credentials 7️⃣ Save & Activate ✅ Save your workflow 🔁 Click the Inactive toggle in the top-right corner to activate