Automated Support Ticket Categorization and Reporting

This n8n workflow automates the entire process of handling support tickets submitted via a Google Form. It triggers when a new ticket is submitted, uses the Google Gemini AI model to classify and categorize the message, and stores the data in a Google Sheet. The workflow then fetches all support tickets, counts how many belong to each category, and sends a summarized report via email. This automation streamlines support management by providing real-time insights into ticket categories and sentiment, reducing manual effort, and ensuring prompt reporting. It’s ideal for customer support teams aiming to improve ticket tracking, categorization, and reporting.