Distribute spreadsheet data via email and messaging platforms
Workflow Description
A scheduled automation that reads data from Google Sheets and routes it automatically across Gmail, Telegram, and Ntfy, enabling your team to receive critical information instantly without manual intervention or delays.
How it works
- 1.Trigger automation at scheduled intervals using time-based conditions
- 2.Extract relevant data from designated Google Sheets and worksheet tabs
- 3.Filter data through conditional logic to verify content and quality
- 4.Send formatted messages to email recipients via Gmail
- 5.Deliver real-time alerts to Telegram groups and Ntfy channels simultaneously
Use cases
- Daily distribution of sales reports and analytics to the entire team
- Immediate notification when critical data changes occur in your spreadsheet
- Automated task list and schedule delivery to operational Telegram groups
Requirements
- Active Google Sheets account with read access permissions to required sheets
- Gmail and Telegram accounts configured to receive and send messages
- n8n platform connected and authenticated to all services
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 (21)
URLs to Monitor
Google Sheets
Weekly Trigger
Schedule Trigger
Fetch URLs
Google Sheets
Check SSL
HTTP Request
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Switch
Switch
Send Alert Email2
Gmail
Send Alert Email4
Gmail
Send Alert Email6
Gmail
Ntfy4
Ntfy
Sticky Note10
Sticky Note
Sticky Note11
Sticky Note
Sticky Note8
Sticky Note
Send Alert Email1
Gmail
Sticky Note
Sticky Note
Telegram
Set
Sticky Note7
Sticky Note
Sticky Note6
Sticky Note