{"product_id":"n8n-workflow-gemini-url-checks-from-google-sheets-gmail-alerts","title":"n8n Workflow: Gemini URL Checks from Google Sheets + Gmail Alerts","description":"\u003ch3\u003eMonitor URLs in Google Sheets hourly—and alert your inbox only when Gemini confirms a condition\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches URLs you track in Google Sheets, fetches each page (HTTP with Airtop browser fallback), asks \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to evaluate your plain-language condition with quoted evidence, logs every result back to Sheets, and sends a \u003cstrong\u003eGmail alert\u003c\/strong\u003e exactly when the condition becomes true.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHourly scheduling:\u003c\/strong\u003e Runs every hour, loads the \u003cstrong\u003eWatchlist\u003c\/strong\u003e tab, and selects only rows whose \u003cem\u003enext check\u003c\/em\u003e is due (up to your configured per-run limit).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eURL retrieval with smart fallback:\u003c\/strong\u003e Attempts each target URL via HTTP first. If the site blocks requests or the content is too short \/ JavaScript-rendered, it automatically switches to an \u003cstrong\u003eAirtop\u003c\/strong\u003e browser session to load the page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional page interaction + extraction:\u003c\/strong\u003e If configured, the workflow clicks an “open step” element, waits for the page to update, and extracts readable page text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini-based condition checking:\u003c\/strong\u003e Sends the extracted page text and the row’s condition to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, which returns a YES\/NO\/UNCLEAR verdict, a confidence score, and \u003cstrong\u003eexact quotes\u003c\/strong\u003e as evidence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvidence validation + notification logic:\u003c\/strong\u003e Validates Gemini’s evidence against the page text and uses a state machine to decide when to notify (e.g., only when a previously NO watch turns to YES, or after repeated monitoring errors).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Sheets + writes logs:\u003c\/strong\u003e Updates Watchlist fields (streaks, errors, \u003cem\u003enext_due_at\u003c\/em\u003e, last evidence\/error) and appends a record to the \u003cstrong\u003eLog\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends email alerts:\u003c\/strong\u003e Sends a \u003cstrong\u003eGmail\u003c\/strong\u003e email to the row’s \u003cem\u003enotify_to\u003c\/em\u003e address (or a default) only when notification is required.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack product pages or announcements and alert when a specific requirement appears.\u003c\/li\u003e\n  \u003cli\u003eMonitor policy pages or changelogs for a “true” condition with sourced quotes.\u003c\/li\u003e\n  \u003cli\u003eQuality-monitor SaaS pages where content loads via JavaScript and needs browser fallback.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (Watchlist + Log), Gmail, Google Gemini, Airtop (browser automation).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools mentioned:\u003c\/strong\u003e \u003cem\u003eif, set, code, no op, wait, gmail\u003c\/em\u003e (as part of the workflow logic).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow model:\u003c\/strong\u003e hourly checks, HTTP-to-Airtop fallback, Gemini evidence + state-machine notification, and persistent logging to Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e Create a Google Sheet with \u003cstrong\u003eWatchlist\u003c\/strong\u003e and \u003cstrong\u003eLog\u003c\/strong\u003e tab, then configure the columns\/rows for URLs, conditions, notify targets, and check timing.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45967562014899,"sku":"N8N-19262","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fWBP6_BKyJZe50ZLqsg_F_tmWiisDZ.png?v=1788685779","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-gemini-url-checks-from-google-sheets-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}