Extract Google Trends Keywords and Summarize Articles in Google Sheets

🔥 Stay ahead with automated Google Trends insights!

This automation fetches trending keywords from Google Trends, pulls related articles, summarizes them using AI, and neatly stores everything in Google Sheets — giving you a clear snapshot of what’s hot right now.

Perfect for content creators, marketers, and researchers who want fast, actionable trend analysis without lifting a finger.

What it does:

📈 Retrieves trending keywords via Google Trends RSS
📰 Fetches 3 related articles per keyword
🧹 Cleans HTML and summarizes each article with Jina AI
🗂️ Saves keyword + summary into Google Sheets
📊 Keeps your trends dashboard up to date automatically

✅ Simple setup with Google Sheets and API access

Need help setting it up? We offer full configuration and testing for a one-time fee.