Weekly competitor content digest with Gemini & OpenAI, Google Sheets, and Firecrawl

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 through dozens of tabs—this template is for you.

What does it do? The workflow reads a curated list of candidate URLs from Google Sheets, filters out duplicates and off‑topic pages with an AI agent, scrapes the surviving links, generates three‑sentence summaries, logs the results back to Sheets, and delivers a polished HTML digest to your inbox every week.

Why is it useful? Instead of manually opening competitor links, checking for relevance, copying highlights, and pasting them into reports, this automation does the grunt work for you. It turns scattered URLs into a searchable knowledge base and a ready‑to‑share email, freeing you to focus on insights and strategy—not housekeeping.

How does it work? A Sunday‑morning cron trigger kicks things off. The workflow pulls links from the Input Links tab, compares them to the existing Summary tab, and passes fresh candidates to an AI “bouncer” that keeps only blog posts, tutorials, news, and product updates. Firecrawl then scrapes each page; Gemini 2.5‑Flash and OpenAI condense the content into title, author, date, and summary. The structured data is appended to your Summary sheet and formatted into a company‑grouped HTML digest, which lands in your email before the workweek starts.

Set up steps

1. Clone the workflow - Import the JSON into your n8n Cloud workspace.

2. Create the Google Sheet - Make a new spreadsheet with two tabs: Input Links and Summary (names must match). - In Input Links, add columns Company, Page Type, and Link (or rename to match the node mapping). - Leave Summary blank—the workflow will populate it. - Copy the Sheet URL; you’ll paste it into two Google Sheets nodes.

3. Add credentials (n8n ▸ Credentials) - Google Sheets OAuth2 – Authorise with the Google account that owns the spreadsheet. - Gmail OAuth2 – Authorise the Gmail account that should send the digest. - Firecrawl HTTP Header Auth – Set Authorization: Bearer <YOURFIRECRAWLAPIKEY>.