Schedule Trigger Automate

Used in Schedule Trigger, this automated workflow checks website statuses every 6 hours, logs results in Google Sheets, and sends alerts via Slack and email for any status changes, ensuring timely monitoring and communication of site uptime.

7/8/2025
15 nodes
Complex
schedulecomplexschedule triggergooglesheetsslackgmailsplitinbatchessticky noteautomationadvancedcroncommunicationnotificationapiintegrationlogicrouting
Categories:
Communication & MessagingSchedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
Schedule TriggerGoogleSheetsSlackGmailSplitInBatchesSticky Note

Target Audience

This workflow is ideal for:
- Website Administrators: Those who need to monitor the uptime of their websites regularly.
- DevOps Engineers: Professionals looking to automate site monitoring and alerting processes.
- Small Business Owners: Individuals who want to ensure their online presence is always accessible to customers.
- IT Support Teams: Teams responsible for maintaining website functionality and performance.

By utilizing this automated workflow, these groups can proactively manage website uptime and minimize downtime impact.

Problem Solved

This workflow addresses the challenge of website downtime monitoring by automating the process of checking the status of multiple websites at regular intervals. It ensures that:
- Immediate Alerts are sent via Slack and Email when a site goes down or changes status, allowing for quick response times.
- Logging of Events into Google Sheets provides a historical record of site performance, aiding in analysis and reporting.
- Scheduled Checks reduce the need for manual monitoring, saving time and resources.

Workflow Steps

  • Schedule Trigger: The workflow initiates every 6 hours to check the status of specified websites.
    2. Get Sites: It retrieves a list of websites from a Google Sheet.
    3. For Each Site: The workflow iterates through each site to perform checks.
    4. Perform Site Test: An HTTP Request is made to each site to check its status code.
    5. Calculate Status: Based on the response, it determines if the site is UP or DOWN and identifies any status changes.
    6. Status Router: Depending on the calculated status, it routes the workflow for further actions:
    - If the site remains UP, it logs the event.
    - If the site goes DOWN or changes from DOWN to UP, it triggers alerts.
    7. Send Alerts: Notifications are sent via Slack and Email to inform stakeholders of the status change.
    8. Log Uptime Event: Records the event in Google Sheets for future reference.
    9. Update Site Status: Updates the status of the site in the Google Sheet to reflect the latest check.

    • Customization Guide

    To customize this workflow:
    - Modify the Schedule: Adjust the interval in the Schedule Trigger to check more or less frequently based on your needs.
    - Change Notification Channels: Update the Slack channel or Email recipient in the Send Chat Alert and Send Email Alert nodes to target different teams or individuals.
    - Update Site List: Edit the Google Sheet to add or remove sites from monitoring.
    - Customize Alert Messages: Tailor the message content in the alert nodes to include specific details relevant to your audience.
    - Add More Actions: Integrate additional nodes for further actions, such as logging to different databases or triggering other workflows based on site status.

    Schedule Trigger Automate - N8N Workflow Directory