Communication
Monitor Google Sheets and send Slack and Gmail alerts
15 nodes
117
71
Scheduled trigger
Workflow Description
Automatically checks Google Sheets on a scheduled basis for new data, then sends real-time notifications via Slack and Gmail to your team. Features batch processing and conditional filtering to ensure only relevant updates trigger alerts.
How it works
- 1.Check Google Sheets periodically for new or updated rows
- 2.Apply conditions and split data into manageable batches
- 3.Send notifications to Slack channel with formatted data
- 4.Distribute detailed summaries via Gmail to designated recipients
Use cases
- Alert team members instantly when new requests appear in shared tracking sheet
- Create an email audit trail of critical updates for compliance documentation
- Monitor project progress updates automatically across communication channels
Requirements
- Google Workspace account with edit permissions on source spreadsheet
- Slack workspace access with message posting permissions
- Active Gmail account configured for automated sending
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Google Sheets
Slack
Gmail
Split In Batches
Details
Trigger
Scheduled trigger
Nodes
15
Apps
4
Views
117
Downloads
71
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 (15)
/
Schedule Trigger
Schedule Trigger
Calculate Status
Set
Get Sites
Google Sheets
Send Chat Alert
Slack
Send Email Alert
Gmail
Log Uptime Event
Google Sheets
Update Site Status
Google Sheets
Perform Site Test
HTTP Request
For Each Site...
Split In Batches
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Status Router
Switch
Sticky Note6
Sticky Note
Sticky Note
Sticky Note