Weekly Competitor RSS Digest in n8n: Sheets + OpenAI Email

Get a weekly competitor content digest automatically—pulled from RSS, analyzed with OpenAI, and emailed via Gmail

This 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.

What this workflow does

• Schedules the run: executes every Monday at 8am.
• Selects competitors: builds a list of up to three competitors from your configured RSS URLs, and skips blank or placeholder feeds.
• Fetches RSS and extracts titles: downloads each competitor’s RSS XML and extracts up to five recent post titles per competitor.
• Logs to Google Sheets: appends a new row to the “Competitor Content” tab with fields including Week, Competitor, Post 1–Post 5 Title, Post Count, and Logged At.
• Reads back this week’s data: after logging the last competitor, it pulls the current week’s rows from Google Sheets and compiles them into a single input.
• Generates an OpenAI analysis: sends the competitor publishing list to OpenAI to produce a structured digest including highlights, trending topics, content gaps, and an urgent content opportunity.
• Sends via Gmail: formats the digest as a plain-text email and delivers it through Gmail to your configured recipient.

Use cases

• SaaS operators tracking competitor marketing momentum without manual research.
• Automation engineers deploying an RSS-to-insights pipeline for weekly reporting.
• Teams identifying content opportunities by spotting recurring themes and missing angles in competitors’ recent posts.

Technical details

• Scheduler (runs Mondays at 8am)
• if, set, and code for logic, formatting, and input preparation
• http request for fetching RSS XML feeds
• Google Sheets (OAuth2) with a tab named “Competitor Content” and weekly row logging
• OpenAI integration for the weekly competitive analysis digest
• Gmail (OAuth2) to email the plain-text summary
• Includes sticky note blocks for workflow documentation