{"product_id":"ai-email-reminders-workflow-supabase-gmail-n8n","title":"AI Email Reminders Workflow: Supabase + Gmail + n8n","description":"\u003ch3\u003eNever miss an important date—AI-generated email reminders from Supabase to Gmail, fully automated in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow sends AI-written reminder emails for upcoming events and “important days” stored in \u003cstrong\u003eSupabase\u003c\/strong\u003e. It runs on schedules and via a \u003cstrong\u003ewebhook\u003c\/strong\u003e, generates reminder content using \u003cstrong\u003eMistral Cloud\u003c\/strong\u003e, delivers notifications through \u003cstrong\u003eGmail\u003c\/strong\u003e, and logs results back into Supabase.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled event reminders (daily):\u003c\/strong\u003e Retrieves event records from Supabase, filters to upcoming, non-low-priority events, then keeps only those occurring within the next \u003cstrong\u003e0–7 days\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI reminder generation:\u003c\/strong\u003e Uses a \u003cstrong\u003eMistral Cloud\u003c\/strong\u003e AI Agent to produce a concise email subject and body for each due event.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSend + audit trail:\u003c\/strong\u003e Sends the reminder via \u003cstrong\u003eGmail\u003c\/strong\u003e and records the sent notification in the Supabase \u003cstrong\u003enotifications\u003c\/strong\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled “important days” reminders (daily):\u003c\/strong\u003e Pulls “important days” from Supabase, calculates the next occurrence date, and checks whether it matches the configured \u003cstrong\u003e“notify days before”\u003c\/strong\u003e value.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDuplicate prevention:\u003c\/strong\u003e Prevents duplicate important-day notifications by checking Supabase before sending.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook-powered content generation:\u003c\/strong\u003e Accepts a POST webhook with \u003cstrong\u003eplatform\/topic\/audience\u003c\/strong\u003e inputs, generates structured long-form content ideas as JSON via \u003cstrong\u003eMistral Cloud\u003c\/strong\u003e, stores them in Supabase (\u003cstrong\u003eai_generated_content\u003c\/strong\u003e), and returns the JSON in the response.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend proactive reminder emails for team or customer events stored in Supabase.\u003c\/li\u003e\n  \u003cli\u003eAutomate “important days” outreach (birthdays, renewals, internal milestones) with configurable lead times.\u003c\/li\u003e\n  \u003cli\u003eGenerate and store content ideas on demand via webhook for SaaS operators and automation engineers building content workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Supabase (tables: \u003cem\u003eevents\u003c\/em\u003e, \u003cem\u003eimportant_days\u003c\/em\u003e, \u003cem\u003enotifications\u003c\/em\u003e, \u003cem\u003eai_generated_content\u003c\/em\u003e) and Gmail (OAuth2 + recipient email addresses).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n logic \/ nodes:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e Mistral Cloud via an AI Agent for email subject\/body and webhook content JSON.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850484441267,"sku":"N8N-18304","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BmykUVNUs3D-KZxgiTZ2_PU5zf8AZ.png?v=1786870954","url":"https:\/\/buyflowscripts.com\/products\/ai-email-reminders-workflow-supabase-gmail-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}