{"product_id":"weekly-competitor-rss-digest-in-n8n-sheets-openai-email","title":"Weekly Competitor RSS Digest in n8n: Sheets + OpenAI Email","description":"\u003ch3\u003eGet a weekly competitor content digest automatically—pulled from RSS, analyzed with OpenAI, and emailed via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday at 8am to collect the latest posts from up to three competitor RSS feeds, logs them to Google Sheets, generates a structured competitive analysis using OpenAI, and sends the finished weekly digest to you by email.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eSchedules the run:\u003c\/b\u003e executes every Monday at \u003cb\u003e8am\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSelects competitors:\u003c\/b\u003e builds a list of up to \u003cb\u003ethree\u003c\/b\u003e competitors from your configured RSS URLs, and skips blank or placeholder feeds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches RSS and extracts titles:\u003c\/b\u003e downloads each competitor’s RSS XML and extracts up to \u003cb\u003efive recent post titles\u003c\/b\u003e per competitor.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs to Google Sheets:\u003c\/b\u003e appends a new row to the “\u003cb\u003eCompetitor Content\u003c\/b\u003e” tab with fields including \u003cb\u003eWeek\u003c\/b\u003e, \u003cb\u003eCompetitor\u003c\/b\u003e, Post 1–Post 5 Title, \u003cb\u003ePost Count\u003c\/b\u003e, and \u003cb\u003eLogged At\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads back this week’s data:\u003c\/b\u003e after logging the last competitor, it pulls the current week’s rows from Google Sheets and compiles them into a single input.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates an OpenAI analysis:\u003c\/b\u003e sends the competitor publishing list to \u003cb\u003eOpenAI\u003c\/b\u003e to produce a structured digest including \u003cb\u003ehighlights, trending topics, content gaps, and an urgent content opportunity\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends via Gmail:\u003c\/b\u003e formats the digest as a plain-text email and delivers it through \u003cb\u003eGmail\u003c\/b\u003e to your configured recipient.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators tracking competitor marketing momentum without manual research.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying an RSS-to-insights pipeline for weekly reporting.\u003c\/li\u003e\n  \u003cli\u003eTeams identifying content opportunities by spotting recurring themes and missing angles in competitors’ recent posts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eScheduler\u003c\/b\u003e (runs Mondays at 8am)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, and \u003cb\u003ecode\u003c\/b\u003e for logic, formatting, and input preparation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ehttp request\u003c\/b\u003e for fetching RSS XML feeds\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e (OAuth2) with a tab named “Competitor Content” and weekly row logging\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e integration for the weekly competitive analysis digest\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e (OAuth2) to email the plain-text summary\u003c\/li\u003e\n  \u003cli\u003eIncludes \u003cb\u003esticky note\u003c\/b\u003e blocks for workflow documentation\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46047247958195,"sku":"N8N-19676","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xNSrcA3_L80ETKpoGS--R_ufe2IFUI.png?v=1789635780","url":"https:\/\/buyflowscripts.com\/products\/weekly-competitor-rss-digest-in-n8n-sheets-openai-email","provider":"N8N Commerce","version":"1.0","type":"link"}