{"id":16533,"date":"2024-12-08T00:30:00","date_gmt":"2024-12-07T15:30:00","guid":{"rendered":"https:\/\/84office.jp\/?p=16533"},"modified":"2024-12-08T00:31:37","modified_gmt":"2024-12-07T15:31:37","slug":"gas-google-news-get","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/gas-google-news-get\/","title":{"rendered":"Automate News Collection with Google Apps Script: Fetch Daily Updates from Google News to Google Sheets"},"content":{"rendered":"
<\/div>\n

Do you want to organize your daily news information but find it time consuming to gather information?<\/p>\n\n\n\n

It is also time-consuming to manually visit news sites.<\/p>\n\n\n\n

So, in this article, we will show you how to use Google Apps Script to get Google News information into a spreadsheet.<\/p>\n\n\n\n

Google News is a collection of articles from a variety of news sites, allowing for a broad collection of information.<\/p>\n\n\n\n

This script allows you to easily manage your news without having to check multiple news sites.<\/p>\n\n\n\n

You can retrieve by country or category, or filter by specific keywords.<\/p>\n\n\n\n

Completed image<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Retrieved from Google News

Column A: News title
Column B: Link
Column C: Publication date<\/p>\n\n\n\n

Specify the country, category, and keywords in the spreadsheet, and news information retrieved using Google News RSS will be displayed.<\/p>\n\n\n\n

About Google News RSS<\/h2>\n\n\n\n

Google News RSS is a feature that allows you to retrieve the latest news articles provided by Google News in feed format, by specific topic or country.<\/p>\n\n\n\n

The feed format is a system that automatically distributes updates to news sites, blogs, and other websites when they are updated.<\/p>\n\n\n\n

This allows you to efficiently receive new articles without having to manually visit each news site.<\/p>\n\n\n\n

RSS (Really Simple Syndication) is an example of this feed format, which can be used to receive news of interest in bulk or linked to other tools such as spreadsheets to make information more manageable.<\/p>\n\n\n\n

Procedure<\/h2>\n\n\n\n

Preparing Spreadsheets<\/h3>\n\n\n\n
\n
STEP<\/span><\/div>
Open Spreadsheet<\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

Set the sheet name to \u201cNews<\/strong>\u201d.<\/p>\n\n\n\n

The name of this sheet is referenced when the script is executed.<\/p>\n<\/div><\/div>\n\n\n\n

STEP<\/span><\/div>
Enter fields in the spreadsheet<\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

Enter the following field names in the spreadsheet<\/p>\n\n\n\n

Field Name<\/th><\/tr><\/thead>
A1<\/td>Country<\/td><\/tr>
A2<\/td>Category<\/td><\/tr>
A3<\/td>Keyword<\/td><\/tr>
A5<\/td>Title<\/td><\/tr>
B5<\/td>Link<\/td><\/tr>
C5<\/td>Publication Date<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div>\n\n\n\n
STEP<\/span><\/div>
Enter conditions in spreadsheet<\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

Next, enter the news conditions you wish to retrieve.<\/p>\n\n\n\n

Condition Input<\/th><\/tr><\/thead>
B1<\/td>Country code such as US, JP, etc.<\/td><\/tr>
B2<\/td>Business, Technology, etc.<\/td><\/tr>
B3<\/td>Specific Keyword<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

If no keywords are specified, news is retrieved by country and category only.<\/p>\n\n\n\n

The countries and categories that can be retrieved with this script are as follows<\/p>\n\n\n\n

Countries and categories that can be specified<\/strong><\/p>\n\n\n\n

Country<\/span><\/span><\/div>
\n