Monitor Competitors & Generate Content Ideas with GPT4 & Gemini to Google Sheets

Description

Who’s it for
Women creators, homemakers-turned-entrepreneurs, and feminine lifestyle brands who want a graceful, low-lift way to keep an eye on competitor content and spark weekly ideas.

What it does
On a weekly schedule, this workflow crawls your competitor URLs with Firecrawl (HTTP Request), summarizes each page with OpenAI, brainstorms carousel/pin ideas with Gemini, appends results to Google Sheets (Date, URL, Title, Summary, Ideas), and sends you a single email digest (optional Telegram alert). It includes basic error notifications and a setup-friendly config node.

Requirements
HTTP credentials** for Firecrawl, OpenAI, and Gemini (no keys in nodes)
Google Sheets** OAuth credential
A Sheets document with a target sheet/range (e.g., Digest!A:F)
(Optional) Telegram bot + chat ID

How to set up
Open Set: Configuration (edit me) and fill:
competitorUrls (one per line), sheetsSpreadsheetId, sheetsRange,
ownerEmail, emailTo, geminiModel, openaiModel
Attach credentials to the HTTP and Sheets nodes.
Test by switching Cron to Every minute, then revert to weekly.

How it works
Cron → Firecrawl (per URL) → Normalize → OpenAI (summary) + Gemini (ideas) → Merge → Compile Row → Google Sheets append → Build one digest → Email (+ optional Telegram).

How to customize
Add/remove competitors or change the weekly send time.
Tweak the OpenAI/Gemini prompts for your brand voice.
Expand columns in Sheets (e.g., category, tone, CTA).
Swap email/Telegram for Slack/Notion, or add persistent logs.