This template watches a Google News RSS feed and, when a new RSS item arrives, reads the wrapped article URL, decodes it to the publisher link with an HTTP request and JavaScript, and appends title, source, and clean URL to Google Sheets. Paste the Google News feed URL on the RSS trigger. Connect Google Sheets. Put any decode headers you need on that HTTP request node.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. 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 CPU seconds work →Workflow preview
The scenario starts when a new RSS item arrives from the Google News feed URL you watch.
JavaScript takes the Google News article link from the item.
An HTTP request follows or decodes that wrapped link. JavaScript returns the clean publisher URL.
Google Sheets gets a row with title, source, and the decoded URL.
Add an RSS trigger and paste your Google News feed URL. The scenario runs when a new RSS item arrives.
Add a Google Sheets connection. Use a sheet with columns for title, source, decoded URL, and published time.
In JavaScript, read the wrapped Google News link from the item. Send an HTTP request that follows or decodes it, then return the publisher URL. Put any request headers on that HTTP request node.
Append title, source, decoded URL, and published time. Publish a test headline in a feed you control, or wait for a new Google News item, and confirm the row.
FAQ
More templates
This template watches a Notion database for new pages, reads the title and properties, and creates a Google Doc from that text. Use it when a database row should become a shareable document. Connect Notion and Google Docs, then point the trigger at the database you want to watch.
This template starts on a new Google Form response, then creates a Google Doc from the template you pick and replaces placeholders with the answers. Use it for intake letters, briefs, or certificates that should match each submission. Connect Google Forms and Google Docs, then point the trigger at the form and the Docs step at the template.
This template receives Kartra calendar bookings on a Latenode webhook, maps name, email, and slot time in JavaScript, and appends a row in Google Sheets. Paste the webhook URL into Kartra. If the payload is only an id, use that JavaScript node to call the Kartra API and put the Kartra API key in that node. Connect Google Sheets and point add-row at the spreadsheet that stores leads.
