Keep Google Sheets and Yuki updated automatically.
Today you keep everything in a spreadsheet and then retype it into the system that actually has to act on it. This connector fixes that, and we build it on request: what happens in Google Sheets lands in Yuki by itself, in the shape Yuki expects. Tell us what you need and we agree exactly what should travel.
What this connector takes off your hands
-
Today you keep everything in a spreadsheet and then retype it into the system that actually has to act on it.
-
Today you type the postings in by hand, pick the right account and VAT rate per line, and check afterwards whether it reconciles.
What Google Sheets to Yuki saves you
- Book every task you finish in Google Sheets straight into Yuki.
- Book every new row in Google Sheets straight into Yuki.
What travels across the link
Everything this connector moves between Google Sheets and Yuki, and how often.
-
Invoices
to Yuki automaticallyEvery sale becomes an invoice in Yuki with its own line items and the order number as reference, so you can trace it back without retyping.
-
Contacts
to Yuki automaticallyThe customer is recorded as a contact in Yuki or reused by email, so no duplicate relation appears.
-
VAT
to Yuki automaticallyThe VAT rate is set per line, and foreign sales get the rate of the destination country, ready for your OSS return.
What each side expects
Google Sheets and Yuki do not describe the world the same way. This is what has to line up.
Yuki
An accounting package wants to know, per line, which ledger account and VAT rate apply, and wants the customer on file as a relation.
Setting it up
- 01
Request the connector
Let us know you want to link Google Sheets to Yuki. We get in touch within 24 hours with a timeline.
- 02
We agree what should travel
Together we settle what should travel out of Google Sheets. An accounting package wants to know, per line, which ledger account and VAT rate apply, and wants the customer on file as a relation.
- 03
We build and test
You see the connector run on a few test records before anything becomes final.
What you need
- A Google account with edit rights on the spreadsheet, and the tab the rows should go into.
- An administration you administer, plus clarity on the ledger account you want used.
Where it runs
On app.schakel.app, with your own Schakel account. No webshop required.
We build this connector on request. Tell us what you need and we reply within 24 hours.
Common questions
Can you connect Google Sheets to Yuki?
Yes. Schakel connects through the official APIs of Google Sheets and Yuki, so you install nothing on your own server and nothing travels outside those two parties.
Which VAT rate do my sales get in Yuki?
The rate is set per line: 21%, 9% or 0%. Sales to Belgium and other EU countries get the rate of the destination country, ready for your OSS return.
Are commission and fees booked separately in Yuki?
Yes. Commission, shipping and other fee types each land on their own ledger account in Yuki, rather than in one lump sum, so your margin stays readable.
From what moment in Google Sheets does something reach Yuki?
As soon as you add or finish the row or task in Google Sheets that you chose as the trigger, it reaches Yuki.
What does connecting Google Sheets and Yuki cost?
You start free and only pay once the connector is really running. After that the same tiers apply as for any other connector, based on how much runs through it each month.
How often does Google Sheets sync with Yuki?
That depends on your tier: hourly on the free tier up to real time on the unlimited tier. You can always start a sync yourself as well.
What happens to a return or refund in Yuki?
A return becomes a credit invoice in Yuki for the amount actually refunded, not for the whole order, so nothing needs correcting afterwards.
What if Google Sheets or Yuki is briefly unavailable?
Nothing gets lost. Schakel retries later and the log shows exactly what happened, so at most you notice something coming through a little later.
Missing something you need?
Tell us what Google Sheets and Yuki should do for you. If it is not in here yet, that is usually because nobody has asked. We build on request and we reply within 24 hours.