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