Keep Google Sheets and Shopware 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 Shopware by itself, in the shape Shopware 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 enter orders by hand and correct stock afterwards, usually once something already went wrong.
What Google Sheets to Shopware saves you
- Bring every task you finish in Google Sheets back into Shopware.
- Bring every new row in Google Sheets back into Shopware.
What travels across the link
Everything this connector moves between Google Sheets and Shopware, and how often.
-
Orders
to Shopware automaticallyEvery order becomes an order in Shopware with line items, matched on EAN or SKU, so you handle it all from Shopware without retyping.
-
Inventory
to Shopware automaticallyA sale updates stock in Shopware, so you never sell the same last unit on two channels at once.
-
Shipments
to Shopware automaticallyThe moment you ship, the tracking travels along, so the shipping status matches on both sides.
What each side expects
Google Sheets and Shopware do not describe the world the same way. This is what has to line up.
Shopware
A shop platform needs to point each line at a product, usually via SKU or barcode, and track stock per product.
Setting it up
- 01
Request the connector
Let us know you want to link Google Sheets to Shopware. 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. A shop platform needs to point each line at a product, usually via SKU or barcode, and track stock per product.
- 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.
- A store you administer, with API access from its admin.
Where it runs
Inside your Shopify admin, as an app. You sign in through Shopify, no separate account.
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 Shopware?
Yes. Schakel connects through the official APIs of Google Sheets and Shopware, so you install nothing on your own server and nothing travels outside those two parties.
What does the connector match products on in Shopware?
On EAN barcode or SKU. Those have to line up on both sides; anything that does not match automatically you map once by hand, and it is remembered after that.
Does the connector touch my existing Shopware orders?
No. Schakel only creates new orders in Shopware and leaves your existing ones alone.
From what moment in Google Sheets does something reach Shopware?
As soon as you add or finish the row or task in Google Sheets that you chose as the trigger, it reaches Shopware.
What does connecting Google Sheets and Shopware 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 Shopware?
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 Google Sheets or Shopware 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 Google Sheets to Shopware?
You give Schakel access to Google Sheets and Shopware 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.
Missing something you need?
Tell us what Google Sheets and Shopware 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.