If you’d like these headers to appear in the top row, you can change the formula into =IMPORTFEED(“”, “items”, TRUE). For instance, if you type =IMPORTFEED(“”), Google Sheets will pull the latest twenty items, and put them in a table.Įvery item (or article) of the pulled feed is translated into a row consisting of a title, author, url, publish date and time, and summary. Google Sheets has a nifty little function called =IMPORTFEED, which allows you to pull the latest content items – blog posts, news articles – from online publications using their RSS or XML feed URL. Today, we have a welcome surprise for all the news junkies among the Google Sheets nerds. In our Holy Sheet article series, we’re 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.
0 Comments
Leave a Reply. |