Latenode
Rss.app
Google sheets

Automate Google News RSS URL decoding and spreadsheet sync

This Latenode automation extracts and decodes Google News RSS feeds, transforming the obfuscated article URLs into clean, shareable links. It solves the problem of processing Google News' encoded URLs, making it easier for users to analyze, share, and utilize news content.

The workflow retrieves Google News articles, decodes the URLs, and outputs a list of direct links that can be saved to a spreadsheet. This automation streamlines a manual task, allowing users to focus on content discovery and distribution rather than URL manipulation.

Updated Apr 2, 2026Est. run: 8sEst. cost: $0.0005
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 Google News RSS feed articles
  • Decodes obfuscated article URLs to clean links
  • Transforms encoded URLs into shareable direct links
  • Outputs a list of decodedArticle URLs in a spreadsheet
  • Enables users to analyze and distribute news content

How it works

1
Trigger

Fetch Google News RSS feed

The workflow starts by fetching the latest Google News RSS feed, which contains a list of recent news articles along with their obfuscated article URLs.

2
Logic

Extract decoding keys

Next, the workflow extracts the necessary decoding keys from the HTML of the Google News website. These keys are required to decode the obfuscated article URLs.

3
Logic

Decode article URLs

Using the extracted decoding keys, the workflow decodes the obfuscated article URLs from the RSS feed, transforming them into clean, shareable direct links.

4
Action

Save clean URLs to spreadsheet

Finally, the workflow writes the decoded article URLs to a Google Sheets spreadsheet, making them easily accessible for further analysis, sharing, or utilization.

Setup guide

1

Add Google News RSS Feed

1. Add a Google News RSS node to your workflow. 2. In the node settings, configure the Google News RSS feed parameters such as language and country.

2

Add Google Sheets Node

1. Add a Google Sheets node to your workflow. 2. In the node settings, configure the Google Sheets credentials and select the spreadsheet and worksheet where you want to save the decoded news article URLs.

3

Add JavaScript node for URL Decoding

1. Add a JavaScript node to your workflow. 2. In the node settings, implement the logic to decode the encoded Google News article URLs. You can use the Latenode JavaScript node to fetch the necessary decoding keys from the HTML content and then call the Google decoding URL with the extracted variables.

4

Map Fields in Nodes

1. In the Google News RSS node, map the encoded article URLs to the appropriate input field in the JavaScript node. 2. In the JavaScript node, map the decoded article URLs to the appropriate output field in the Google Sheets node.

5

Test the Workflow

1. Click the 'Test workflow' button to run the automation and verify that the decoded news article URLs are successfully saved to the Google Sheets spreadsheet.

Requirements

Connect to Google News RSS feeds to retrieve article data
Implement URL decoding logic to extract original article URLs from the Google News RSS feeds
Save the clean, decoded article URLs to a Google Sheets spreadsheet
Set up the Latenode headless browser node to automate the URL extraction and decoding process

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 new Notion items to Google Docs documents

This Latenode automation template allows you to automatically create a new Google Docs document whenever a new item is added to a Notion database. This streamlines your workflow, ensuring that your important information is easily accessible across both platforms. The integration works by detecting new items in your Notion database and then creating a corresponding document in a specified Google Docs folder, with the content from the Notion item copied over. This saves time and keeps your documentation organized, allowing you to focus on more strategic priorities.

8s$0.0005
Data, spreadsheets & databases

Automatically create Google Docs from new Google Forms submissions

This Latenode automation template creates a Google Doc based on a pre-defined template, using data from new submissions in a linked Google Forms spreadsheet. Whenever a new response is added or an existing one is updated in the spreadsheet, the integration automatically generates a corresponding Google Doc, eliminating the need for manual copy-pasting. This saves time and ensures that all form responses are captured in a document format for further processing. The key integrations involved are Google Forms and Google Docs, with the Google Forms spreadsheet serving as the data source and the generated Google Docs as the output.

7s$0.0004
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