Connect Google Drive with Gmail
Workflow Description
Automation that monitors a Google Drive folder, extracts file content, analyzes it with OpenAI's AI model, and sends intelligent summaries via Gmail automatically.
How it works
- 1.Monitor a specified Google Drive folder for new file uploads
- 2.Extract text and data from detected files using extraction nodes
- 3.Process content through LLM Chain for intelligent analysis and insights
- 4.Generate customized summaries or messages based on analyzed data
- 5.Send results automatically to designated recipients via Gmail
Use cases
- Process reports and documents to automatically send smart summaries to your team
- Analyze important documents and distribute actionable insights via email
Requirements
- Active Google Drive connection with proper folder access permissions
- Valid OpenAI API key and activated Gmail account
- Clearly defined monitored folder and target 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