{"product_id":"weekly-competitor-intelligence-with-n8n-sheets-gmail-gemini","title":"Weekly Competitor Intelligence with n8n, Sheets, Gmail \u0026 Gemini","description":"\u003ch3\u003eStay ahead of competitor changes—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors competitor websites and news every week, detects meaningful updates, and turns them into a clear competitor intelligence brief. Changes are logged in Google Sheets, and the final report is emailed via Gmail and summarized in Slack—so you don’t waste hours chasing updates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly (default Monday at 8 AM)\u003c\/strong\u003e using a schedule trigger (you can switch to daily).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your competitor page list\u003c\/strong\u003e from Google Sheets and skips any rows marked as inactive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches each competitor page over HTTP\u003c\/strong\u003e, converts the HTML into clean readable text, and compares it line-by-line against last week’s snapshot to identify added and removed content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePreserves stability during outages:\u003c\/strong\u003e if a page can’t be fetched, the last good snapshot is kept so outages aren’t misreported as changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini to judge significance:\u003c\/strong\u003e for changed pages, it sends only the added\/removed lines for Gemini to rate impact, label change type, and explain why it matters to your business—reducing noise.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs everything in Google Sheets:\u003c\/strong\u003e latest snapshots are saved to the \u003cem\u003eSnapshots\u003c\/em\u003e tab, and real updates are recorded in the \u003cem\u003eChange Log\u003c\/em\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls competitor headlines from Google News RSS\u003c\/strong\u003e for the last 7 days (no API key required).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges results into one research pack\u003c\/strong\u003e and asks Gemini to generate a weekly brief with top moves, threats, opportunities, and recommended actions—then delivers it as an HTML email via \u003cstrong\u003eGmail\u003c\/strong\u003e and a short update 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\u003eWeekly competitive monitoring for \u003cstrong\u003eSaaS operators\u003c\/strong\u003e tracking pricing, product, and messaging shifts.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers maintaining a reliable competitor intelligence pipeline in \u003cstrong\u003en8n\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTeams who need shareable updates sent via \u003cstrong\u003eemail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e without manual research.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow logic:\u003c\/strong\u003e if, set, code\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData delivery \u0026amp; collaboration:\u003c\/strong\u003e Gmail, Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResearch assembly:\u003c\/strong\u003e merge\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for anyone building an \u003cstrong\u003eSEO-driven competitor intelligence\u003c\/strong\u003e automation with n8n, Google Sheets, Gmail, and Gemini.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086644138163,"sku":"N8N-19917","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EUXHXGdGh9iVtxa5tNv_a_oIWqZMTi.png?v=1790327105","url":"https:\/\/buyflowscripts.com\/products\/weekly-competitor-intelligence-with-n8n-sheets-gmail-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}