Web Automation
Schedule Google Sheets data processing and email reporting
16 nodes
271
96
Scheduled trigger
Workflow Description
Automate periodic data extraction from Google Sheets, process it in controlled batches, and send formatted email reports on a predefined schedule. The workflow handles large datasets efficiently without manual intervention.
How it works
- 1.Trigger automation at scheduled times using the scheduler
- 2.Extract data from the target Google Sheets document
- 3.Split data into batches for controlled processing
- 4.Apply conditional logic to filter or validate data
- 5.Compile results and format report content
- 6.Send completed report to recipients via email
Use cases
- Send weekly sales performance summaries to management automatically
- Monitor customer list updates and notify teams of changes
- Generate analytics digests from large spreadsheet datasets
Requirements
- Active Google Workspace account with sheet edit permissions
- Configured email service with valid authentication credentials
- Google Sheets containing data to be processed and reported
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Google Sheets
Split In Batches
Email Send
Details
Trigger
Scheduled trigger
Nodes
16
Apps
3
Views
271
Downloads
96
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 (16)
/
Products to Monitor
Google Sheets
Loop Over Items
Split In Batches
Scrapeops - Amazon Product
HTTP Request
Fields
Set
Last Price
Set
Price Change
Set
Alert Status
Set
Insert - Price History
Google Sheets
Update - Products to Monitor
Google Sheets
Send Email
Email Send
Check Valid Price
If
Alert Decision
If
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Setup
Set
Schedule Trigger
Schedule Trigger