Automated Email Support Triage with GPT-4, Gmail & Trello

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.

1. Ticket Ingestion: The workflow starts when a new email arrives in your support inbox via the Gmail Trigger.
2. 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").
3. 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.
4. Ticket Creation: Regardless of urgency, a Trello card is created for the ticket, including all the AI's analysis and the original email content.
5. 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.
6. 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 🛠️

1. Import the Workflow: Copy the provided workflow JSON and import it into your n8n instance.
2. 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.
3. 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.
4. 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.