Classify Property Support Emails with Groq, Slack & Airtable

Automatically classify property support emails with Groq, route them in Slack, and log everything to Airtable

This n8n workflow watches your IMAP inbox, uses Groq to classify each property support email and draft a suggested reply, then routes the ticket to the right Slack channel and records the request in Airtable (with a Google Sheets backup if Airtable fails).

What this workflow does

• Monitors new emails in your IMAP inbox and reads the subject and body.
• Cleans and truncates the email body to 500 characters to keep processing consistent.
• Sends the subject + cleaned body to Groq Chat Completions to return a JSON classification including: category, urgency, property reference, and a suggested reply.
• Parses and normalizes the AI output, falling back to a manual-review payload if the Groq response is missing or unparseable.
• Routes tickets by category to the appropriate Slack channel (Maintenance, Tenant Query, Viewing, Enquiry, or Manual Review). Spam is only logged.
• For non-spam tickets, creates a Gmail draft reply to the original sender using the suggested reply text.
• Saves the ticket to Airtable and emails a processing confirmation.
• If Airtable writing fails, appends the ticket to a Google Sheets backup and sends an alert.

Use cases

• Tenant support triage: auto-route maintenance and tenant queries to the right team in Slack.
• Viewing requests: classify enquiries and share structured details with viewing coordinators.
• Operational reliability: keep a fallback log in Google Sheets when Airtable is unavailable.
• Manual escalation: automatically mark unparseable/uncertain emails for human review.

Technical details

• IMAP Email Read trigger for incoming messages
• Groq (Chat Completions) for JSON classification and suggested replies
• Code and Switch logic to parse, normalize, and route
• Slack posting to category-based channel IDs
• Gmail to create draft replies
• Airtable ticket logging with Google Sheets backup
• Includes workflow notes via Sticky Note