{"product_id":"n8n-competitor-pricing-news-tracker-in-google-sheets","title":"n8n Competitor Pricing \u0026 News Tracker in Google Sheets","description":"\u003ch3\u003eTrack competitor pricing and product messaging automatically—then get a weekly brief in Gmail + Slack\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Competitor Pricing \u0026amp; News Tracker in Google Sheets\u003c\/strong\u003e monitors competitor web pages and industry news every week. It detects real changes (like pricing updates and messaging shifts), uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to rate what matters, logs everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a short actionable summary via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every Monday at 8 AM\u003c\/strong\u003e (customizable schedule).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads competitor pages + last week’s snapshots\u003c\/strong\u003e from your Google Sheet, skipping rows marked \u003cem\u003einactive\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches each page\u003c\/strong\u003e, converts the HTML to clean text, and compares it line-by-line against the previous snapshot.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents false alarms:\u003c\/strong\u003e if a fetch fails, the last known good copy is kept—so outages don’t create “changes.”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs updates in Google Sheets\u003c\/strong\u003e (Snapshots + Change Log), saving status, timestamps, and page content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReduces noise with Gemini:\u003c\/strong\u003e only changed lines go to Google Gemini, which labels and explains significance for your business.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks competitor headlines for the last 7 days\u003c\/strong\u003e using \u003cstrong\u003eGoogle News RSS\u003c\/strong\u003e (no API key required), then Gemini drafts a weekly brief.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the weekly brief\u003c\/strong\u003e as an \u003cstrong\u003eHTML email via Gmail\u003c\/strong\u003e and posts a summary to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS founders\u003c\/strong\u003e watching pricing and packaging changes across key competitors.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarketing teams\u003c\/strong\u003e monitoring messaging updates and positioning shifts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSales leaders\u003c\/strong\u003e identifying threats\/opportunities before deals are impacted.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building a reliable competitor monitoring system with clear Google Sheets reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets tabs:\u003c\/strong\u003e Competitors, Snapshots, Change Log (with the specified header rows).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e runs weekly (Monday at 8 AM, configurable).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ building blocks used:\u003c\/strong\u003e if, set, code, gmail, merge, slack.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132857962675,"sku":"N8N-20162","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DtyQCWzBxiYM_cfntC0K__noL4uEdc.png?v=1790759750","url":"https:\/\/buyflowscripts.com\/products\/n8n-competitor-pricing-news-tracker-in-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}