Software Development medium to set up

Server Uptime Monitor & Alert System

Pings servers from a Google Sheet every minute, logging status to Alive/Down sheets and emailing alerts on failure.

Verified 2026-07-07

Developer-EngineeringOps-IT

What it does

Get instant email alerts when your servers go down so you can fix issues immediately. The system pings every server listed in your Google Sheet each minute, logging active status to an 'Alive' sheet and recording failures with timestamps in a 'Down' sheet. You receive detailed notifications containing the specific server address whenever a failure occurs.

How it works

When it runs: On a schedule · Scheduled · every minute
How hands-off: Assists you, you do the final step
Setup: An afternoon · about an afternoon
Works with: Google Sheets, HTTP Request, Gmail

Tools that fit

Services

Google Sheets : Store server list and uptime logs

Gmail : Send downtime alerts

api

HTTP Request : Ping servers to check status

Watch out for

Google Apps Script has a six-minute execution limit, so batch your requests or process only a subset of servers per run to avoid timeout errors.
URLFetchApp does not follow redirects by default in all configurations, so explicitly handle HTTP status codes like 301 and 302 to ensure accurate uptime tracking.
Gmail quotas reset daily but are strict, so implement a cooldown mechanism to prevent sending more than fifty emails per day for the same alert type.
Sheet append operations can fail if the sheet is locked by another concurrent process, so add error handling with retry logic for write operations.

Seen in the wild

n8n: Monitor Server Uptime & Get Email Alerts with Google Sheets template

Want this running in your business?

This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.

Get in touch

Who it's for

Built for developers who want the busywork around code automated, not the code itself.

Ops-IT teams triaging their own internal requests get the same pattern, different queue.

Frequently asked questions

Who is this for?

developers and engineers and ops and IT teams, or anyone doing software development work who wants this handled automatically rather than manually.

How long does it take to set up?

An afternoon: plan for about an afternoon to get it running end to end.

Related use cases

← Back to directory