Weekly competitor content digest with Gemini & OpenAI, Google Sheets, and Firecrawl
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs on a schedule (cron 0 0 5 * * SUN). Along the way it connects Google Gemini Chat Model, Google Sheets, OpenAI Chat Model and Gmail. It also calls api.firecrawl.dev over HTTP.
How it runs
Trigger: On a schedule (cron 0 0 5 * * SUN).
- Input Links (Google Sheets): uses Google Sheets
- Firecrawl_Links (HTTP Request): calls api.firecrawl.dev (POST)
- Agent: Identify URLs to Crawl (AI Agent): runs an AI agent, with model: OpenAI o4-mini; 1 tool (Read_Url_Summary_Tool); output parser: Structured Output Parser
- Split Out: splits a list into separate items
- Firecrawl_Markdown (HTTP Request): calls api.firecrawl.dev (POST)
- Agent: Summarize Each URL (AI Agent): runs an AI agent, with model: Gemini 2.5 Flash: Temp; output parser: Structured Output Parser
- Append row in sheet (Google Sheets): append
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Code: runs custom JavaScript code
- Send a message (Gmail): uses Gmail
Services it uses
HTTP calls to: api.firecrawl.dev
Uses Firecrawl. New users get 10% off with our link.
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail
From the author
Who is this template for? This workflow is perfect for competitive‑intel analysts, product managers, content marketers, and anyone who tracks multiple company blogs or news sources. If you need a weekly snapshot of fresh, on‑topic articles—without wading…