Extract Google Trends keywords & summarize articles in Google Sheets
n8n15 modulesv1.0Stay ahead of trends by automating your content research. This workflow fetches trending keywords from Google Trends RSS, extracts key insights from top articles, and saves structured summaries in Google Sheets—helping you build a data-driven editorial plan effortlessly. How it works 1. Fetch Google Trends RSS – The workflow retrieves trending keywords along with three related article links. 2. Extract & Process Content – It fetches the content of these articles, cleans the HTML, and generate
At a glance
Extract Google Trends keywords & summarize articles in Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, WordPress. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, WordPress
- Modules
- 15
- Price
- Free
- Version
- v1.0
About this workflow
Stay ahead of trends by automating your content research. This workflow fetches trending keywords from Google Trends RSS, extracts key insights from top articles, and saves structured summaries in Google Sheets—helping you build a data-driven editorial plan effortlessly. How it works 1. Fetch Google Trends RSS – The workflow retrieves trending keywords along with three related article links. 2. Extract & Process Content – It fetches the content of these articles, cleans the HTML, and generates a concise summary using Jina AI. 3. Store in Google Sheets – The processed insights, including the trending keyword and summary, are saved in a pre-configured Google Sheet. Setup Steps 1. Prepare a Google Sheet – Ensure you have a Google Sheet ready to store the extracted data. 2. Configure API Access – Set up Google Sheets API and any required authentication. 3. Get Jina.ai API key 4. Adjust Workflow Settings – A dedicated configuration node allows you to fine-tune how data is processed and stored. Customization - Modify the RSS source to focus on specific Google Trends regions or categories. - Adjust the content processing logic to refine how article summaries are created. - Expand the workflow to integrate with CMS (e.g., WordPress) for automated content planning. This workflow is ideal for content strategists, SEO professionals, and news publishers who want to quickly identify and act on trending topics without manual research. 🚀 Google Sheets Fields Copy and paste these column headers into your Google Sheet: | Column Name | Description | |------------------------|-------------| | status | Initial status of the keyword (e.g., "idea") | | trendingkeyword | Trending keyword extracted from Google Trends | | approxtraffic | Estimated traffic for the trending keyword | | pubDate | Date when the keyword was fetched | | newsitemurl1 | URL of the first related news article | | newsitemtitle1 | Title of the first news article | | newsitemurl2 | URL of the second related news article | | newsitemtitle2 | Title of the second news article | | newsitemurl3 | URL of the third related news article | | newsitemtitle3 | Title of the third news article | | newsitempicture1 | Image URL from the first news article | | newsitemsource1 | Source of the first news article | | newsitempicture2 | Image URL from the second news article | | newsitemsource2 | Source of the second news article | | newsitempicture3 | Image URL from the third news article | | newsitemsource3 | Source of the third news article | | abstract | AI-generated summary of the articles (limited to 49,999 characters) | Instructions 1. Open Google Sheets and create a new spreadsheet. 2. Copy the column names from the table above. 3. Paste them into the first row of your Google Sheet.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Watch and update Google Sheets rows automatically with Make integrations
Generate a barcode from data in Google Sheets rows using PDF.co and save it to Dropbox
Share city-specific Google Analytics reports to Google Sheets and Slack
Send WhatsApp order review request from Google Sheets
Send a Telegram message and add a row in Google Sheets for new Facebook Lead Ads submissions
Automated template delivery system with Stripe, GPT-4o & Gmail
AI Facebook ad spy tool with Apify, OpenAI, Gemini & Google Sheets
Generate AI videos and carousels with Blotato for Instagram and TikTok
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you