Integration · Google SheetsConnect Google Sheets to your online store
Sync your orders to a Google Sheet using a Google service account.
Google Sheets sync sends your orders to a Google Sheet using a Google Cloud service account. It suits merchants comfortable with Google Cloud.
What you get with Google Sheets on Vondera
From the App Store
Install Google Sheets from the Vondera App Store in a few clicks.
Works on your orders and products
Google Sheets reads your store data directly, with no exports or imports.
Clear permissions
Before you connect, you see every permission the app needs, and you can disconnect at any time.
Guides and support
Every app has a help center guide, and our team is there if you need it.
Connect Google Sheets in a few steps
Straight from the help guide, the same steps you will see in your dashboard.
- 1
Go to Apps, filter by Analytics or search, and open Google Sheets sync. Click Install.
- 2
In Google Cloud, create a project and enable the Google Sheets API.
- 3
Create a Service Account and create a JSON key for it.
- 4
Share your Google Sheet with the service account’s email as Editor.
- 5
After installing, open the app’s settings (Configure) to enter your service account key and sheet details.
What you need from Google Sheets
Get these from your Google Sheets account, then paste them into the app.
Questions merchants ask
Is there an easier option?
Yes. VSheet only needs you to sign in with Google — no service account or keys.
Is the app free?
Yes. The app is free to install from the App Store.
Do I need API keys?
No. Signing in with Google is enough.
Will an updated order create a duplicate row?
No. Updates change the existing row for that order.
How do I install Google Sheets?
Open Apps in your Vondera dashboard, find Google Sheets, click Get, review the permissions and click Allow.
More app integrations
CJ DropshippingImport CJ products and send new orders to CJ for fulfilment automatically.
PrintifySell Printify print-on-demand products and send orders to your Printify shop automatically.
TaagerSync your orders with Taager in real time for dropshipping.
SendGridSend your store emails through your own SendGrid account.
COD RadarGet a risk score for each cash-on-delivery order before you ship it.
Confirm ItConfirm cash-on-delivery orders with WhatsApp messages and calls.
Currency ConverterConvert your product prices into your other storefront currencies with live exchange rates.
DaqiqConnect Daqiq for order confirmation, warehouses and fulfilment after checkout.