{"id":22426,"date":"2025-07-19T23:17:25","date_gmt":"2025-07-19T14:17:25","guid":{"rendered":"https:\/\/84office.jp\/?p=22426"},"modified":"2025-07-19T23:17:26","modified_gmt":"2025-07-19T14:17:26","slug":"google-news-template","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/google-news-template\/","title":{"rendered":"Google News Fetch Template: Streamline Information Gathering with Google Apps Script and Google Sheets"},"content":{"rendered":"
[Contact Us Here<\/a>]<\/div>\n

The template introduced in this article is a paid product.<\/p>\n\n\n\n

In a previous article, \u201cAutomate News Collection with Google Apps Script: Fetch Daily Updates from Google News to Google Sheets<\/a>,\u201d I explained how to automatically gather news using Google Apps Script .<\/p>\n\n\n\n

Based on that content, I have now prepared a ready-to-use template that anyone can use right away.<\/p>\n\n\n\n

The necessary Apps Script code is already included\u2014just enter your required information, and you can instantly start collecting news updates.<\/p>\n\n\n\n

This template allows you to efficiently gather information without any hassle.<\/p>\n\n\n\n

With this tool, even on your busiest days, you can easily keep up with the latest news.<\/p>\n\n\n\n

If you\u2019d like to jump straight to the template, you can go directly to the download section here.<\/p>\n\n\n\n

Features of the Template<\/a><\/p>\n\n\n\n

Features of the Template<\/strong><\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n
    \n
  • Ready to use with pre-written Apps Script<\/strong><\/li>\n\n\n\n
  • Easily select country code and section (category) from dropdown menus<\/strong><\/li>\n\n\n\n
  • Instantly fetch news with a simple \u201cFetch News\u201d button<\/strong><\/li>\n<\/ul>\n\n\n\n

    With this template, you can display the latest updates on specified topics from Google News in a Google Sheet.<\/p>\n\n\n\n

    The following three items can be retrieved:<\/p>\n\n\n\n

      \n
    • Title<\/strong><\/li>\n\n\n\n
    • Link<\/strong><\/li>\n\n\n\n
    • Publication Date<\/strong><\/li>\n<\/ul>\n\n\n\n

      You can collect news from major media sources featured on Google News, such as BBC, CNN, Reuters, The New York Times, Bloomberg<\/strong>, and many others.<\/p>\n\n\n\n

      How to Use the Template<\/span><\/span><\/div>
      \n\n\n\n\n
      \n
      <\/span>STEP<\/span><\/div>
      Enter values in cells B1 to B3<\/div>
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      On the \u201cNews\u201d sheet, enter the following information in cells B1 to B3:<\/p>\n\n\n\n

      Cell<\/th>Input<\/th><\/tr><\/thead>
      B1<\/td>Country code (e.g., US)<\/td><\/tr>
      B2<\/td>Category (e.g., Business, Technology)<\/td><\/tr>
      B3<\/td>Specific keyword (optional)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n\n\n\n\n\n<\/div><\/div>\n\n\n\n
      <\/span>STEP<\/span><\/div>
      Click the Execute Button<\/div>
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      When you click the \u201cFetch News\u201d button, the Apps Script will run.<\/p>\n\n\n\n

      \n

      If you’re running the script for the first time, you need to authorize it.<\/p>\n\n\n\n

      Therefore, press “Review Permissions.<\/strong>“<\/strong><\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n
      \n
      Detailed Authorization Steps<\/span><\/i><\/i><\/span><\/summary>
      \n

      Press “Advanced.”<\/strong><\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n\n\n\n\n

      Press “Go to Untitled project (Unsafe).”<\/strong><\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      After that, press “Allow.”<\/strong><\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n\n<\/div><\/details>\n<\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n
      <\/span>STEP<\/span><\/div>
      News Retrieval Complete<\/div>
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      The news articles will be listed from row 6 onwards.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n\n<\/div><\/div>\n\n\n\n

      Note: Triggers Are Not Copied Automatically<\/strong><\/h2>\n\n\n\n

      When you copy the spreadsheet, automatic triggers (for scheduled execution) will not be carried over.<\/p>\n\n\n\n

      If you want the script to run automatically at a set time each morning, you will need to set up the trigger manually.<\/p>\n\n\n\n

      (If you use the \u201cFetch News\u201d button, you do not need to set up a trigger.)<\/em><\/p>\n\n\n\n

      \n
      How to Set Up a Trigger<\/strong><\/span><\/i><\/i><\/span><\/summary>
      \n
      \n
      STEP<\/span><\/div>
      Open Apps Script Editor<\/div>
      \n\n\n\n
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      Open a Google Spreadsheet and click on \u201cExtensions<\/strong>\u201d in the menu, then \u201cApps Script<\/strong>\u201d to open the Apps Script editor.<\/p>\n<\/div><\/div>\n\n\n\n

      STEP<\/span><\/div>
      Click the Trigger (Clock) Icon<\/strong><\/div>
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      Click the trigger icon (clock symbol) in the Apps Script editor.<\/p>\n<\/div><\/div>\n\n\n\n

      STEP<\/span><\/div>
      Add a New Trigger<\/strong><\/div>
      \n
      \"\"<\/figure>\n<\/div>\n\n\n

      Click the \u201cAdd Trigger\u201d button and configure the following settings:<\/p>\n\n\n

      \n
      \"\"<\/figure>\n<\/div>\n\n\n
        \n
      • Select function to run<\/strong>: fetchGoogleNewsByCountryAndSection<\/code><\/li>\n\n\n\n
      • Select deployment<\/strong>: Head<\/code><\/li>\n\n\n\n
      • Select event source:<\/strong> \u201cTime-driven\u201d<\/li>\n\n\n\n
      • Select type of time-based trigger:<\/strong> \u201cDay timer\u201d<\/li>\n\n\n\n
      • Choose time:<\/strong> For example, set it to \u201cEvery day at 9:00 AM\u201d to automatically fetch news every morning.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n<\/div><\/details>\n<\/div>\n\n\n\n

        Examples of Media Outlets Available<\/h2>\n\n\n\n

        Here are some examples of major media outlets featured on Google News:<\/p>\n\n\n\n

          \n
        1. BBC News<\/li>\n\n\n\n
        2. CNN<\/li>\n\n\n\n
        3. Reuters<\/li>\n\n\n\n
        4. The New York Times<\/li>\n\n\n\n
        5. The Guardian<\/li>\n\n\n\n
        6. Bloomberg<\/li>\n\n\n\n
        7. Forbes<\/li>\n\n\n\n
        8. The Wall Street Journal<\/li>\n\n\n\n
        9. CNBC<\/li>\n\n\n\n
        10. Financial Times<\/li>\n\n\n\n
        11. Associated Press (AP)<\/li>\n\n\n\n
        12. Al Jazeera English<\/li>\n\n\n\n
        13. NPR<\/li>\n\n\n\n
        14. USA Today<\/li>\n\n\n\n
        15. Politico<\/li>\n\n\n\n
        16. TIME<\/li>\n\n\n\n
        17. The Washington Post<\/li>\n\n\n\n
        18. Yahoo News<\/li>\n<\/ol>\n\n\n\n

          The media outlets retrieved may vary depending on the structure of Google News.<\/em><\/p>\n\n\n\n

          Download the Template Here<\/h2>\n\n\n\n

          You can copy the completed template below (Google Sheets).<\/p>\n\n\n\n

          The script is already built in, so all you need to set are the \u201cCountry Code,\u201d \u201cCategory,\u201d and \u201cKeyword.\u201d It\u2019s simple and ready to use.<\/p>\n\n\n\n

          <\/div><\/div>","protected":false},"excerpt":{"rendered":"

          [Contact Us Here] The template introduced in this article is a paid product. In a previous article, \u201cAutomate […]<\/p>\n","protected":false},"author":1,"featured_media":22442,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=19161","footnotes":""},"categories":[12],"tags":[],"class_list":["post-22426","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=22426"}],"version-history":[{"count":4,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22426\/revisions"}],"predecessor-version":[{"id":22450,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/22426\/revisions\/22450"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/22442"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=22426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=22426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=22426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}