Extract Gmail messages and save data to Airtable automatically
Workflow Description
Intelligent automation that receives Gmail messages and analyzes them using an AI agent powered by OpenAI, then extracts key information and stores it organized in Airtable tables for review and analysis.
How it works
- 1.Receive new Gmail messages automatically upon arrival
- 2.Analyze message content using an AI agent powered by OpenAI
- 3.Extract structured data and save it in an Airtable table
Use cases
- Automatically organize and categorize important client emails
- Store sales inquiries and details in a unified database
- Track and archive administrative correspondence systematically
Requirements
- Active Gmail account with message access permissions
- Airtable account with a prepared database
- OpenAI API key for the intelligent agent
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (38)
OpenAI Chat Model
OpenAI
Calculator
Tool Calculator
Structured Output Parser
Output Parser Structured
Add Label "Processed"
Gmail
Active Routes Only
Filter
Extract Route ID
Set
Deactivate Route
Airtable
Add Label "Error"
Gmail
Send notification about deactivated route
Gmail
Send notification about missing route
Gmail
Get Route by ID
Airtable
Create Notion Page
HTTP Request
Gmail Trigger
Gmail
Filter for unprocessed mails
Filter
When clicking ‘Test workflow’
Manual Trigger
Required labels
Filter
Globals
Set
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
No Operation, do nothing
No Op
Sticky Note10
Sticky Note
Sticky Note11
Sticky Note
Sticky Note12
Sticky Note
Format Notion Page Blocks
Code
Get all labels
Gmail
Structured Output Parser1
Output Parser Structured
Calculator1
Tool Calculator
OpenAI Chat Model1
OpenAI
Generate Actionable Task
Agent
Get Summary & Meta Data
Agent