Automated content strategy with Google Trends, News, Firecrawl & Claude AI

📺 Full walkthrough video: https://youtu.be/dXz5OTbm4c8

Automated trend monitoring for content strategy

Who's it for Content creators, marketers, and social media managers who want to stay ahead of emerging trends and generate relevant content ideas based on data-driven insights.

What it does This workflow automatically identifies trending topics related to your industry, collects recent news articles about these trends, and generates content suggestions. It transforms raw trend data into actionable editorial opportunities by analyzing search volume growth and current news coverage.

How it works The workflow follows a three-step automation process: Trend Analysis: Examines searches related to your topics and identifies those with the strongest recent growth Article Collection: Searches Google News for current articles about emerging trends and scrapes their full content Content Generation: Creates personalized content suggestions based on collected articles and trend data The system automatically excludes geo-localized searches to provide a global perspective on trends, though this can be customized.

Requirements SerpAPI account (for trend and news data) Firecrawl API key (for scraping article content from Google News results) Google Sheets access AI model API key (for content analysis and recommendations - you can use any LLM provider you prefer)

How to set up

Step 1: Prepare your tracking sheet Duplicate the Google Sheets template by opening this link: https://docs.google.com/spreadsheets/d/1Jh4sbjFcvVvDg52YFKo4aMyk2TQboyATDvWGCVTgj3U then click on File → Make a copy. Rename your copy and ensure it's accessible.