Automate Procurement Tickets: Gmail to Slack with Groq

Streamline Your Procurement Process: Automate Ticket Management from Gmail to Slack with Groq

Revolutionize your procurement management with this n8n workflow designed to seamlessly monitor Gmail for procurement requests and efficiently manage them through integration with Slack and Groq's AI capabilities. This powerful automation ensures high-risk items are escalated promptly while providing a structured approach to ticket handling and SLA compliance.

What this workflow does

• Activates every minute upon the arrival of a new email in a specified Gmail inbox.
• Extracts key data: sender details, email subject and body, timestamps, and Gmail thread/message IDs, also generating a unique procurement ticket ID.
• Searches the Google Sheets database to check for existing threads, avoiding duplicate ticket creation.
• Utilizes Groq (Llama 3.1) to classify and prioritize requests based on category, urgency, sentiment, risk, and team assignment, establishing a clear routing and SLA strategy.
• For high-priority issues, creates an escalated ticket and sends a detailed alert to a specified Slack channel through an HTTP request; standard requests are handled similarly, but without escalation.
• Produces a concise, agent-focused status update with Groq and communicates an automated acknowledgment and suggested customer reply via Gmail.
• Logs each ticket along with AI-generated insights into Google Sheets, ensuring complete and accessible record-keeping.

Use cases

• Automation engineers seeking to streamline procurement workflows for enhanced operational efficiency.
• SaaS operators aiming to maintain rigorous SLA compliance with proactive escalation and management of procurement tickets.
• Organizations leveraging Gmail and Slack for communication and needing an integrated system to manage and track procurement requests efficiently.

Technical details

• Tech Stack/Nodes:
  • Gmail: Triggers and auto-reply setup using Gmail OAuth2 credentials.
  • Groq: Request classification and ticket generation with Groq API (Llama 3.1).
  • Google Sheets: Thread lookup and ticket logging via Google Sheets OAuth2.
  • Slack: Escalation alerts with Slack channel notifications.
  • n8n Automation Nodes: if, set, code, gmail, slack, sticky note.