Extract email tasks with Gmail, ChatGPT-4o and Supabase
n8n8 modulesv1.0Gmail → GPT → Supabase | Task Extractor This n8n workflow automates the extraction of actionable tasks from unread Gmail messages using OpenAI's GPT API, stores the resulting task metadata in Supabase, and avoids re-processing previously handled emails. --- ✅ What It Does 1. Triggers on a schedule to check for unread emails in your Gmail inbox. 2. Loops through each email individually using SplitInBatches. 3. Checks Supabase to see if the email has already been processed. 4. If it's a new email:
At a glance
Extract email tasks with Gmail, ChatGPT-4o and Supabase is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects code, gmail, httpRequest, if. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- code, gmail, httpRequest, if, openAi, scheduleTrigger
- Modules
- 8
- Price
- Free
- Version
- v1.0
About this workflow
Gmail → GPT → Supabase | Task Extractor This n8n workflow automates the extraction of actionable tasks from unread Gmail messages using OpenAI's GPT API, stores the resulting task metadata in Supabase, and avoids re-processing previously handled emails. --- ✅ What It Does 1. Triggers on a schedule to check for unread emails in your Gmail inbox. 2. Loops through each email individually using SplitInBatches. 3. Checks Supabase to see if the email has already been processed. 4. If it's a new email: - Formats the email content into a structured GPT prompt - Calls ChatGPT-4o to extract structured task data - Inserts the result into your emails table in Supabase --- 🧰 Prerequisites Before using this workflow, you must have: - An active n8n Cloud or self-hosted instance - A connected Gmail account with OAuth credentials in n8n - A Supabase project with an emails table and: - An OpenAI API key with access to GPT-4o or GPT-3.5-turbo --- 🔐 Required Credentials | Name | Type | Description | |-----------------|------------|-----------------------------------| | Gmail OAuth | Gmail | To pull unread messages | | OpenAI API Key | OpenAI | To generate task summaries | | Supabase API | HTTP | For inserting rows via REST API | --- 🔁 Environment Variables or Replacements - SupabaseTaskManagementURI → e.g., - SupabaseTaskManagementANONKEY → Your Supabase anon key These are used in the HTTP request to Supabase. --- ⏰ Scheduling / Trigger - Triggered using a Schedule node - Default: every X minutes (adjust to your preference) - Uses a Gmail API filter: unread emails with label = INBOX --- 🧠 Intended Use Case > Designed for productivity-minded professionals who want to extract, summarize, and store actionable tasks from incoming email — without processing the same email twice or wasting GPT API credits. This is part of a larger system integrating GPT, calendar scheduling, and optional task platforms (like ClickUp). --- 📦 Output (Stored in Supabase) Each processed email includes: - emailid - subject - sender - receivedat - body (email snippet) - gptsummary (structured task) - requiresdeepwork (from GPT logic) - deleted (initially false)
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Generate AI viral videos with Seedance and upload to TikTok, YouTube & Instagram
Process customer feedback with OpenAI, PDF reports, Gmail & Slack notifications
Convert meeting recordings to notes & action items with AssemblyAI, GPT-4 & Sheets
Notion AI summary & tags
Automate multi-step onboarding with Google Sheets, Forms and Gmail notifications
E-commerce product fine-tuning with Bright Data and OpenAI
Generate complete business plans with customizable AI models and specialized agents
Customer feedback analysis with AI, QuickChart & HTML report generator
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you