Shopify and Google Sheets, ready to switch on

Every order lands as a row with the order number, the customer, the discount code and the sales channel it came through, a second tab lists each line with its SKU and variant, and the row follows the order as it is paid, fulfilled and refunded. You paste your Shopify token 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 Shopify 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	Shopify to Google Sheets	Within seconds	Order number, date, customer, total, discount code, tags and the sales channel the order came through
Payment and fulfilment apart	Shopify to Google Sheets	Within seconds	Shopify tracks whether an order is paid and whether it has shipped as two different things, and each gets its own column on the same row
Lines with SKU and variant	Shopify to Google Sheets	With every order	One row per line on a second tab with the product, the variant, the SKU and the quantity, tied to the order number
Refunds and returns	Shopify to Google Sheets	When they are made	The refunded amount goes into its own column rather than changing the original total, so a sum in the sheet still matches your payouts
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	Shopify to Google Sheets	Every order	Matched on the order id rather than the order name, so a store that uses prefixes or renumbers still gets one row

How to set up Shopify and Google Sheets

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

Choose Shopify 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 Shopify Admin API token and the Google Sheets link
- Shopify Admin API token: in your Shopify admin open Settings, then Apps and sales channels, then Develop apps, and create an app. Full Shopify 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 seven minutes for both.
We check both keys

Each key is checked against Shopify'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 Shopify and watch the row appear in the sheet. A person checks the setup and switches it on, within a working day.

When Shopify 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 Shopify 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 Shopify 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

Do variants really come through?

Yes, on the line items tab: product, variant, SKU and quantity. That is the tab people use to find out which size actually sells, which the order total never tells you.

What about draft orders and abandoned checkouts?

Shopify keeps them apart from orders, and so do we. A draft appears when it becomes a real order. Abandoned checkouts can go to their own tab if you ask for it while connecting.

Which plan does this need?

Any plan. You create a custom app in your own admin and copy the Admin API token it shows once. Nothing is installed from the app store.

Can I choose the columns?

Yes, tell us which ones and in what order while connecting. Say nothing and we set up the standard ones on a fresh tab, which you can rearrange afterwards.

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.