Miko
Workflows by Miko
Extract and decode Google News RSS URLs to clean article links
The workflow performs tasks that would normally require human intervention on Google News links, transforming the RSS feeds into data that can be used by an automated system like n8n, thus creating a solid foundation for further applications ## Who is this for? This workflow is ideal for developers, journalists, and content aggregators who need to extract and clean Google News URLs from its RSS feed. **What problem does this workflow solve?** Google News RSS provides encoded URLs that contain additional tracking parameters. This workflow decodes those URLs and provides clean, direct links to news articles, making them easier to process, share, and analyze. **What this workflow does** 1. **Fetch Google News RSS** – Retrieves news articles from Google News based on predefined parameters (language, country). 2. **Limit results** – Reduces the number of requests to avoid excessive API usage. 3. **Extract encoded content** – Retrieves the encoded news URLs. 4. **Decode the URLs** – Uses a decoding mechanism to extract clean links. 5. **Remove unwanted characters** – Cleans up the decoded URLs to ensure they are properly formatted. 6. **Aggregate results** – Outputs a final list of clean, readable URLs. ## Setup + Modify RSS parameters (hl, gl) to match your target region. + Adjust the result limit to control the number of processed articles. ## How to customize this workflow + To customize this workflow, you can add an HTTP Request node to retrieve the article's text, an HTML Extract node to process the text, an AI node to generate new content, and a WordPress node to publish it + Another option is to use an AI Agent node to classify articles by category based on the title or through HTML Extract. You can then save the classified articles using a Google Sheets node, organizing them by category and creating an high quality editorial plan This workflow efficiently processes Google News RSS, removes unnecessary encoding, and delivers clean, shareable URLs. 🚀
Extract Google Trends keywords & summarize articles in Google Sheets
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.