Last updated
Was this helpful?
Last updated
Was this helpful?
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: .
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:
Please note: As of this writing, and , 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 to send data to the webhook URL that IFTTT or Zapier provides. Learn more about this general technique with our tutorial: .