Extract Google Trends Keywords & Summarize Articles in Google Sheets
    100%
    Automation
    0(0 reviews)
    1869 downloads

    Extract Google Trends Keywords & Summarize Articles in Google Sheets

    NM

    Curated by n8n Markets team

    Last updated: March 8, 2026

    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") | | `trending_keyword` | Trending keyword extracted from Google Trends | | `approx_traffic` | Estimated traffic for the trending keyword | | `pubDate` | Date when the keyword was fetched | | `news_item_url1` | URL of the first related news article | | `news_item_title1` | Title of the first news article | | `news_item_url2` | URL of the second related news article | | `news_item_title2` | Title of the second news article | | `news_item_url3` | URL of the third related news article | | `news_item_title3` | Title of the third news article | | `news_item_picture1` | Image URL from the first news article | | `news_item_source1` | Source of the first news article | | `news_item_picture2` | Image URL from the second news article | | `news_item_source2` | Source of the second news article | | `news_item_picture3` | Image URL from the third news article | | `news_item_source3` | 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.

    What's Included

    • Complete n8n workflow template with 0 nodes. Ready to import and customize.

    Requirements

    n8n instance (self-hosted or cloud). credentials.

    How to Use

    1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation

    Apps in this n8n workflow

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0++
    • Setup time: 5-15 min

    Included in Builder Pro — $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Mar 2026
    v1.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Dependencies & Requirements

    Google Sheets
    Data

    ⚠️ 1 service require credentials. Make sure you have accounts set up before importing.

    Reviews

    0

    No reviews yet

    See all 0 reviews ↓
    —

    0 reviews

    5★
    0
    4★
    0
    3★
    0
    2★
    0
    1★
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought