Weekly Competitor Content Insights to Google Sheets

This workflow automates weekly collection and analysis of competitor content for content creators and women-led brands. It begins with a scheduled trigger every Sunday at 5 PM, then uses Firecrawl to scrape competitor URLs. The collected data is summarized using OpenAI and ideated with Google’s Gemini API. These insights, including summaries and creative ideas, are merged and stored in a Google Sheet for easy review. Optionally, a digest email summarizing the findings is sent, along with a Telegram notification for real-time updates. This process enables effortless competitor monitoring, idea generation, and content planning with minimal manual effort. It’s ideal for brands that want to stay competitive and inspired while maintaining a low-lift workflow.