Copy WooCommerce orders into Google Sheets automatically

Short answer: Use a free Google Apps Script that copies your WooCommerce orders into a Google Sheet every hour, with status, total, customer email and 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's address in B1, such as https://mystore.com.
2. Add your key. In the Apps Script editor, open Project Settings and add the Script properties WC_KEY and WC_SECRET. In WordPress, go to WooCommerce, Settings, Advanced, REST API, add a key with Read permission, and copy the consumer key and consumer secret. 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 WooCommerce menu appears.
4. Run it. Choose WooCommerce, then Copy new orders. The Orders tab fills in with the date, order number, status, total, currency, email and items of each order from the last 90 days. 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

• Your store must use https for the key to work.
• Each order is added once, matched on its ID; a status that changes later is not updated in the tab.
• Some security plugins block the REST API. If the script reports a 401 or 403, allow /wp-json/wc/ in that plugin.

Questions

What does this script do?

It is a free Google Apps Script that copies your WooCommerce orders into a Google Sheet every hour, with status, total, customer email and 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.