Send weekly competitor content digests with RSS, Google Sheets, OpenAI and Gmail
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs on a schedule (cron 0 8 * * 1). Along the way it connects Google Sheets, OpenAI Chat Model and Gmail.
How it runs
Trigger: On a schedule (cron 0 8 * * 1).
- Set config (Edit Fields (Set)): sets 12 fields: competitor1Name, competitor1RssUrl, competitor2Name…
- Build the competitor list (Code): runs custom JavaScript code
- Fetch the RSS feed (HTTP Request): calls an HTTP API
- Read the posts from the feed (Code): runs custom JavaScript code
- Log the posts (Google Sheets): append
- Last competitor? (If): checks a condition and branches into true / false
- Read this week's posts (Google Sheets): get many
- More competitors to go (Edit Fields (Set)): sets 1 field: result
- Prepare the data for GPT (Code): runs custom JavaScript code
- Write the digest (AI Agent): runs an AI agent, with model: Chat model; output parser: Output Parser - Digest sections
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Write the digest (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Write the digest (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs every Monday, pulls the latest posts from up to three competitor RSS feeds, logs the titles to Google Sheets, uses OpenAI to generate a weekly competitive analysis (trends, gaps, and opportunities), and emails the digest via…