Automatically extract Google Drive files and send via Gmail notifications
Workflow Description
A scheduled workflow that periodically retrieves files from a specified Google Drive folder, processes them in batches with conditional logic, and automatically sends them through Gmail with optional notifications to Discord and Twitter/X channels.
How it works
- 1.Trigger automation on a defined schedule
- 2.Retrieve file list from Google Drive folder
- 3.Process files in batches and apply conditional rules
- 4.Send files and notifications via Gmail
- 5.Post alerts to Discord and Twitter/X channels
Use cases
- Distribute documented assets automatically to team members
- Monitor and share daily reports from a centralized folder
- Send invoices and contracts on a regular schedule
Requirements
- Google account with access permissions for Drive and Gmail
- Discord and Twitter/X accounts if channel notifications are needed
- n8n with scheduled triggers enabled
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 (29)
Schedule Trigger
Schedule Trigger
Get all n8n Workflows
N8N
Backup to Google Drive2
Google Drive
Loop Over Items
Split In Batches
Backup to Google Drive4
Google Drive
ifDriveEmpty
If
firstWorkflowJson
Set
JsonToFile
Code
CodeJsonToFile1
Code
Limit
Limit
Workflow Data
Execution Data
successEmail
Gmail
failureEmail
Gmail
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
getDriveFileData
Google Drive
When Executed by Another Workflow
Execute Workflow Trigger
Execute Workflow
Execute Workflow
Parameters
Set
Sticky Note3
Sticky Note
Sticky Note10
Sticky Note
Discord
Discord
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
Sticky Note
Sticky Note
Sticky Note11
Sticky Note
Sticky Note12
Sticky Note
Sticky Note13
Sticky Note
Sticky Note14
Sticky Note