n8n

How to Automate Google Sheets Uptime Alerts?

Keep tabs on your websites without watching dashboards. Every few hours, the system checks each URL in a Google Sheet, sends a quick alert when a site changes state, and records the event for later review. Ideal for small IT teams and agencies that need simple uptime tracking.

A Schedule Trigger starts the run every six hours. The Google Sheets node pulls the list of sites and their last known status. Split In Batches loops through each site, and an HTTP Request tests the URL and reads the response headers. A Set node builds flags to spot status changes and captures the response date. The Switch node routes results: send an email first, then a Slack message if a site is down or the status changed. Every check is logged to a sheet named after the site, and the main dashboard row is updated.

Prepare a Google Sheet with Property and Status columns, connect Slack and Gmail, and pick your check interval. Expect faster incident awareness, a clean history by month, and fewer manual checks. Useful for client site portfolios, marketing pages, or any small web stack.

What are the key features?

  • Six hour Schedule Trigger that runs checks automatically
  • Google Sheets read to get the site list and write to update status
  • Split In Batches processes sites in manageable groups
  • HTTP Request captures status code and response headers without failing the run
  • Set node computes change flags and stores the response date
  • Switch routes to alerts and logging based on the computed status
  • Gmail sends a plain text alert with subject and details
  • Slack posts a channel message after the email step completes

What are the benefits?

  • Reduce manual website checks from 60 minutes a day to 5 minutes
  • Automate 100 percent of uptime checks on a set schedule
  • Alert both email and Slack within minutes of a status change
  • Keep month by month logs in Google Sheets for audits
  • Scale to 50 or more sites with batch processing
  • Lower false alarms by routing only on downs and changes

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, Slack and Gmail. See the Tools Required section above for links to create accounts with these services.
  3. In Google Sheets, create a spreadsheet with a sheet named dashboard. Add two columns: Property for the site URL and Status with values UP or DOWN. Fill in the sites you want to monitor. Create an extra sheet tab for each site using its Property value as the tab name to store logs.
  4. Connect Google Sheets: in n8n, double click the Get Sites node, open the Credential to connect with dropdown, click Create new credential, and follow the on screen steps to authorize your Google Sheets account. Select your spreadsheet and the dashboard sheet.
  5. Configure Update Site Status: open the node and select the same spreadsheet and dashboard sheet so new statuses write back correctly.
  6. Set up Log Uptime Event: open the node and point to the same spreadsheet. Keep the sheet name expression so logs go to the tab matching each site name.
  7. Connect Gmail: double click the Send Email Alert node, create a new Gmail credential, and allow access. Replace the test address no-reply@example.com with your real recipient or a team list.
  8. Connect Slack: double click the Send Chat Alert node, create a Slack credential, and pick the channel where alerts should go. Make sure the app is installed to your workspace and can post to that channel.
  9. Set the schedule: open the Schedule Trigger node and choose how often to check. The template uses every 6 hours, but you can set a different interval.
  10. Verify HTTP checks: open Perform Site Test and confirm the URL field uses {{ $json.Property }} and that the option to not error on non 2xx responses is enabled so the run does not stop on failures.
  11. Run a test: click Execute Workflow. Confirm you receive an email and a Slack message when a site is marked down or changes status. Check Google Sheets to see a new row in the site tab and the Status updated in the dashboard.
  12. Troubleshoot: if nothing logs, confirm your Google account can edit the spreadsheet and that sheet names match Property values. If Slack does not post, check the channel ID and app permissions. If emails are missing, verify the recipient address and Gmail credential. Ensure your URLs include https and resolve correctly.

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)

Slack

Sign up

Free plan: $0 / mo; limited to 10 apps (third-party or custom) and usable via Slack API

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.