{"id":246419,"date":"2021-05-10T18:40:54","date_gmt":"2021-05-10T15:40:54","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-turn-google-sheets-into-an-rss-reader\/"},"modified":"2021-05-10T18:40:54","modified_gmt":"2021-05-10T15:40:54","slug":"how-to-turn-google-sheets-into-an-rss-reader","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-turn-google-sheets-into-an-rss-reader\/","title":{"rendered":"#How to turn Google Sheets into an RSS reader"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6af70c9ceb44b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6af70c9ceb44b\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-turn-google-sheets-into-an-rss-reader\/#Lets_first_start_with_the_basics%E2%80%A6\" >Let\u2019s first start with the basics\u2026<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-turn-google-sheets-into-an-rss-reader\/#Time_to_take_Google_Sheets_to_the_next_level\" >Time to take Google Sheets to the next level<\/a><\/li><\/ul><\/nav><\/div>\n<p>&#8220;<strong>#How to turn Google Sheets into an RSS reader<\/strong>&#8221;<\/p>\n<div><em>Welcome to TNW Basics, a collection of tips, guides, and advice on how to easily get the most out of your gadgets, <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>s, and other stuff.<\/em><\/p>\n<p>In our Holy Sheet article <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">series<\/a>, we\u2019re exploring all the things you can do with Google Sheets aside from simple number crunching, from tracking your stocks to scraping contact details from websites. Today, we have a welcome surprise for all the <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/news\/\" data-internallinksmanager029f6b8e52c=\"2\" title=\"News\" target=\"_blank\" rel=\"noopener\">news<\/a> junkies among the Google Sheets nerds.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lets_first_start_with_the_basics%E2%80%A6\"><\/span>Let\u2019s first start with the basics\u2026<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google Sheets has a nifty little function called =IMPORTFEED, which allows you to pull the latest content items\u00a0\u2013 blog posts, news articles\u00a0\u2013 from online publications using their RSS or XML\u00a0feed URL. For instance, if you type =IMPORTFEED(\u201chttps:\/\/thenextweb.com\/feed\u201d), Google Sheets will pull the latest twenty items, and put them in a table.<\/p>\n<figure class=\"post-image post-mediaBleed aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1350321 js-lazy\" alt=\"\" width=\"2474\" height=\"1172\" sizes=\"auto, (max-width: 2474px) 100vw, 2474px\" src=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14.png\" srcset=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14.png 2474w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-280x133.png 280w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-540x256.png 540w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-270x128.png 270w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-796x377.png 796w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-1592x754.png 1592w\"\/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1350321\" src=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14.png\" alt=\"\" width=\"2474\" height=\"1172\" srcset=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14.png 2474w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-280x133.png 280w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-540x256.png 540w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-270x128.png 270w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-796x377.png 796w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.09.14-1592x754.png 1592w\"\/><\/noscript><\/figure>\n<p>Every item (or article) of the pulled feed is translated into a row consisting of a title, author, url, publish date and time, and summary. If you\u2019d like these headers to appear in the top row, you can change the formula into =IMPORTFEED(\u201chttps:\/\/thenextweb.com\/feed\u201d, \u201citems\u201d, TRUE). And if you want less than twenty items to appear, simply add the number at the end: =IMPORTFEED(\u201chttps:\/\/thenextweb.com\/feed\u201d, \u201citems\u201d, TRUE, 10).<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Time_to_take_Google_Sheets_to_the_next_level\"><\/span>Time to take Google Sheets to the next level<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now that you know the basics of pulling RSS feed data into Google Sheets, let\u2019s see how we can mimic the workings of a proper RSS reader. An RSS reader typically allows for subscribing to the feeds of multiple online publications. Also, it <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/general\/\" data-internallinksmanager029f6b8e52c=\"3\" title=\"General\" target=\"_blank\" rel=\"noopener\">general<\/a>ly sorts the articles of all those different publications by publish date and time (with the newest item on top). So the different publications get merged into one big feed, sorted by date and time.<\/p>\n<p>I\u2019ve created a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1ySllkdlYx3kqmTKPB_MQl0tnL0NvpnSY5oHriEPa1qs\/edit?usp=sharing\">template<\/a> for you that does exactly that. On the first tab of the Google Sheets document called \u2018Manage subscriptions\u2019, you enter the names and RSS\/XML feed URLs of the publications you want to follow. The template is limited to 100 subscriptions.<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1ySllkdlYx3kqmTKPB_MQl0tnL0NvpnSY5oHriEPa1qs\/edit?usp=sharing\"><\/p>\n<figure class=\"post-image post-mediaBleed aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1350322 size-full js-lazy\" alt=\"\" width=\"1222\" height=\"472\" sizes=\"auto, (max-width: 1222px) 100vw, 1222px\" src=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39.png\" srcset=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39.png 1222w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39-280x108.png 280w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39-540x209.png 540w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39-270x104.png 270w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39-796x307.png 796w\"\/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1350322 size-full\" src=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39.png\" alt=\"\" width=\"1222\" height=\"472\" srcset=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39.png 1222w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39-280x108.png 280w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39-540x209.png 540w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39-270x104.png 270w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-16.21.39-796x307.png 796w\"\/><\/noscript><\/figure>\n<p><\/a><\/p>\n<p>That\u2019s all the work you need to do. In the other tab called \u2018Your feed\u2019, the 10 latest items of all those publications will be merged into one big feed.<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1ySllkdlYx3kqmTKPB_MQl0tnL0NvpnSY5oHriEPa1qs\/edit?usp=sharing\"><\/p>\n<figure class=\"post-image post-mediaBleed aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1350328 js-lazy\" alt=\"\" width=\"1640\" height=\"776\" sizes=\"auto, (max-width: 1640px) 100vw, 1640px\" src=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46.png\" srcset=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46.png 1640w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-280x132.png 280w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-540x256.png 540w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-270x128.png 270w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-796x377.png 796w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-1592x753.png 1592w\"\/><noscript><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1350328\" src=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46.png\" alt=\"\" width=\"1640\" height=\"776\" srcset=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46.png 1640w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-280x132.png 280w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-540x256.png 540w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-270x128.png 270w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-796x377.png 796w, https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2021\/05\/Screenshot-2021-05-10-at-17.29.46-1592x753.png 1592w\"\/><\/noscript><\/figure>\n<p><\/a><\/p>\n<p>To use the template, follow\u00a0<a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1ySllkdlYx3kqmTKPB_MQl0tnL0NvpnSY5oHriEPa1qs\/edit?usp=sharing\">this link<\/a>, head to the <em>File<\/em> menu, and hit <em>Make a copy<\/em>. A copy of the template is now on your own Google Drive account, and you can start changing the feeds to which you\u2019d like to be subscribed. Also, you can start looking into the inner workings of the template, by unhiding the \u2018worker\u2019 sheets, if you\u2019re really interested in or even want to change how it works. Simply head to <em>View<\/em> menu, and then to <em>Hidden sheets<\/em>.<\/p>\n<p>There you go, a simple RSS reader made with none other than Google Sheets. Happy reading (and tweaking)!<\/p>\n<\/div>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong>\n<\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/thenextweb.com\/news\/holy-sheet-how-to-turn-google-sheets-into-an-rss-reader\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to turn Google Sheets into an RSS reader&#8221; Welcome to TNW Basics, a collection of tips, guides, and advice on how to easily get the most out of your gadgets, apps, and other stuff. In our Holy Sheet article series, we\u2019re exploring all the things you can do with Google Sheets aside from simple&#8230;<\/p>\n","protected":false},"author":1,"featured_media":246420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/img-cdn.tnwcdn.com\/image\/tnw?filter_last=1&fit=1280,640&url=https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2020\/03\/sheets_formula.png&signature=0a93b4a008c02bd156fb2e231ee6efc1","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-246419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/246419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=246419"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/246419\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/246420"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=246419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=246419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=246419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}