Automate Email Routing with OpenAI & n8n: Slack, Gmail, Sheets

Streamline Your Email Management with OpenAI & n8n: Seamless Routing to Slack, Gmail, and Google Sheets

Enhance your email processing efficiency with our powerful n8n workflow that automatically categorizes your emails using OpenAI, routing them to Slack, Google Sheets, Google Drive, or Gmail. Experience reduced manual overhead by letting this dynamic workflow handle your emails based on urgency and relevance.

What this workflow does

• Polls your IMAP inbox every minute to detect new emails.
• Utilizes OpenAI GPT-4o-mini to analyze the subject and body of emails, providing a JSON classification with category, confidence, and reasoning.
• Directs low-confidence email classifications to a Slack #triage-review channel for human oversight.
• Routes emails categorized with high confidence into critical paths like urgent, invoice, or routine.
• Posts urgent emails in the Slack #ops-alerts channel, including sender details and a brief reasoning for urgency.
• Securely uploads invoice attachments to Google Drive and logs email data into a dedicated Invoices sheet in Google Sheets.
• Applies a specific Gmail label to routine emails while maintaining a detailed record of all actions in a Google Sheets DecisionLog.

Use cases

• Operations Managers: Instantly receive critical email alerts via Slack, ensuring that urgent issues are promptly addressed.
• Finance Teams: Streamline invoice handling with automated data logging in Google Sheets, reducing processing time and human error.
• SaaS Operators: Maintain a comprehensive audit log of email activity, useful for both accountability and performance evaluation.

Technical details

• Email Processing: IMAP Inbox Polling
• AI Classification: OpenAI GPT-4o-mini Integration
• Messaging & Alerts: Slack (with #triage-review and #ops-alerts channels)
• Data Storage: Google Sheets and Google Drive
• Email Management: Gmail Labels

Take control of your email workflow with our expertly crafted automation. Whether you're managing a high-volume inbox or just need to sharpen your email routing, this n8n workflow brings powerful AI capabilities right to your fingertips.