We've just launched a new Google Sheets add-on for Shopify merchants. The app lets you fetch your Shopify orders, products and other store data into Google Sheets without leaving the spreadsheet. This eliminates the hassle of exporting and importing csv files. You can try the app free for 14 days from the Shopify App Store: https://apps.shopify.com/google-sheets
Suggestions and feedback are more than welcome!
Josh @ Pricecanopy
I'm not sure if this add-on still exists, but I'm pulling in Shopify data to Google Sheets using this tutorial: https://mixedanalytics.com/knowledge-base/access-shopify-data-in-google-sheets/