SM
Sheby M
Loading portfolio experience
Business Operations · Automation, Dashboard, Website
WebSignal Monitor – URL Variable Tracking Automation
An automated website-monitoring workflow that checks URLs from Google Sheets, Airtable, or sitemaps, detects a required HTML variable, records results, analyzes trends, and sends weekly reports.
Stack and focus areas
n8n/MakeAutomationPythonn8nGoogle SheetsAirtableXML SitemapHTTP RequestsHTML ParsingVariable DetectionRetry LogicStatus Code MonitoringScheduled WorkflowsTrend AnalysisEmail ReportsError HandlingWebhooks
Project description
The operations team needed to check a growing list of URLs for a particular HTML variable. Manually opening pages, reviewing source code, handling temporary server errors, updating spreadsheets, and comparing results between weeks was inefficient and difficult to maintain.
I developed an n8n workflow that retrieves URLs from Google Sheets, Airtable, or an XML sitemap. Each URL is requested and its HTML is inspected for a configurable variable or code pattern. URLs returning a 500-level status are placed into a controlled retry loop before being marked as failed. Detection results, response status, check time, and errors are written back to the source table. A historical table records every scan and calculates week-over-week increases or decreases before sending an automated email summary.
