API Uptime Monitoring with WhatsApp Alerts & Google Sheets Management

This automated n8n workflow monitors API uptime by periodically checking API availability and sending instant WhatsApp alerts if any service goes down. It retrieves API details from a Google Sheet and includes retry logic for failed requests.

Good to Know

• Checks API status every 15 minutes
• Integrates with Google Sheets for API list management
• Implements a retry mechanism with up to 4 attempts
• Sends WhatsApp alerts for downtime
• Supports customizable API request configurations

How It Works

• Schedule Trigger - Triggers every 15 minutes
• Read API List - Fetches all API URLs from a Google Sheet
• Process Each API1 - Loops through each API entry
• Init Retry Counter - Initializes retryCount = 0
• Test API - Sends the first request to the API
• Check Response - Checks if a valid response was received
• If No Response - Branches into retry flow if down
• Wait 10 Min → Increment Retry → Retry API → Check Retry Response - Wait and retry API call once
• If Still No Response - Verifies if retry also failed
• If Still No Retry > 4 - Checks if retry limit is reached (≥ 4)
• Format Down Alert - Formats the WhatsApp alert with API details
• Send WhatsApp Alert - Sends API down alert to the configured number
• Continue Next API - Moves to the next API in the list

How to Use

• Import workflow into n8n
• Configure Google Sheets API for API list access
• Set up WhatsApp API for alerts
• Define API details in Google Sheet
• Test with sample APIs and verify alerts
• Adjust retry limits or schedule as needed

Requirements

• Access to Google Sheets API
• WhatsApp API configuration
• Scheduled trigger setup in n8n

Sheet Structure

Sheet Column

Example Data

name

Timeout Test

method

GET

url

https://httpbin.org/delay/15

headers

{"Content-Type": "application/json"}

body

{"key": "value"}

expectedField

status

expectedValue

success

expectedStatusCode

200

Customizing This Workflow

• Modify trigger interval
• Adjust retry limits or wait times
• Customize WhatsApp alert format
• Add additional API headers or body data
• Integrate with other notification services