Tuesday 16 May 2017

How to Turn Google Docs into an RSS Reader

This tutorial shows how to use a spreadsheet in Google Docs as an RSS Feed reader. You can fetch RSS news feeds from different sources into one spreadsheet – much like a simpler version of Feedly – and then publish your feeds as a public web page. No coding required.

If you have a website, you can use the same trick to embed RSS feeds in web pages. The Google Docs approach is preferred over Flash or Javascript widgets because here you have complete control over the layout and the embedded content will show up on mobile devices too.



IMPORTFEED – FETCH RSS FEEDS IN GOOGLE DRIVE

Here are the complete step involved for putting RSS feeds into Google Docs. We are using a single RSS feed in the following example but your spreadsheet can have dozens of RSS feeds.

1. Open a new Google spreadsheet and type the RSS feed URL in cell A1.

2. 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.

3. 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.

4. In cell C2, type =HyperLink(B2, A2) – This will combine the title and URL to make a clickable hyperlink in the spreadsheet.

5. Copy the same formula that you entered into Cell C2 into cells C3 until C11.

EMBED RSS FEEDS INTO WEB PAGES WITH GOOGLE DOCS

Since we are using a regular spreadsheet, you can change the fonts, colors and other formatting. To embed the feed in web page, go to to Publish – > More publishing options in the Google Spreadsheets menu, select C2:C13 as the range and get the HTML embed code.

Google Docs will automatically refresh content when the underlying RSS feeds are changed

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Labels

404 AdBlock Add-on Airtel GPRS Trick Airtel SMS Trick Alexa Amazon Amazon Kindle Amazon Prime Android Android 8 Android Oreo antivirus Apple Apple Mac ASCII Audacity Audio Authotkey Backup Balance Transfer in Vodafone Battery Bing Blogger Blogging Bookmarklet Browser Camera Chromebook clock Cloud colors command lines Computer Computer Tricks configuration Contact Creative Commons Credit Card CSS devolop DIY Doodle DOS Download Dropbox E-Mail eBook Email Email Attachment Embed Encryption English Error Evernote Eyes Facebook Facebook Tricks Feedburner Flipkart Font Foursquare Free Internet Free sms trick in Vodafone G Mail Gadget Game Getty Images GIF Gists Github Google Google AdSense Google Analytics Google Apps Google Chrome Google Contacts Google Currents Google DNS Google Docs Google Drive Google Earth Google Font Google Forms Google Images Google Map Google Photos Google Play Store Google Plus Google Print Google Reader Google Script Google Sheets Google Spreadsheet Google Translate GPRS Setting GPS Hacking Health App HelloFax Hindi Hoodie HTML Icons idea Image Editing Images IMEI Indian Railways Infographics Instagram Internet Internet Explorer Internet Tricks iOS iPad iPhone IRCTC iTunes iTV JavaScript JioCinema JioTV Junglee Kindle Language Translation Laptop Laptop. TV Life Time FREE GPRS Life-Style Link Linkedln Linux logo Make Money Online Microdoft Powerpoint Microdoft Word Microsoft Office Microsoft Outlook Mobile Mosaic Music Name Networking nexus Notepad OCR Online Shopping Open DNS OS Outlook Password PDF Petya Phillips Hue Lights Photogtraphy Pixel Play Station Podcasts Pokemon Pokemon Go Polls Print Productivity Proxy Server Pushbullet QR Code Ransomware Reddit Reliance Hack GPRS Reliance Jio RGB Ringtone Router RSS Safe Mode Samsung Galaxy S Scrabble Screen Capture Screen Sharing Screencast Secrets Security Send free sms from PC SEO Sierra Skype Slideshare SMBv1 SMS Snapchat Snapdeal Social Media Solution Sound Device Speech Recognition Sql Steam Sync Synology NAS Tata Docomo GPRS trick Teleprompter Torrent Trick Tricks TV Twitter UltraISO Unicode Unknown Extension Unlimited 2GB Unlimited 3GB Unlimited GPRS USB USB Security Key Video Editing virtual desktop Virus attack VLC Vodafone 110% working trick for GPRS Vodafone 3g Vodafone GPRS VPN wallpapers WannaCry Web Design Web Domain Website Wget Whatsapp WiFi Wikipedia Windows Windows 10 Windows 10 S Windows KN Windows Tricks windows updates Winows N Wolfarm Alpha WordPress XBox YouTube Zip
Twitter Delicious Facebook Digg Stumbleupon Favorites More