Integrate Google News into Google Sheets with OS_GOOGLE_NEWS

Introduction

If you're seeking a swift solution to integrate Google News into Google Sheets, you're in the right place. The custom function OS_GOOGLE_NEWS allows effortless importing of the most recent RSS feeds from Google News for any news, regardless of the country. Furthermore, you can customize the results by specifying the desired number of posts or the publication date range.

Installation

Install from Google Workspace Marketplace

YouTube

If you're more of a visual learner, watch this video for step-by-step instructions. While you're there, consider subscribing to my channel for future updates and content.

Demo Use Case

In this demonstration, we are retrieving the most recent news articles related to "Google Workspace" within the United States over the past seven days.

Example

OS_GOOGLE_NEWS("Google Workspace", "US", "1d", TRUE)

About

Import the latest Google News.

---

query

The query for the news from Google.

country

The country of the search results, default to "US".

filter

Use number for posts e.g. 3, number + "d" for publication date e.g. "1d", default to "1d".

include_headers

Whether to include column headers as an extra row on top of the returned value, default to TRUE.

OneScript Custom Functions (Follow for More Updates)

Links

Hire Me on Upwork Donate YouTube Github Twitter / X Instagram Upwork Projects