Automated Website Uptime Monitor with Google Sheets & Gmail Alerts
detail.loadingPreview
Proactively monitor your critical website URLs for uptime and receive instant email notifications for any outages. This n8n workflow automatically checks a predefined list of URLs, logs their status in Google Sheets, and sends a comprehensive Gmail report, ensuring you're always informed.
About This Workflow
Ensure your online services are always running smoothly with this automated website uptime monitoring solution. This n8n workflow is designed to periodically check a customizable list of URLs for availability. Each check logs the status—whether a URL is functional or experiencing an outage—directly into a designated Google Sheet, creating a historical record of your website's performance. Beyond logging, the system intelligently summarizes the results and, crucially, dispatches an immediate Gmail alert detailing any fallen URLs along with an overall count of functional versus failed sites. This setup provides critical insights and proactive incident response capabilities without writing a single line of code.
Key Features
- Automated Scheduling: Set the workflow to run at custom intervals, ensuring continuous monitoring without manual intervention.
- Centralized URL List: Easily manage all monitored URLs within a single, editable n8n
Setnode. - Google Sheets Logging: Automatically append uptime and downtime records to a Google Sheet for easy historical analysis and reporting.
- Intelligent Status Summaries: Receive aggregated counts of functional and failed URLs in each report.
- Instant Email Alerts: Get notified via Gmail with a clear list of affected URLs whenever an outage is detected.
How To Use
- Define Your URLs: In the 'URLs' (Set) node, update the
jsonOutputparameter. Modify the JSON object within theurlsproperty to include all the website links you wish to monitor (e.g.,"URL 1": "https://yourwebsite.com"). - Configure Monitoring Schedule: Adjust the 'Schedule Trigger' node to set how often the workflow should run (e.g., every 5 minutes, hourly, daily).
- Set Up Google Sheets: Connect your Google Sheets account to both the 'Success' and 'Error' Google Sheets nodes. Select the desired spreadsheet and sheet where uptime logs will be appended. Ensure the specified column names (
Caida,Funcional) exist in your sheet. - Add HTTP Request Node (Crucial!): Place an 'HTTP Request' node immediately after the 'Bucle URLs' node. Configure it to make GET requests to
{{ $json.value }}(this typically holds the URL after 'Split Out'). - Connect Success/Error Paths: Connect the 'HTTP Request' node's 'On Success' output to the 'Success' Google Sheets node and its 'On Error' output to the 'Error' Google Sheets node.
- Configure Gmail Notifications: Connect your Gmail account to the 'Send a message' node. Update the
sendToparameter with the email address(es) where you want to receive outage alerts. - Activate and Test: Save the workflow, enable it, and run a manual test using the 'Run trigger' node to ensure all notifications and logging work as expected.
Apps Used
Workflow JSON
{
"id": "7389ded5-bea9-4ba0-933f-6e5e6f7a529b",
"name": "Automated Website Uptime Monitor with Google Sheets & Gmail Alerts",
"nodes": 17,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 7389ded5-bea9...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.