WooCommerce to Google Sheets

WooCommerce Sync, part of SheetLink Pro, writes six store events to Google Sheets as they happen: order created, order completed, order refunded, customer created, product created and product updated. Each event can go to its own sheet, with no charge per order.

Requires the Pro tier ($79/yr or $199 lifetime)

Last reviewed November 12, 2026, against SheetLink Forms on WordPress.org.

How WooCommerce and Google Sheets are connected

WooCommerce keeps orders inside WordPress. WooCommerce Sync listens for six store events on your own site and posts each one, as a row, to a small script in your Google Sheet. You choose which events to send, which fields each one carries and which sheet it goes to. This page is the setup, the fields each event sends, and what it does not do.

Other ways to get orders into a sheet

  • Export orders from WooCommerce and open the file in Google Sheets. This is a copy from one moment; the next order is not in it.
  • Send orders through a general automation service. It works, but it adds a second account and a relay between your store and your sheet.

How to Send WooCommerce Orders to Google Sheets

Step-by-step setup guide

Before you start

  • WooCommerce installed and active.
  • A Pro or Agency licence, activated under SheetLink → License, and the SheetLink Pro plugin installed next to the free one.
  • A Google Sheet with the SheetLink Apps Script deployed as a web app. The Google Sheets setup guide covers the deployment. The one-click Google connection is for form submissions and is not used here.
  1. 1

    Install SheetLink Pro and activate the licence

    Install the free SheetLink Forms plugin and the SheetLink Pro plugin, activate your licence under SheetLink → License, then switch on WooCommerce Sync on the SheetLink → Features page.

  2. 2

    Deploy the receiver script in your Google Sheet

    In the Google Sheet, open Extensions → Apps Script, add the SheetLink script and deploy it as a web app. Copy the web app URL that ends in /exec. Use a separate sheet, with its own script, for each event you want kept apart.

  3. 3

    Switch on the events you want

    Open SheetLink → WooCommerce Sync. Each of the six events has its own card: Order created, Order completed, Order refunded, Customer created, Product created and Product updated. Tick Sync this event on the ones you need and paste the web app URL into Receiver URL.

  4. 4

    Choose the fields

    Each card lists the event's fields, one per line. A field with anything after the equals sign is sent; clear the right-hand side to leave a field out. If every line is left blank, all of the event's fields are sent. The screen suggests a column letter, but the letter does not place the column: the script names a column after each field it receives. Click Save all events.

  5. 5

    Send a test and place an order

    Use the card's Send test button, which writes a real sample row, then place a test order. Each delivery is listed in the Sync Log. A failed delivery is retried about 5 minutes, 30 minutes and 2 hours later, then kept in the Retry Queue for a one-click re-send.

  6. 6

    Read the rows as events

    Each event adds a new row, so an order that is created, completed and refunded has three. A column named _sheetlink_wc_event says which event wrote the row. To see where an order stands now, take its latest row by order_id. More detail is in the WooCommerce Sync docs.

What each event sends

These are the fields on each event's card (SheetLink Pro 1.2.0 or later lists every field an event sends). A field becomes a column headed with its name.

EventFieldsWritten when
Order createdorder_id, status, total, net_total, total_refunded, currency, email, first_name, last_name, phone, billing_city, billing_country, items, date_created, date_paid, date_modified, billing_state, tax_total, shipping_total, discount_total, coupon_codes, payment_method, payment_method_title, shipping_address, shipping_city, shipping_state, shipping_postcode, shipping_country. On a site that was already sending orders before SheetLink Pro 1.2.0, the twelve from billing_state on are left out until you write yes after them on the event's cardAn order is placed, paid or not.
Order completedThe same order fieldsThe order reaches the Completed status.
Order refundedThe same order fields, plus refund_amount, refund_id, is_partial_refund, refund_reasonA refund is made, partial or full.
Customer createdcustomer_id, email, first_name, last_name, username, date_registeredA customer account is created.
Product createdproduct_id, name, sku, type, status, price, regular_price, sale_price, stock_quantity, stock_status, date_created, date_modifiedA product is first published or created.
Product updatedThe same product fieldsA product is saved.

total is the gross order total and does not change; net_total is what is left after refunds. The name, phone, city and country are the billing ones. All of an order's items go into items as one cell. The tax, shipping and discount totals, the coupon codes, the payment method, the billing state and the shipping address are sent from SheetLink Pro 1.2.0. Order notes and custom checkout fields are not sent.

What WooCommerce Sync does

Six store events

Order created, Order completed, Order refunded, Customer created, Product created and Product updated. Each has its own switch, Receiver URL and field list.

A sheet per event

Give each event its own Receiver URL and orders, refunds and customers stay in separate sheets. Give two events the same URL to keep them together.

Checkout is not slowed down

The send is scheduled and runs straight afterwards, so a slow or unreachable sheet does not hold up the customer's checkout.

Partial refunds included

The refund event is written for partial and full refunds and carries the refund amount and reason.

Retry queue and log

Every delivery is in the Sync Log. A failed delivery is retried about 5 minutes, 30 minutes and 2 hours later, then kept in the Retry Queue for a one-click re-send.

Part of Pro

WooCommerce Sync is included in the Pro and Agency tiers, with no charge per order.

Troubleshooting

Events are switched on but nothing arrives.
Check that WooCommerce is active and that WooCommerce Sync is switched on under SheetLink → Features. The Receiver URL has to be a Google Apps Script web app address, starting with https://script.google.com/; anything else is not saved. Then look at the Sync Log for the delivery.
The Sync Log shows a failed delivery that mentions a sign-in page.
The script's web app is not open to requests from your site. Deploy it again with access set to Anyone and use the new URL.
A field is missing from the sheet.
Its line on the card has nothing after the equals sign while other lines do, so only the filled lines are sent. Put a value after it, or clear every line to send all fields.
Summing a total column gives too much.
These are event rows. An order that was created, completed and refunded has three rows, so a column summed across events counts it more than once. Keep each event in its own sheet, or filter on _sheetlink_wc_event, before adding up.
An order went to Processing and no row was written.
That is expected. Rows are written when an order is created, when it is completed and when it is refunded. Other status changes do not write anything.

Frequently Asked Questions

Is WooCommerce Sync included in the free SheetLink plugin?

No. WooCommerce Sync is part of the Pro tier ($79/yr or $199 lifetime) and of Agency. The free plugin covers form submissions from 12 form plugins.

Which WooCommerce events can be sent?

Six: Order created, Order completed, Order refunded, Customer created, Product created and Product updated. Each event has its own switch, its own Receiver URL and its own field list.

Does a status change update the order's row?

No. Each event adds a new row. An order that is created, completed and then refunded produces three rows. Other status changes, such as processing or on hold, do not write anything.

How are line items written?

All of an order's items go into one cell, as product names with quantities, separated by commas. There is no mode that writes one row per line item.

Is tax, shipping, coupon or payment method data sent?

Yes, from SheetLink Pro 1.2.0. An order event can send the tax, shipping and discount totals, the coupon codes, the payment method and its title, the billing state, and the shipping address in one cell together with its city, state, postcode and country. On a site that was already sending an order event with a blank field list, these fields stay out until you write yes after them on the event's card, so that an update does not add columns to your sheet by itself. Order notes and custom checkout fields are not sent.

Can a change in the sheet be sent back to WooCommerce?

No. WooCommerce Sync is one way, from the store to the sheet. Editing a row in the sheet changes nothing in WooCommerce.

Are orders from before the setup sent?

No. Rows are written from the moment an event is switched on. There is no import of earlier orders.

Does it slow down checkout?

No. The send is scheduled and runs straight afterwards, outside the customer's request.

Can orders go to Excel as well?

Yes, from SheetLink Pro 1.2.0. Each event can also be added as a row to a table in your Excel Online workbook, alongside the sheet or instead of it. The WooCommerce to Excel Online page has the setup.

WooCommerce orders in a Google Sheet, as they happen

Six store events, each as a row in your own sheet. Part of Pro, with no charge per order.