Triage customer complaint emails from Gmail with GPT-4o-mini, Slack and Sheets

Description

Activate this workflow once and it monitors your Gmail inbox every minute automatically. Every incoming email is scanned for complaint keywords — and if a complaint is detected, GPT-4o-mini scores its urgency, identifies the right department, writes a one-line summary, and drafts a ready-to-send reply. The complaint is logged to Google Sheets and a formatted alert is posted to the correct Slack channel instantly. Built for support teams, customer success managers, and small businesses who can't afford to miss or delay a complaint.

---

What This Workflow Does

- Automatic inbox monitoring — Checks your Gmail every minute so no complaint sits unread while your team is busy with other work - Keyword-based complaint detection — Scans subject lines and email bodies for 12 complaint signals and silently ignores everything else - AI urgency scoring — Rates every complaint from 1 to 10 so your team knows at a glance what needs attention first - Department routing — Classifies each complaint as Billing, Technical, or General and sends the alert to the right Slack channel automatically - Reply draft generation — GPT-4o-mini writes a professional, empathetic reply your agent can send immediately — no drafting from scratch - Permanent complaint log — Appends a 12-column record to Google Sheets for every complaint, giving you a searchable history for reporting and pattern analysis - Clean non-complaint exit — Emails that are not complaints pass through silently without triggering any logging or alerts

---

Setup Requirements

Tools Needed - n8n instance (self-hosted or cloud) - Gmail account (the inbox you want monitored) - OpenAI account with GPT-4o-mini API access - Slack workspace with OAuth2 app configured - Google Sheets (one sheet with a tab named Complaint Log)