Extract Google Trends Keywords & Summarize Articles in Google Sheets

This n8n workflow revolutionizes content research by fetching the latest trending keywords directly from Google Trends RSS feeds, which include three related article links per keyword. It then intelligently processes these articles by scraping their content, cleaning HTML, and generating concise summaries using Jina AI's advanced capabilities. Finally, it appends the keyword, article insights, and summaries into a pre-configured Google Sheets document, creating a centralized repository for trends and ideas.

The benefits are immense for time-strapped professionals: eliminate manual browsing of Trends and articles, gain AI-powered insights instantly, and build data-driven editorial calendars without effort. It's particularly valuable for scaling content production, as it handles multiple trends in one run and supports customization for regions or categories.

Ideal use cases include SEO specialists monitoring search spikes, content strategists planning viral topics, marketers spotting consumer interests, and news publishers automating trend coverage. Customize by tweaking RSS sources, summary lengths, or extending to CMS integrations like WordPress for fully automated publishing pipelines.