Developer & DevOps
Send scheduled SMS alerts from Google Sheets data
8 nodes
191
121
Scheduled trigger
Workflow Description
Automation triggered on a defined schedule that retrieves data from Google Sheets, evaluates conditions and logic, processes the retrieved values, and sends SMS messages via Twilio to specified recipients based on configured criteria.
How it works
- 1.Trigger automation on schedule using Cron at set intervals
- 2.Fetch data rows from connected Google Sheets
- 3.Evaluate conditional logic and data filtering rules
- 4.Merge and format message content from sheet data
- 5.Send SMS notification via Twilio to target phone numbers
Use cases
- Daily alerts on financial or operational KPIs stored in spreadsheets
- Recurring reminders for tasks or scheduled events from your sheet
- Notifications when sensitive data meets specific threshold conditions
Requirements
- Active Twilio account with verified sender phone number
- Google Sheets document containing data and recipient phone numbers
- API permissions enabled for both Sheets read and Twilio send operations
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Schedule
Google Sheets
Twilio
Details
Trigger
Scheduled trigger
Nodes
8
Apps
3
Views
191
Downloads
121
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 (8)
Daily Trigger
Cron
Congratulations Calendar
Google Sheets
Any Event Today?
If
Do Nothing
No Op
Congratulations Messages
Google Sheets
Merge Data
Merge
Personalize Message
Function
Send SMS
Set