A little step-by-step tutorial to start the week. Let's create a mini RSS reader in #GoogleSheets to keep us up-to-date with the latest Google Workspace product releases. We'll be using the IMPORTFEED function to import the Google Workspace Product Updates RSS feed.

First, in cell A1, use the IMPORTFEED function to import the raw RSS feed: =IMPORTFEED("feeds.feedburner.com/GoogleAppsUpda… ")

Then wrap this with the QUERY function to extract the columns we want: =QUERY(IMPORTFEED("feeds.feedburner.com/GoogleAppsUpda… "),"select Col4, Col1,Col3")

Finally, as an optional step, re-label the headings to make the table more readable: =QUERY(IMPORTFEED("feeds.feedburner.com/GoogleAppsUpda… "),"select Col4, Col1,Col3 label Col4 'Date', Col1 'Update', Col3 'Link'")

The result is an automatically updated table of the latest updates, complete with links to the full article on the Google Workspace blog. I've also added conditional formatting to highlight any updates containing the word "Sheet" to make sure I don't miss any Sheets updates.