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.
Please note: As of this writing, and per documentation, the IMPORTDATA formula re-fetches data once every hour.
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:
Then, use the "http" action to send data to the webhook URL that IFTTT or Zapier provides. Learn more about this general technique with our tutorial: Triggering tasks with IFTTT.