AI Email Reminders Workflow: Supabase + Gmail + n8n

Never miss an important date—AI-generated email reminders from Supabase to Gmail, fully automated in n8n

This n8n automation workflow sends AI-written reminder emails for upcoming events and “important days” stored in Supabase. It runs on schedules and via a webhook, generates reminder content using Mistral Cloud, delivers notifications through Gmail, and logs results back into Supabase.

What this workflow does

• Scheduled event reminders (daily): Retrieves event records from Supabase, filters to upcoming, non-low-priority events, then keeps only those occurring within the next 0–7 days.
• AI reminder generation: Uses a Mistral Cloud AI Agent to produce a concise email subject and body for each due event.
• Send + audit trail: Sends the reminder via Gmail and records the sent notification in the Supabase notifications table.
• Scheduled “important days” reminders (daily): Pulls “important days” from Supabase, calculates the next occurrence date, and checks whether it matches the configured “notify days before” value.
• Duplicate prevention: Prevents duplicate important-day notifications by checking Supabase before sending.
• Webhook-powered content generation: Accepts a POST webhook with platform/topic/audience inputs, generates structured long-form content ideas as JSON via Mistral Cloud, stores them in Supabase (ai_generated_content), and returns the JSON in the response.

Use cases

• Send proactive reminder emails for team or customer events stored in Supabase.
• Automate “important days” outreach (birthdays, renewals, internal milestones) with configurable lead times.
• Generate and store content ideas on demand via webhook for SaaS operators and automation engineers building content workflows.

Technical details

• Integrations: Supabase (tables: events, important_days, notifications, ai_generated_content) and Gmail (OAuth2 + recipient email addresses).
• n8n logic / nodes: if, set, code, gmail, merge, filter.
• AI: Mistral Cloud via an AI Agent for email subject/body and webhook content JSON.