Back to Templates

API Uptime Monitoring with WhatsApp Alerts & Google Sheets Management

Last update

Last update 2 days ago

Categories

Share


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