Automated Web Server Monitoring with n8n and Google Sheets

What This Workflow Does

This workflow checks if web servers are online every minute. It reads server details from a Google Sheet, tests each server by sending a request, and then logs if the server is up or down. If a server is down, it sends an email alert and records the downtime in another Google Sheet tab.

This stops the need for manual checks or missing alerts. It helps catch issues fast and keeps server uptime records clear.

Who Should Use This Workflow

Anyone who needs to watch web servers’ availability closely. Especially useful for small business IT people or teams who want quick downtime notes and alerts. It suits users who want easy control by just updating a Google Sheet.

It fits those wanting quick alerts by email when their servers stop responding.

Tools and Services Used

• n8n automation platform: Runs the workflow regularly.
• Google Sheets: Holds server lists and logs uptime/downtime.
• Gmail: Sends alert emails in case of server failures.
• Google Sheets OAuth2 and Gmail OAuth2 credentials: Needed for n8n to access Google services.

Workflow Inputs, Processing Steps, and Outputs

Inputs

• Google Sheets data with server IP addresses or hostnames to check.

Processing Steps

• The Schedule Trigger node runs every minute to start the workflow.
• The Google Sheets node reads all servers from the sheet.
• The HTTP Request node sends GET requests dynamically to each server.
• Successful responses trigger logging uptime into a “Server_Status_Alive” sheet tab with timestamp and server info.
• Failed HTTP requests send an alert email through the Gmail node to the team, with server and failure time details.
• All failed checks are recorded in “Server_Status_Down” tab for downtime history.
• The workflow continues running smoothly, even if some server checks fail, due to error handling.

Outputs

• An updated Google Sheet with live server check logs (up and down).
• Instant email alerts on server failure.
• Error-free continuous monitoring process.

Beginner Step-by-Step: How to Use This Workflow in n8n

Step 1: Import Workflow

1. Download the workflow file using the Download button on this page.
2. Open the n8n editor where workflows are created.
3. Click on “Import from File” and upload the downloaded workflow file.

Step 2: Set Up Credentials

1. Add Google Sheets OAuth2 credentials under n8n credentials for reading and writing sheets.
2. Add Gmail OAuth2 credentials for sending alert emails.

Step 3: Update Configurations

1. Check the Google Sheets node settings. Update the spreadsheet ID and sheet names if your spreadsheet differs.
2. Update email addresses in the Gmail node to send alerts to your team.

Step 4: Test Workflow

1. Run the workflow manually once to confirm it reads servers, sends requests, logs correctly, and emails alerts if any server is down.

Step 5: Activate for Production

1. Toggle the workflow active status in n8n so it runs every minute automatically in the background.
2. Monitor initial runs through n8n’s execution logs to check proper operation.

For many servers or frequent checks, consider self-host n8n to avoid API or usage limits.

Common Edge Cases and Failures

• If the HTTP Request node fails and stops the workflow, enable “Continue on Error” in node settings to keep workflow running.
• If Google Sheets nodes write no data, verify spreadsheet IDs, sheet names, and check if credentials have proper permissions.
• Make sure server addresses in Google Sheets are correct and reachable.
• Check Gmail sending limits if many alerts are triggered to avoid email blocking.

Customization Ideas

• Change check interval in the Schedule Trigger node from 1 minute to longer times like 5 or 10 minutes to reduce API calls.
• Add HTTP headers in the HTTP Request node if servers need authentication or special headers.
• Extend Google Sheets logs to include HTTP status codes or response times by parsing HTTP Request responses.
• Add a Slack node for alerts instead of or in addition to Gmail emails to notify teams instantly in chat channels.

Summary of What You Get

✓ Automated server status checks every minute.

✓ Real-time email alerts on any server downtime.

✓ Detailed uptime and downtime logs in Google Sheets.

✓ Continuous running workflow that handles errors smoothly.

→ Easier server monitoring without manual work.

→ Faster response to downtime saving trust and revenue.