Turning The Google Docs Into An RSS Reader How To Use a Spreadsheet in Google Docs as an RSS Feed Reader.
This explanation shows how to use the spreadsheet in Google Docs as an RSS Feed reader.From different sources into spreadsheet we can fetch RSS news feeds like simpler version of Feedly and we can publish our feeds as a public web page.Coding is not Required.
If we have any website we can use the trick RSS feeds in web pages.The Google docs will prefer the Flash/ Javascript widgets because here we have the complete control over layout and the embedded content will show up on mobile devices also.
Let us see the Example.Here their is a live Google spreadsheet that aggregates news feeds from some top technology blogs. As new items are added on this sites, they will automatically show up in the embedded page.
FeedImport - Fetching RSS Feeds in Google Drive
Here in this example we are putting RSS feeds into Google Doc's and we are using single RSS feed in this example but in spreadsheet we can have dozens of RSS feeds.
Type the RSS feed URL in cell A1 in Google Spreadsheet.
In cell A2, type =ImportFeed(A1, “items title”, FALSE, 10) – This formula will fill column A with the titles of the latest 10 stories in that feed. Make sure that the second parameter – items title – is in lower case.
In cell B2, type =ImportFeed(A1, “items url”, FALSE, 10) – This will fill column B with the URL (permalink) of the corresponding stories in column A.
In cell C2, type =HyperLink(B2, A2) – This will combine the title and URL to make a clickable hyperlink in the spreadsheet.
Copy the same formula that you entered into Cell C2 into cells C3 until C11.
With Google Docs Embed the RSS Feeds into Web Pages
As we are using the regular Spreadsheet, we can change the fonts, colors and other formatting go to publish to Embed the feed in Web page -> In the Google Spreadsheets menu,for more publishing options select C2:C13 as the range and get the HTML embed code.
When the Underlying RSS feeds are changed Google Docs will automatically refresh the content.
Google Spreadsheet will also support ImportHTML,related formula that will helps you to import HTML tables from any public web page into your spreadsheet.
This explanation shows how to use the spreadsheet in Google Docs as an RSS Feed reader.From different sources into spreadsheet we can fetch RSS news feeds like simpler version of Feedly and we can publish our feeds as a public web page.Coding is not Required.
If we have any website we can use the trick RSS feeds in web pages.The Google docs will prefer the Flash/ Javascript widgets because here we have the complete control over layout and the embedded content will show up on mobile devices also.
Let us see the Example.Here their is a live Google spreadsheet that aggregates news feeds from some top technology blogs. As new items are added on this sites, they will automatically show up in the embedded page.
FeedImport - Fetching RSS Feeds in Google Drive
Here in this example we are putting RSS feeds into Google Doc's and we are using single RSS feed in this example but in spreadsheet we can have dozens of RSS feeds.
Type the RSS feed URL in cell A1 in Google Spreadsheet.
In cell A2, type =ImportFeed(A1, “items title”, FALSE, 10) – This formula will fill column A with the titles of the latest 10 stories in that feed. Make sure that the second parameter – items title – is in lower case.
In cell B2, type =ImportFeed(A1, “items url”, FALSE, 10) – This will fill column B with the URL (permalink) of the corresponding stories in column A.
In cell C2, type =HyperLink(B2, A2) – This will combine the title and URL to make a clickable hyperlink in the spreadsheet.
Copy the same formula that you entered into Cell C2 into cells C3 until C11.
With Google Docs Embed the RSS Feeds into Web Pages
As we are using the regular Spreadsheet, we can change the fonts, colors and other formatting go to publish to Embed the feed in Web page -> In the Google Spreadsheets menu,for more publishing options select C2:C13 as the range and get the HTML embed code.
When the Underlying RSS feeds are changed Google Docs will automatically refresh the content.
Google Spreadsheet will also support ImportHTML,related formula that will helps you to import HTML tables from any public web page into your spreadsheet.
Post a Comment