KPL-1919
Exact Online Google Sheets

Keep Exact Online and Google Sheets updated automatically.

This connector fixes that, and we build it on request: what happens in Exact Online lands in Google Sheets by itself, in the shape Google Sheets expects. Tell us what you need and we agree exactly what should travel.

TasksRows
The problem

What this connector takes off your hands

  • Today you paste exports into a tab, sort it again, and your pivot table breaks because a column got added. Who edited it last is anyone’s guess.

What you get out of it

What Exact Online to Google Sheets saves you

  • Turn every invoice you send from Exact Online into a Google Sheets task automatically.
  • Turn a Exact Online invoice going overdue into a Google Sheets task automatically.
  • Turn every paid Exact Online invoice into a Google Sheets task automatically.
The link

What travels across the link

Everything this connector moves between Exact Online and Google Sheets, and how often.

  1. Tasks

    to Google Sheets automatically

    This lands in Google Sheets as a task in the list or project you choose, so follow-up does not depend on someone remembering.

  2. Rows

    to Google Sheets automatically

    This arrives in Google Sheets as a new row, so your overview stays complete without you retyping anything.

Both sides

What each side expects

Exact Online and Google Sheets do not describe the world the same way. This is what has to line up.

Google Sheets

Google Sheets only stays usable with a fixed column order. New rows belong at the bottom, so your formulas, filters and pivot tables survive.

In four steps

Setting it up

  1. 01

    Request the connector

    Let us know you want to link Exact Online to Google Sheets. We get in touch within 24 hours with a timeline.

  2. 02

    We agree what should travel

    Together we settle what should travel out of Exact Online. Google Sheets only stays usable with a fixed column order. New rows belong at the bottom, so your formulas, filters and pivot tables survive.

  3. 03

    We build and test

    You see the connector run on a few test records before anything becomes final.

What you need

  • An Exact Online account with rights on the administration you want linked. You grant Schakel access once through Exact itself.
  • A Google account with edit rights on the spreadsheet, and the tab the rows should go into.

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 Exact Online to Google Sheets?

Yes. Schakel connects through the official APIs of Exact Online and Google Sheets, so you install nothing on your own server and nothing travels outside those two parties.

Which Google Sheets project or list do the tasks land in?

The project or list you choose. That keeps everything in one place rather than scattered, and follow-up does not depend on someone remembering.

Can I decide what goes into the Google Sheets task or row?

Yes. When setting it up you pick which details from Exact Online come along, so a task or row in Google Sheets has just enough context.

What does connecting Exact Online and Google Sheets 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 Exact Online sync with Google Sheets?

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 if Exact Online or Google Sheets 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.

How do I connect Exact Online to Google Sheets?

You give Schakel access to Exact Online and Google Sheets once and pick what should travel. We set it up together with you, so no technical knowledge is needed, and after that it runs by itself.

Is my Exact Online data safe in this connector?

Your credentials are stored encrypted and we only process what is needed to update Google Sheets. We sell nothing on and comply with the GDPR.

Missing something you need?

Tell us what Exact Online and Google Sheets 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.