Overview
Manual webpage monitoring wastes time and risks missing critical content changes. This automation fetches the target page, extracts key text from class="ct07", computes a hash to detect differences, logs snapshots into Google Sheets, and sends email alerts—cutting manual checks and preserving a full change history.
The Impact
- Stop manual page checks. Automate content capture and change detection reliably.
- Flag unexpected edits. Receive instant email alerts when page content shifts.
- Audit change history. Maintain chronological records in Google Sheets for compliance.
- Skip guesswork. Hash-based comparison ensures precise content integrity verification.
Who This Is For
- Product Managers monitoring key webpages for accidental or unauthorized updates.
- Operations & Maintenance Teams ensuring website stability and content accuracy.
- Compliance and Legal Teams verifying public documents remain untampered.
- Marketing Analysts tracking competitor price or promotion page changes automatically.
How It Works
- Fetch Webpage
- Send HTTP GET to the specified URL to retrieve raw HTML content.
- Extract Content
- Parse HTML to extract text inside class="ct07" or fallback to the first 5000 characters if absent.
- Compute Content Hash
- Generate MD5 hash of the extracted content to represent current page state.
- Log To Google Sheets
- Append URL, timestamp (UTCDate), and hash value as a new row to the configured spreadsheet.
- Send Email Notification
- Use Brevo to email the change details to the designated recipient for immediate awareness.
What You'll Need
Before using this template, make sure you have:
- A Google Sheets spreadsheet with headers in order: URL, UTCDate, HashValue.
- Google Sheets OAuth credentials authorized to append and update the target sheet.
- Brevo email sending credentials configured with valid sender and recipient addresses.
- The full URL of the webpage to monitor, including protocol (http:// or https://).
How to Use
- Step 1. Prepare Google Sheet
- Step 2. Configure Credentials
- Step 3. Set Target URL
- Step 4. Run the Workflow
- Step 5. Verify Execution
Create a sheet with the headers URL, UTCDate, and HashValue in that exact order.
Set up OAuth credentials for Google Sheets and Brevo email service within the workflow.
Input the full webpage URL you want to monitor in the TargetUrl parameter.
Trigger the workflow to start fetching, extracting, hashing, logging, and notifying changes.
Check your Google Sheet for new entries and confirm email notifications for detected changes.