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 it runs, in about ten minutes.
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 |
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 Ozon Seller key 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 Ozon and watch its row appear, then mark it paid and watch the status column change.
When Ozon 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
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 statuses are pulled every few minutes, because the marketplace does not push events to anyone. 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 the same day and build into the same account.
