Latenode
Google sheets

Automate Google News article link extraction and decoding

This Latenode automation simplifies the process of extracting and cleaning Google News article URLs from RSS feeds. It automates the complex task of decoding the encoded URLs, which often contain timestamp and signature information, making the clean, usable links available for downstream applications.

The workflow is particularly valuable for developers, journalists, and content aggregators who need to work with Google News data, as it eliminates the manual effort required to transform the RSS feed into a format that can be easily integrated into their systems. The automation leverages the n8n platform to orchestrate the process, which includes reading the RSS feed, limiting the number of items, calling the Google URL decoding API, and aggregating the results into a structured format.

Updated Apr 6, 2026Est. run: 25sEst. cost: $0
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Data, spreadsheets & databases

Workflow preview

What this template does

  • Extracts article URLs from Google News RSS feeds
  • Decodes the encoded URLs to obtain the original direct links
  • Saves the clean, usable article URLs to a Google Sheets spreadsheet
  • Limits the number of items extracted from the RSS feed
  • Utilizes the n8n platform to orchestrate the entire automation process

How it works

1
Trigger

Fetch the latest Google News articles

The workflow starts by reading the Google News RSS feed to fetch the latest articles. This is the trigger step that initiates the automation.

2
Logic

Limit to the 5 most recent articles

The workflow then limits the number of RSS feed items to the latest 5 articles. This helps optimize performance and focus on the most recent content.

3
Action

Extract the encoded Google News article URLs

For each of the 5 RSS feed items, the workflow extracts the encoded Google News article URLs. These URLs contain timestamp and signature information that needs to be decoded.

4
Action

Call the Google URL Decoding API

The workflow then calls the Google URL Decoding API to decode the encoded article URLs, removing the timestamp and signature information.

5
Action

Map the decoded URL fields

After receiving the decoded URLs from the API, the workflow extracts the required fields, such as the clean article URL, and maps them to a structured format.

6
Action

Store the cleaned Google News article URLs

Finally, the workflow stores the cleaned and usable Google News article URLs in a Google Sheet, making them available for downstream applications.

Setup guide

1

Add Google News RSS feed URL

1. In the Latenode visual builder, add a 'RSS Feed Read' node. 2. In the node settings, configure the RSS feed URL to your Google News feed.

2

Add Google URL Decoding API credential

1. In the Latenode Credentials panel, add a new HTTP API credential. 2. Enter the API key or other required credentials for the Google URL Decoding API.

3

Configure URL decoding in the workflow

1. Add an 'HTTP Request' node after the RSS Feed Read node. 2. In the node settings, use the Google URL Decoding API credential you added earlier. 3. Map the required input fields, such as the encoded URL, signature, and timestamp, based on the data from the RSS Feed Read node.

4

Add Google Sheets output

1. Add a 'Google Sheets' node at the end of the workflow. 2. In the node settings, select the Google Sheets spreadsheet and worksheet where you want to save the cleaned article URLs.

5

Test the workflow

1. In the Latenode visual builder, click the 'Test' button to run the workflow. 2. Verify that the Google News article URLs are successfully extracted, decoded, and saved to the specified Google Sheets spreadsheet.

Requirements

Apify account with API key to access the URL decoding service
Google Sheets account and spreadsheet to store the extracted and decoded article URLs
Access to the Google News RSS feed URLs to be processed
Latenode workspace with the following nodes configured: HTTP Request, Google Sheets, and any necessary data transformation nodes

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Data, spreadsheets & databases

Automatically sync Notion items to new Google Docs documents

This automation allows users to automatically create a new Google Docs document whenever a new item is added to a Notion database. It streamlines the process of transferring data from Notion to Google Docs, making it easier for teams to collaborate on documents and reports. The automation triggers when a new item is added to the specified Notion database, and it then creates a corresponding Google Docs document with the relevant information. This integration between Notion and Google Docs helps users to centralize their data and workflows, improving productivity and efficiency.

26s$0.0703
Data, spreadsheets & databases

Automatically generate customized Google Docs from new form data

This automation allows users to create a new Google Doc based on a predefined template, using data from a new submission in a linked Google Form. Whenever a new row is added to the associated Google Sheets spreadsheet, the automation will trigger and generate a personalized document using the form data. This streamlines the process of creating documents from structured data, making it more efficient for individuals or teams working with Google's productivity suite. The primary systems involved are Google Forms, Google Sheets, and Google Docs.

26s$0.0703
Data, spreadsheets & databases

Automatically notify via Burst SMS when new rows added to Google Sheets

This Latenode automation allows users to stay focused on their primary workflows by automatically sending SMS messages through the Burst SMS platform whenever a new row is added to a specified Google Sheets spreadsheet. It connects the Google Sheets data source to the Burst SMS service, streamlining the notification process. Users can configure the specific spreadsheet and mobile number to receive the SMS updates, helping them stay informed without getting distracted from their main tasks.

7s$0.0004