Files & Documents
Schedule and Email Reports from Google Drive Automatically
10 nodes
112
93
Automatic trigger
Workflow Description
This automation retrieves files from Google Drive on a defined schedule and sends them via email to recipients with Slack notifications upon completion. Eliminates manual report distribution and ensures timely delivery of important documents.
How it works
- 1.Trigger the workflow at scheduled intervals based on cron expression
- 2.Fetch files and folders from specified Google Drive locations
- 3.Process and consolidate file data for email delivery
- 4.Send email containing files or Drive links to designated recipients
- 5.Post notification to Slack channel confirming successful execution
Use cases
- Automatically send weekly sales reports from Google Drive to team members every Monday morning
- Schedule periodic invoice and contract documents to be emailed to clients on a recurring basis
Requirements
- Connected Google account with access permissions for Google Drive and Gmail
- Active Slack workspace connection for notifications (optional)
- Pre-defined file locations in Google Drive and recipient email addresses
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Schedule
Google Drive
Gmail
Slack
Details
Trigger
Automatic trigger
Nodes
10
Apps
4
Views
112
Downloads
93
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 (10)
On clicking 'execute'
Manual Trigger
Current date
Function
Every 23:45
Cron
Get Year folder
Google Drive
Get Month folder
Google Drive
Orlen Invoice
Gmail
Upload Invoice to Google Drive
Google Drive
Mark as Read
Gmail
Merge
Merge
Slack
Slack