Can I send data to Google Sheets?
Yes! There are two options: One uses the IMPORTDATA function within Google Sheets to pull data from your store into your spreadsheet. The other lets you dynamically push new data to Google Sheets, using their REST API.
Use Mechanic to publish a formatted CSV to your Shopify storefront. Use this guide to get started: Creating scheduled CSV feeds.
Then, enter this formula into a cell in Google Sheets:
... adjusting the URL as appropriate, given your store's domain name and the page you've created in Shopify.
Learn more from Google: IMPORTDATA
Please note: As of this writing, and per documentation, the IMPORTDATA formula re-fetches data once every hour.
Using a live push
Google Sheets has a REST API that you may use to send data directly to your spreadsheet, using the "http" action.
Or, using IFTTT or Zapier, you can use Mechanic to send data to a multitude of other online services – including Google Sheets.
To get started with this route, configure IFTTT or Zapier to perform a Google Sheets operation, triggered by a webhook. Here's where to get started: