WooCommerce and Google Sheets, ready to switch on
Every WooCommerce order lands as a row in a Google Sheet you own, with the items, the totals and the customer, and the row updates when the order is paid, completed or refunded. You paste two keys in your account and it runs, in about ten minutes.
No setup fee, cancel any month, and a person on live chat if a key doesn't work.
What moves, and when
The details you would normally get after a sales call. Here they are up front.
| What | Direction | When | Rule |
|---|---|---|---|
| New order as a row | WooCommerce to Google Sheets | Within seconds | One row per order: number, date, customer, items, totals, discount and status |
| Status update | WooCommerce to Google Sheets | Within seconds | Processing, completed, cancelled and refunded update the status column of the same row |
| Line items | WooCommerce to Google Sheets | With every order | One row per item on a second tab, linked by the order number |
| Your columns stay yours | In the sheet | Always | We write to the columns we set up; anything you add to the right, plus your formulas and filters, is left alone |
| Duplicate check | Both ways | Every order | Matched by order number, never a second row |
Ten minutes of your time, then it's ours
- Pay and open your accountCard or invoice, about two minutes. This integration is already selected.
- Paste the WooCommerce REST API keys and the Google Sheets linkEach has a short guide. About five minutes. If one doesn't work, a person joins the chat.
- Place one test orderA minute or two. Create a test order in WooCommerce and watch the row appear in the sheet. From then on we watch it for you.
When WooCommerce or Google Sheets changes its API, we fix it within a working day. You don't get a ticket to solve.
- Everything in the table above, with monitoring on.
- Fixes when either app changes its API.
- A person on live chat, replies within a working hour.
- Custom logic beyond the table is priced separately.
No setup fee, cancel any month
Before you decide
Does it need a plugin?
No. WooCommerce's own REST API and webhooks are enough; you only create the key. Nothing gets installed on your site.
Do I have to share the sheet with the whole internet?
No. Anyone-with-the-link is the quick way. If you'd rather not, share it only with the address our engineer sends you before switching on; that works the same.
What if someone edits a row by hand?
The status column is overwritten on the next update from WooCommerce; everything else you type stays. Columns you add to the right of ours are never touched.
What if mine is a bit different?
Tell us what should go where in plain words. Small changes to the rules above are usually free; bigger ones we price the same day and build into the same account.
