{"product_id":"n8n-google-sheets-watcher-gemini-telegram-alerts","title":"n8n Google Sheets Watcher: Gemini + Telegram Alerts","description":"\u003ch3\u003eDetect real changes in your Google Sheets URL watchlist—and alert via Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches Google Sheets URLs every 10 minutes, checks each page for meaningful content changes using Google Gemini, and sends Telegram alerts only when something actually changed (while suppressing noisy, meaningless updates).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a schedule (every 10 minutes)\u003c\/b\u003e to keep your watchlist continuously monitored.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads a Google Sheets watchlist\u003c\/b\u003e and filters to rows marked \u003ci\u003eactive\u003c\/i\u003e (TRUE\/FALSE).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDownloads each URL page\u003c\/b\u003e over HTTP and extracts the visible body text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCleans “noisy” dynamic text\u003c\/b\u003e (e.g., timestamps, counters, UUIDs, long tokens) and can optionally narrow to sentences containing a configured keyword.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates a hash\u003c\/b\u003e of the cleaned text and compares it to the previous hash stored in Google Sheets to classify: first run, changed, unchanged, or error.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses Google Gemini for change detection\u003c\/b\u003e: when the page changed, Gemini receives the old and new snapshots to summarize what actually changed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSuppresses irrelevant alerts\u003c\/b\u003e when Gemini returns \u003ci\u003e“NO MEANINGFUL CHANGE”\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends Telegram alerts\u003c\/b\u003e with the meaningful change summary and \u003cb\u003eupdates Google Sheets\u003c\/b\u003e with the latest hash, snapshot, last checked time, and last change summary (or saves a baseline on first run).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators monitoring public pricing pages or announcements listed in a Google Sheets watchlist.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers tracking specific keyword-relevant updates on multiple URLs.\u003c\/li\u003e\n  \u003cli\u003eTeams receiving Telegram notifications only for real content changes—without being spammed by timestamps, counters, or session noise.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e (watchlist + storing \u003ci\u003elast_hash\u003c\/i\u003e, \u003ci\u003elast_snapshot\u003c\/i\u003e, \u003ci\u003elast_checked\u003c\/i\u003e, \u003ci\u003elast_change\u003c\/i\u003e, and a \u003ci\u003erow_number\u003c\/i\u003e key for updates)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Gemini\u003c\/b\u003e to summarize differences and determine meaningful change vs “NO MEANINGFUL CHANGE”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTelegram\u003c\/b\u003e for alert delivery\u003c\/li\u003e\n  \u003cli\u003en8n nodes include: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ehtml\u003c\/b\u003e, \u003cb\u003eno op\u003c\/b\u003e, \u003cb\u003ecrypto\u003c\/b\u003e, \u003cb\u003efilter\u003c\/b\u003e (plus HTTP\/page retrieval as part of the check)\u003c\/li\u003e\n  \u003cli\u003eSetup: configure \u003cb\u003eGoogle Sheets Service Account credentials\u003c\/b\u003e in n8n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916243984563,"sku":"N8N-18806","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/T85YJurhNKK5phnQQ3t9l_AS0RF65c.png?v=1788013328","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-watcher-gemini-telegram-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}