Import WordPress feed into Google Sheets

Google Sheets has a built-in function called ImportXML which allows you to import bits of a website through an XML file or feed. We can utilize this function to funnel WordPress posts, pages, comments, etc into a Google Sheet quickly and easily.

You would use a function such as the one below, altering the URL to your feed URL:

=IMPORTXML("https://THEDOMAIN.COM/feed/", "//item")

Which will output something similar to this:

How to customize the feed: https://codex.wordpress.org/Customizing_Feeds

You can use the WooCommerce Google Feed Manager plugin to create and control feeds for your WooCommerce store as well.