How to Automate Google Sheets Uptime Alerts?
Description
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.
Tools Required
What this workflow does?
- 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 to set this up?
- 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.
- You'll need accounts with Google Sheets, Slack and Gmail. See the Tools Required section above for links to create accounts with these services.
- 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.
- 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.
- Configure Update Site Status: open the node and select the same spreadsheet and dashboard sheet so new statuses write back correctly.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
