WooCommerce and Google Sheets, ready to switch on

Every order lands as a row with the customer, the payment method and the totals split into goods, shipping and tax, coupons get their own column, and the row follows the order from processing to completed or refunded. You paste your store keys and a link to your sheet, and we switch it on for you.

Ask us to connect it Mine is a bit different

No setup fee, cancel any month, and a person on live chat if a key doesn't work.

More with these apps: all WooCommerce integrations · all Google Sheets integrations

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	Number, date, customer, payment method, and the total split into goods, shipping and tax
Status column follows the order	WooCommerce to Google Sheets	Within seconds	Pending, processing, on hold, completed, cancelled and refunded each rewrite the same column of that row
Coupons	WooCommerce to Google Sheets	With every order	The code used and the discount it gave, so a campaign can be totted up without another plugin
Lines with SKU	WooCommerce to Google Sheets	With every order	One row per product on a second tab with the SKU, the quantity and the line total
Your columns stay yours	In the sheet	Always	We write the columns we set up; what you add to the right, your formulas and your filters are left alone
Duplicate check	WooCommerce to Google Sheets	Every order	Matched on the WooCommerce order id, so a plugin that renumbers invoices does not create a second row

How to set up WooCommerce and Google Sheets

A few minutes of your time, then it's ours.

Choose WooCommerce and Google Sheets

Press Connect. This pair is already selected on the checkout page at $39 a month, and there's nothing else to pick.
Pay and open your account

Card or invoice, about two minutes. The account opens with this integration waiting for its two keys.
3
Paste the WooCommerce REST API keys and the Google Sheets link
- WooCommerce REST API keys: in WordPress open WooCommerce, then Settings, then Advanced, then REST API, and press Add key. Full WooCommerce guide
- Google Sheets link: create or open the spreadsheet, share it with the address our engineer sends you or with anyone who has the link, and paste the link from the address bar. Full Google Sheets guide
Each screen carries the full guide with the exact menu names, about five minutes for both.
We check both keys

Each key is checked against WooCommerce's and Google Sheets's own API the moment you paste it. If one doesn't pass, the screen says what to fix, and a person joins the chat if that isn't enough.
Place one test order, then we switch it on

A minute or two. Create a test order in WooCommerce and watch the row appear in the sheet. A person checks the setup and switches it on, within a working day.

When WooCommerce or Google Sheets changes its API, we fix it within a working day. You don't get a ticket to solve.

$39a month

Everything in the table above, with monitoring on.
Fixes when either app changes its API.
A person on live chat, weekdays 10:00 to 19:00 EET.
Custom logic beyond the table is priced separately.

Ask us to connect it

What it will cost once you can switch it on yourself. While we're in beta we connect it by hand and don't charge for it.

Ways to connect WooCommerce and Google Sheets

Two ways people connect these two, and what each one asks of you.

Zapier or MakeDovetly

Who sets it upYou, one step at a time in the scenario editorAlready built. You paste two keys and we switch it on.

Who fixes it when it breaksYou: the scenario is yours, so the fix is tooWe do, within a working day, and we watch it

What you need to knowTriggers, actions, filters and how the fields of WooCommerce and Google Sheets mapWhere the two keys are. The guide shows it.

PriceSet by the builder's plan, counted in tasks or operations$39 a month, flat, whatever the volume

Before you decide

Does anything get installed on the site?

No. WooCommerce's own REST API and webhooks are enough, and you only create a key pair in the settings. The one thing to check is that pretty permalinks are on, otherwise the API address does not answer.

Our host strips the authorization header. Is that a problem?

No. Some hosts and security plugins do, and then the keys travel in the query string over HTTPS instead, which WooCommerce supports for exactly this reason. We try both when you paste them.

What about the fields our plugins add?

Named order meta fields can go into columns you choose. Tell us the field names while connecting; guessing them from the outside is how the wrong number ends up in a report.

Do refunds change the original row?

The status column changes and the refunded amount goes into its own column. The original total stays where it was, because rewriting it makes last month's numbers change overnight.

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 within a working day and build into the same account.