Copy new Shopify orders into Google Sheets automatically

Short answer: Use a free Google Apps Script that copies every new Shopify order into a Google Sheet each hour, with the customer email, total, payment and fulfillment status and the items. It runs in your own Google account; nothing is sent to us. Setup takes 4 steps: Make a Settings tab; Add your key; Paste the script; Run it.

How to set it up

1. Make a Settings tab. Open a new Google Sheet and add a tab called Settings. Type your store address in B1, such as mystore.myshopify.com.
2. Add your key. In the Apps Script editor, open Project Settings and add the Script property SHOPIFY_TOKEN. In Shopify, go to Settings, Apps and sales channels, Develop apps, create an app, give it the read_orders scope, install it and copy the Admin API access token. Keys stay in the script, never in the sheet.
3. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Shopify menu appears.
4. Run it. Choose Shopify, then Copy new orders. The Orders tab fills in with each order's date, order number, email, total, payment status, fulfillment status and items. Choose Copy new orders every hour to keep it up to date.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• The first run copies your store's orders from the start; after that only new orders are added.
• Shopify only lets apps read the last 60 days of orders unless the app is granted read_all_orders.
• For an email when stock runs low, see our low stock alert script.

Questions

What does this script do?

It is a free Google Apps Script that copies every new Shopify order into a Google Sheet each hour, with the customer email, total, payment and fulfillment status and the items.

How do I set it up?

In 4 steps: 1. Make a Settings tab; 2. Add your key; 3. Paste the script; 4. Run it. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.