In this example, I'm making a feed reader that pulls in 10 feeds, so this main form will have a list of 10 feed URLs, and the next column contains the number of items that I want to pull in from each feed. For starters, create a "home" sheet that contains all of the feeds that you want to pull into your new personal feed reader. Now that you know the basic format of the function, I'm going to go over the variety of ways you can use the function to bring in different data from any feed. "20" tells the function to bring in the maximum 20 items from the feed. "false" says that column headers are not requiredģ. The "items title" is telling it to access a list of the article titles from the "items" list,Ģ. It helps you preview any site’s RSS digest + find alternative news/feed sources for a wider range of media opportunities and choices it also features a few important analytical and safe browsing options to make sure you can keep abreast of reputation, availability, and attitudes of every site/source you might subscribe to. What you're doing with the above function is asking Google Spreadsheet to access feed information from the MUO feedburner feed.ġ. Here's a clear example of the ImportFeed function put to use. The explanation provided for the function is given in a long rambling paragraph that isn't entirely clear, so I'm going to attempt to make it a little more clear. The example that Google Help provides, looks like this: So, with that motivation in mind, let me show you how I pieced together my very own home-grown feed reader, and how you can too.Ĭreate a Feed Reader in Google Spreadsheetīefore you can create a feed reader using Google Spreadsheet, it's important to understand the syntax. However, I figure if I can create a stream of my favorite websites and news sources right inside Google Spreadsheet - where I go every single day anyway - then it'll be far more likely that I'll actually check out the feeds and read some of the updates. ![]() I've tried various feed readers through the years, but I've honestly never been able to settle on one that I want to use every single day. So, looking for a more practical, everyday use for my growing collection of Google spreadsheets, I decided to see if I could use one function I haven't covered here at MUO yet called "ImportFeed", to try and develop a personal DIY feeder reader that I could actually make use of every day - rather than installing some desktop application, or visiting some online feed reader service. Sure, that's a lot of stuff, but I've really only scratched the surface of what you can accomplish with a little bit of elbow grease and a bit of creativity using one of Google's greatest offerings - in my humble opinion. A simple and best method for staying informed of your most recent RSS feeds - Search for Feeds - Instantaneously notifies when a new RSS feed. ![]() If you've followed the recent articles I've written about it, then you know that I've used it to create some really cool reports and charts, I've discovered some ultra-useful functions tucked away in the Google Spreadsheet toolbox, and I've even used it to import UFO sightings information from around the Internet. Feedo - The best RSS Feed Reader extension for Chrome.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |