Classify Gmail leads with Groq AI and sync SLA cases to Supabase via Redis

Description

Who’s it for

This workflow is for contractors, freelancers, local service businesses, and small teams that receive leads and customer requests through Gmail but do not have a dedicated sales or admin team.

What it does

This template turns Gmail into an AI lead desk and follow-up tracker. It filters inbox noise, reads real customer emails, and classifies each message by urgency, intent, sentiment, department, technical details, and business value.

Each email gets a color-coded response deadline:

RED: critical issue, respond within 1 hour
ORANGE: urgent lead or follow-up, respond within 4 hours
YELLOW: standard lead or request, respond within 24 hours
GREEN: low-priority message, respond within 48 hours

The first workflow watches Gmail, retrieves and cleans the email, classifies it with AI, and publishes the structured case to Redis. The second workflow listens for Redis events and logs each case to Supabase/PostgreSQL as a lightweight CRM and follow-up dashboard.

Requirements

Gmail OAuth2 credentials
Groq API credentials
Redis credentials
Supabase/PostgreSQL credentials
Optional Mem0 API credentials

How to customize

Update the blocked Gmail labels, AI prompt, response deadlines, Redis channel, Supabase schema, owner alert logic, and dashboard views to match your business process.