Google Sheets can be used as a free RSS (and Atom) reader.
The Sheets IMPORTFEED function allows you to create a self-updating repository of blog & news article content that you can easily share with your social media followers.
In this post, we’ll explain how this works. We will also provide you with a link to a sample Google Sheet that you can copy and adapt to the RSS feeds that most interest you, your customers and your social media followers.
We’ll show you how to create Google Sheets formulas for one-click social sharing of blog posts and articles on Twitter, LinkedIn and Facebook.
What is an RSS reader?
Most (but not all) blogs and news sites have an RSS or Atom feed.
The feed is a semi-structured (XML) file that contains titles, descriptions, URLs and more for recent posts. The job of an RSS reader is to transform the file’s markup language into a more human-friendly format.
If you have go-to websites that you use as sources for social media sharing—or just for keeping yourself informed—you can add each blog to its own sheet.
If you use Google Alerts, you can discover the RSS feed for any Google Alert and add the feed to its own sheet within Google Sheets.
Pull your first RSS feed into a Google Sheet
Here’s how it works.
1. In cell A1 of a sheet, add a blog’s RSS feed URL. For the blog you are now reading, the feed URL is:
2. In cell A3, add this formula for the blog post title:
=IMPORTFEED(A1,”items title”, TRUE, 100)
3. In cell B3, add this formula for the blog post URL:
=IMPORTFEED(A1,”items URL”, TRUE, 100)
4. In cell C3, add this formula for the date that the blog post was published:
=IMPORTFEED(A1,”items created”, TRUE, 100)
Different platforms have different RSS feed URLs. For blogs that aren’t using a standard website platform, it may take some trial and error to discover the RSS or Atom feed.
To discover what platform a website is using, you can use the Wappalyzer browser extension.
The default feed for all WordPress.org sites is simply:
Wix is a popular local business website builder. The Wix blog uses an Atom feed. Here is an example URL:
For blogs that use Google’s Blogger, the RSS feed is via FeedBurner, which is also owned by Google. The Google Workspace Updates blog is an example of this.
The disadvantage to the RSS reader for Blogger is that the returned URLs are proxies that forward to the original article. However, that can be solved by using a formula that transforms the URLs into direct links to blog posts.
If you use Google Alerts, you know that this lets you monitor the web based on search terms that you specify.
At the bottom of every Google Alert email, there is an RSS link. Append this URL with ?output=atom and then use that in cell A1 of your Google Sheet.
Alternatively, when setting up a Google Alert, there’s an option to “Deliver to” an RSS feed. You can then click on the RSS icon in My Feeds.
Since the returned URLs for Google Alerts feeds include tracking code, we use this formula in the Google Sheet to return the source URL:
Here are two examples of blogs that are not served up from a common platform such as WordPress, Blogger or Wix:
Formulas For Social Sharing Links
You can add columns in your sheet for sharing content on Twitter, LinkedIn or Facebook. If you are a Buffer subscriber, you can create a column for that too.
Note that these providers occasionally change the syntax for sharing content on their platform.
Fill down the respective columns with these formulas: