Extract Gmail attachments, analyze content, and organize in spreadsheets
Workflow Description
Automates receipt of new Gmail messages with attachments, extracts files automatically, analyzes content using AI, organizes files in Google Drive, and logs structured data to Google Sheets for easy review and reporting.
How it works
- 1.Detect new Gmail messages with file attachments
- 2.Extract and upload files directly to Google Drive
- 3.Analyze document content using OpenAI models
- 4.Parse and structure extracted data fields
- 5.Insert organized records into Google Sheets
Use cases
- Processing invoices and receipts sent via email
- Organizing HR reports and personnel documents
- Categorizing contracts and financial agreements
- Extracting pricing data from PDF price lists
Requirements
- Active Gmail account with API access permissions
- Google Drive and Google Sheets accounts configured
- Valid OpenAI API key with appropriate credits
- Email filters set up to identify target messages
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 (17)
Sticky Note
Sticky Note
Gmail Trigger1
Gmail
Setup1
Set
Upload PDF to Drive1
HTTP Request
Rename file1
Google Drive
Move to the correct folder1
Google Drive
Gmail
Gmail
Extract from File2
Extract From File
Google Drive
Google Drive
OpenAI Model
OpenAI
Structured Output Parser
Output Parser Structured
Append to Reconciliation Sheet
Google Sheets
Sticky Note2
Sticky Note
Map Output
Set
Apply Data Extraction Rules
LLM Chain
Sticky Note6
Sticky Note
Only invoice mails with attachments
If