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.
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.
Pushing data to Google Sheets requires an intermediary service, like IFTTT or Zapier. 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: