Send Scheduled Google Sheets Data via Gmail with Drive Storage
Workflow Description
This automation runs on a set schedule to read data from Google Sheets, filter and batch-process records, send personalized emails through Gmail, and automatically archive files to Google Drive. Perfect for recurring data distribution tasks.
How it works
- 1.Trigger the workflow at the specified time using schedule-based activation
- 2.Retrieve all rows from the connected Google Sheets document
- 3.Apply filters and split data into batches for manageable processing
- 4.Send Gmail messages with processed data to specified recipients
- 5.Store attachments and generated files in Google Drive folders
Use cases
- Send weekly or monthly reports from spreadsheet data directly to stakeholders
- Distribute task lists to team members via email with automatic record-keeping
- Alert selected contacts when spreadsheet values meet specific conditions
- Create and archive backup files of processed data in Drive automatically
Requirements
- Google Workspace account with full permissions on Sheets, Gmail, and Drive
- Pre-existing Google Sheets document containing source data
- Valid email addresses either in the spreadsheet or pre-configured in workflow
- Designated Google Drive folder for storing output files and archives
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 (19)
Has Shared with External Users
Filter
Create New Sheet
Google Sheets
Normalise Fields
Set
For Each File
Split In Batches
File Ref
No Op
Permissions To Items
Split Out
Aggregate
Aggregate
Flatten Rows
Set
Rows to Items
Split Out
Send Email Report (Execute Once)
Gmail
Get Recently Active Documents
Google Drive
Sticky Note
Sticky Note
Schedule Trigger
Schedule Trigger
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Filter Out Owner of Document
Filter
Append to New Sheet
Google Sheets
Sticky Note4
Sticky Note