Quick Overview
Quick Overview This workflow checks URLs listed in Google Sheets on an hourly schedule, fetches each page via HTTP or Airtop browser automation, uses Google Gemini to judge a plain-language condition with quoted evidence, logs each check back to Sheets, and sends a Gmail alert when the condition becomes true. How it works Runs every hour and loads the Watchlist tab from Google Sheets, selecting only rows whose next check is due (up to the configured per-run limit). Fetches each target URL via HTTP first and automatically switches to an Airtop browser session when the site blocks requests or the content is too short/JavaScript-rendered. If configured, Airtop clicks an “open step” element on the page, waits briefly for the page to update, and then extracts readable page text. Sends the extracted page text and the row’s condition to Google Gemini, which returns a YES/NO/UNCLEAR verdict, confidence score, and exact quotes as evidence. Validates Gemini’s evidence against the page text and applies a state machine to decide whether to notify (only when a previously NO watch turns to YES, or after repeated monitoring errors). Updates the Watchlist row (streaks, errors, next_due_at, last evidence/error) and appends a check record to the Log tab in Google Sheets. Sends a Gmail email to the row’s notify_to address (or the default email) when notification is required, otherwise ends without sending. Setup Create a Google Sheet with Watchlist and Log tabs (with the columns expected by the template) and add a Google Sheets OAuth credential. Add a Google Gemini (PaLM/Gemini) API credential for the condition-judging step. Add a Gmail OAuth credential and set the default notification email and Google Sheets document ID in the Config node. (Optional) Add an Airtop credential if you need browser-based fetching, and fill fetch_mode (auto/browser) and open_step for rows that require clicking before content is visible. Populate the Watchlist with unique watch_id, url, condition, and check_every_hours values, then run once manually to establish the baseline before relying on email alerts. An n8n automation workflow template by ayumi.
ayumi
web
free
Others in the same category, ranked by how often they are opened.
