n8n

How to Automate Gmail Server Uptime Alerts?

Keep your websites and apps online with automatic health checks and clear email alerts. The system checks each server on a set schedule, records results in Google Sheets, and notifies your team when a host goes down. It suits small teams and IT leads who need simple uptime tracking without extra tools.

A schedule runs every minute and reads a server list from a Google Sheets tab. For each row, an HTTP request tries to reach the server address using the value in the Server column. Successful checks are logged to a separate sheet with a date stamp and the server value, building an uptime history you can filter and chart. When a request fails, Gmail sends an alert with the server name and time, then a second sheet stores the downtime record for audits and root cause review.

Setup needs a Google Sheet with a header named Server and two result tabs for alive and down logs, and a Gmail account with send access. Expect faster incident response and less manual checking, since the system runs every minute and grows as you add rows to the sheet. It suits web teams, MSPs, and internal IT who want light monitoring they can adjust in minutes.

What are the key features?

  • Minute based schedule runs checks automatically.
  • Reads the server list from a Google Sheets tab so you do not edit the workflow to add hosts.
  • Performs an HTTP request to each server and routes success or failure.
  • Appends successful checks to an Alive sheet with date and server details.
  • Sends a Gmail alert on failure with server name and time.
  • Appends failed checks to a Down sheet to keep an audit trail.

What are the benefits?

  • Reduce manual checks from 2 hours daily to 5 minutes
  • Send outage alerts to the right people within 1 minute
  • Keep 100 percent uptime and downtime history in Sheets
  • Scale from 5 to 500 servers by adding rows only
  • Connect Gmail and Google Sheets in one simple flow

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets and Gmail. See the Tools Required section above for links to create accounts with these services.
  3. In Google Sheets, create a spreadsheet with one tab for your server list with a header named Server. Create two more tabs for logs named Alive and Down with headers TimeStamp, Status, and Server IP Address.
  4. Open the Server List Google Sheets node in n8n and select your spreadsheet and the tab that contains the Server column. Confirm the header matches exactly.
  5. Double click the Google Sheets nodes and in the Credential to connect with field click Create new credential, then follow the on screen steps to connect your Google account.
  6. Double click the Gmail node and in the Credential to connect with field click Create new credential, then follow the on screen steps to connect your Gmail account and allow send email permission.
  7. In the HTTP Request node, confirm the URL uses the Server field, for example http://{{ $json.Server }} or https://{{ $json.Server }}. Use https if your sites support it.
  8. In the Alive log node, choose your spreadsheet and Alive tab. Make sure the fields map to TimeStamp, Status set to Alive, and Server IP Address uses the Server value.
  9. In the Gmail node, set the To address for your alert list. Edit the subject and message text to match your incident style. Remove any symbols you do not want.
  10. In the Down log node, select your spreadsheet and Down tab. Confirm TimeStamp, Status set to Down, and Server IP Address fields are mapped.
  11. Open the Schedule Trigger and set the interval. One minute is a common choice, but you can pick a longer window to reduce email volume.
  12. Test with one valid server and one fake host. Run once in n8n. Confirm you receive an email for the failed host and that both Alive and Down tabs get new rows. If you do not see results, check sheet permissions, verify column names, and review server firewalls or timeouts in the HTTP node.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.