Monitor server uptime get email alerts with Google Sheets
π Web Server Monitor & Alert System This automation pings web servers at regular intervals, logs their status, and sends email alerts if a server goes down....
π Nodes & Integrations Used (3)
π Implementation & Setup Guide
π Web Server Monitor & Alert System
This automation pings web servers at regular intervals, logs their status, and sends email alerts if a server goes down. Itβs perfect for maintaining visibility over server uptime β without complex monitoring tools. π§ How It Works
This workflow performs minute-by-minute checks on all listed servers in a Google Sheet and:
β Logs all reachable servers in an βAliveβ log.
π» Sends an email alert if a server is unreachable.
π Logs failed servers in a βDownβ sheet with timestamps.
π§© Key Components β° 1. Schedule Trigger
Runs the workflow every minute for real-time monitoring. π 2. Web Servers List (Google Sheets)
Pulls server IPs or hostnames from a Google Sheet named Server_List. Each row = one server to monitor. This makes adding/removing servers effortless β just update the sheet. π 3. Servers Alive Check (HTTP Request)
Performs an HTTP GET request to each server (e.g., http://your-server.com). If the request fails, it automatically triggers the error path (handled via continueOnFail). β 4. Web Server Alive Log (Google Sheets)
Records successful pings in Server_Status_Alive with:
Timestamp
Server IP
Status = Alive
This log can be used for uptime reports or audits. π§ 5. Server Down Notification (Gmail)
If a server fails, this node sends an email to the admin. It includes:
Server address
Timestamp
Suggested action
π 6. Web Server Down Log (Google Sheets)
Logs failed pings in a separate sheet for historical tracking and debugging. β Main Advantages
Live Server Monitoring Stay informed about server health in near real-time.
No-Code Configuration Add/remove servers from the Google Sheet β no need to touch the workflow.
Email Alerts on Failure Proactively notifies you before users report the issue.
Audit-Ready Logging Maintains logs for both healthy and failed checks for documentation or reporting.
Flexible & Scalable Monitor 1 or 100 servers with the same template β just scale the list.
βοΈ Setup Steps π Prerequisites
Google Sheet with server list (column name = βServerβ)
Gmail OAuth2 Connection for alerts
n8n Instance running regularly
π Configuration
Google Sheets
Sheet 1 (Server_List): Your list of servers.
Sheet 2 (Server_Status_Alive): Log for reachable servers.
Sheet 3 (Server_Status_Down): Log for unreachable servers.
Gmail Integration
Connect your Gmail account in the Server Down Notification node.
Edit recipient email and message content as needed.
HTTP Check
Adjust the HTTP request URL template if using port numbers or paths (e.g., http://{{Server}}:8080/status).
Schedule
Default is every 1 minute. Change via Schedule Trigger if needed.
π§ͺ Testing
Input a reachable server (e.g., example.com) and an unreachable IP.
Run the workflow manually or wait for the next scheduled run.
Check:
Alive log updates correctly.
Down log records failures.
Email alert is received.
π Deployment
Activate the workflow, and it will quietly run in the background, notifying you of any server downtime instantly while keeping logs for future review.
β‘ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Monitor server uptime _ get email alerts with Google Sheets.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Email & Outreach Workflows
View All in Email & Outreach βAbandoned cart recovery for Shopify via Gmail Google Sheets T
Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to reco...
Add new leads in Lemlist from Airtable
This workflow allows you to add new leads in Lemlist from Airtable. !workflow-screenshot Airtable node: This node lists all the emails that are stored in you...
Add Subscriber and Send Email Campaign
Production-ready n8n automation template for Add Subscriber and Send Email Campaign built by AhiXLight. Seamlessly connects Sendy with 3 configured nodes.
Add new contacts from HubSpot to the email list in Mailchimp
This workflow adds new HubSpot contacts to the Mailchimp email list. Prerequisites - HubSpot account and HubSpot credentials - Mailchimp account and Mailchim...