I’m officially obsessed with Google Spreadsheet.
To say that I was surprised would be an understatement.
Here’s a clear example of the ImportFeed function put to use.
“false” says that column headers are not required
3.
“20” tells the function to bring in the maximum 20 items from the feed.
So just keep that in mind as you’re building your custom reader.
Now, on each subsequent sheet, create a header for the information.
There are special commands that you’ll use in the ImportFeed function to pull in feed information.
These are prefaced with “feed”.
you could ask for the feed title, author, description, and URL.
To pull feed items, you will use the keyword “items” in the function.
Your first feed page is done!
Repeat the above process over for each new sheet, and just reference the ImportFeed column for that feed.
Here’s what the bottom sheet tabs should look like.
Each subsequent “Feed #” tab contains all of the feed data from each URL.
