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.

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

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:

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.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.