Ozon and Google Sheets, ready to switch on

Every order lands as a row with the items, the sum, the delivery scheme and the tracking number, the status column follows the marketplace, and stock counts sit on their own tab. You paste your seller 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 Ozon 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	Ozon to Google Sheets	Within seconds	One row per order: number, date, buyer, items, totals, discount and status
Status update	Ozon to Google Sheets	Within seconds	Paid, shipped, cancelled and refunded rewrite the status column of the same row
Line items	Ozon to Google Sheets	With every order	One row per item on a second sheet, tied to the order by its number
Your columns stay yours	In Google Sheets	Always	We write the columns we set up; what you add to the right, your formulas and your filters are left alone
Duplicate check	Ozon to Google Sheets	Every order	Matched by order number, never a second row

How to set up Ozon and Google Sheets

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

Choose Ozon 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 Ozon Seller key and the Google Sheets link
- Ozon Seller key: in Ozon Seller open Settings, then API keys. Full Ozon 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 Ozon'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 Ozon and watch its row appear, then mark it paid and watch the status column change. A person checks the setup and switches it on, within a working day.

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

Can I choose the columns?

Yes, tell us the order you want them in while connecting. Say nothing and we set up the standard ones on a fresh sheet, which you can rearrange later.

What happens if someone types over a cell?

Columns we own are rewritten on the next update from Ozon. Everything else you type stays, and columns to the right of ours are never touched.

How fresh are the numbers?

Orders and status changes arrive as Ozon pushes them, and we also check every few minutes as a safety net in case a push is missed. Stock counts come a few times an hour, which is as often as they are worth reading.

Anything to know about Ozon?

Ozon shares only part of the buyer's details with the seller, and how much depends on the delivery scheme.

Anything to know about Google Sheets?

Google Sheets doesn't tell anyone when a cell changes, so anything we read back out of a sheet is picked up on a short schedule rather than the moment you type it.

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.