Weekly Competitor Content Digest with Gemini, OpenAI & Firecrawl

This workflow is designed for competitive intelligence analysts, product managers, and content marketers tracking multiple company blogs and news sources. It starts with a Sunday cron trigger, reading a curated list of URLs from the 'Input Links' tab in Google Sheets. It filters out duplicates and irrelevant pages using an AI agent, ensuring only blog posts, tutorials, news, and product updates proceed.

Firecrawl scrapes the approved links, extracting content which is then condensed by Gemini 2.5-Flash and OpenAI into structured summaries including title, author, date, and three-sentence overviews. Results are appended to the 'Summary' sheet for a searchable knowledge base. Finally, it generates a company-grouped HTML digest and emails it before the workweek begins.

Benefits include eliminating manual tab-juggling, relevance checks, and report assembly, saving hours weekly. It transforms scattered links into actionable insights, enabling focus on strategy over data collection. Ideal for ongoing competitor monitoring in fast-paced industries like tech and marketing.

Setup is straightforward: import the JSON, create a Google Sheet with 'Input Links' and 'Summary' tabs (add Company, Page URL columns to Input Links), configure credentials for Sheets, AI APIs, Firecrawl, and email.