There are two options: One uses the IMPORTDATA function to pull in data once, and the other offers a live push using either IFTTT or Zapier.

Using IMPORTDATA

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:

=IMPORTDATA("https://yourshopifystore.com/pages/feed")

... 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

Using IFTTT or Zapier, you can use Mechanic to send data to a multitude of other online services – including Google Sheets.

To get started, configure IFTTT or Zapier to perform a Google Sheets operation, triggered by a webhook. Here's where to get started:

Then, use our HTTP action to send data to the webhook URL that IFTTT or Zapier provides.

To learn more about this approach, see our tutorial: Triggering tasks with IFTTT.

Did this answer your question?