Connect Google Sheets
A spreadsheet is still the handiest tool for doing your own sums, but only if the data lands there without hassle. Schakel writes your orders, revenue and returns from Bol.com and your webshop straight into Google Sheets, every row in its place, so your pivots and formulas run on fresh numbers instead of last week's export.
What travels with Google Sheets
-
Orders per row
Every order lands as a row in your tab, with order number, date, products, quantity and amount, ready to filter on.
-
Revenue and costs
Revenue, commission and shipping can go in their own columns, so your margin is a glance away to calculate.
-
Returns
Returns land in their own tab with the refunded amount, so your net revenue is right.
Why connect Google Sheets
- Your sales figures are always fresh in your sheet.
- Do your own sums and pivots, without manual export.
- Bol.com and your webshop in the same overview.
- Share the tab with your accountant or team.
How it works
- 01
Request the connector
Request the connector and get access. You connect your sales channel and give Schakel access to a Google Sheet.
- 02
Pick your columns
You decide which fields go in which columns, so it fits your existing sheet.
- 03
Updates itself
From then on new orders are added automatically, and your formulas calculate along.
Google Sheets, common questions
Can I export my Bol.com orders to Google Sheets?
Yes. Request the connector and get access; your Bol.com orders then land as rows in your sheet, together with your webshop if you connect that too.
Does the tab update itself or is it a one-off?
It updates itself. New orders are added as rows, so your formulas and pivots keep running on fresh data.
What do I need to start?
A Google account with a Sheet and the channel you want to connect. Request the connector and get access.
A Google Sheets connection you do not see here?
Tell us which system Google Sheets should connect to. Request it and you get access; you hear from us within 24 hours.