Extract Drive files, summarize with AI, and email summaries automatically
Workflow Description
An intelligent workflow that monitors Google Drive for document changes, uses OpenAI to extract and analyze content, generates concise summaries through LLM processing, and automatically distributes them via Gmail without manual intervention.
How it works
- 1.Monitor Google Drive folders for new or modified files
- 2.Extract text content from files and prepare it for AI processing
- 3.Generate intelligent summaries using OpenAI and LLM Chain
- 4.Compose personalized email messages with the summaries
- 5.Send emails to designated recipients via Gmail
Use cases
- Automatically summarize reports and distribute them to team members
- Monitor client proposals in Drive and email summaries to management
- Process invoices and contracts, extract key data, and route to stakeholders
Requirements
- Google account with access permissions to Drive and Gmail
- OpenAI API key for language model operations
- Configuration of target folders, file types, and recipient email addresses
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 (22)
List Files
Google Drive
OpenAI Chat Model
OpenAI
is XLSX
If
Get File
Google Drive
Merge XLSX and CSV
Merge
Format Data
Code
Set fileName
Set
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Preserve File Name
Set
Email Optimizations
Gmail
Extract XLSX Data
Extract From File
Extract CSV Data
Extract From File
Preserve CSV File Name
Set
When clicking ‘Test workflow’
Manual Trigger
Sticky Note
Sticky Note
Email Options
Set
Sticky Note1
Sticky Note
AI Analyze
LLM Chain