Google Sheets sends your store orders into a Google spreadsheet automatically. Completed orders land in the sheet in real time as they are placed; abandoned orders can also be sent (see Orders type below). You install the app from the Apps market, in the Utilities & Enhancements collection, then connect your Google account and create one or more spreadsheet configurations.
Connecting your Google account
Open the app from Apps > Google Sheets. Before you connect, the panel shows a Sign in with Google button. Click it, complete the Google sign-in, and Storeep stores the connection and refreshes the access token automatically (every token lasts under an hour and is renewed for you).
To remove the link, click Disconnect Google account at the bottom of the panel. A note warns that all data will be permanently erased. Disconnecting deletes your stored credentials and every spreadsheet configuration, and revokes the token on Google's side. If you revoke access from your Google account instead, the integration is marked disconnected and you must reconnect.
Adding a spreadsheet configuration
Click Add new spreadsheet and fill in the fields below. You can create several configurations, each pointing at a different sheet with its own rules.
Activate
The Activate toggle (on by default) controls whether this configuration is live. While active, new matching orders are written to the sheet.
Round robin method
When Round robin method is on (off by default), new orders are distributed evenly across all tabs in the selected spreadsheet. Useful for splitting orders between agents, one tab each.
International country code
When International country code is on (on by default), phone numbers are written with their full international dialling prefix.
Spreadsheet name
A label for this configuration inside Storeep. Required, and limited to 50 characters.
Markets
The Markets selector picks which of your store markets this configuration covers. Only orders from the chosen markets are sent. At least one market is required: you cannot leave it empty.
Spreadsheet and sheet selection
If your Google account already has spreadsheets, they load into a searchable Spreadsheet dropdown. After you pick one, the Sheet dropdown loads its tabs; choose the tab where orders are written. If you have no spreadsheets, a message tells you one will be generated automatically when you save.
The Generate new sheet toggle, when on, creates a brand new sheet for you on save instead of selecting an existing one.
Orders type
- All orders: every order regardless of status.
- Only completed orders: orders successfully placed and not abandoned.
- Only abandoned orders: orders where checkout was not completed. These are sent to the spreadsheet 10 minutes after they are placed, and this requires the Automator app to be installed from the Apps market.
Filter type
- All products: every product in your store triggers the sync.
- Only specific products: only the products you add. Use the product search to add them one by one to the inclusion list.
Selected fields (columns)
A dual-panel picker chooses which columns appear, and in what order. Move items from Available fields to Selected fields with the arrow buttons (single arrows move one, double arrows move all). Available fields:
- Order: ID, Number, date, shipping method, weight, payment method, subtotal, discount, shipping, VAT, total, currency, market, market code, status, abandoned status, duplicated status, returning customer status, test status, URL.
- Product: ID, name, price, quantity, SKU, barcode, weight, variants, link.
- Customer: ID, full name, birthday, gender, company, address 1 and 2, national ID, neighborhood, district, apartment, floor, state / region, city, commune, province, postal code, country, real country, email, phone, WhatsApp, map link, color, note, browser, OS, device, IP, user agent, referer, VPN/Proxy status.
- UTM: source, medium, campaign, term, content.
- Store: name.
Managing existing configurations
The main panel lists every configuration with its spreadsheet name, creation date, markets, and Activated or Deactivated status. For each row you can:
- Click the row to open and edit it.
- Use the Export all orders button to push a full historical export of matching orders to the sheet. Only one export runs at a time; while it runs the button is disabled and shows Export already in progress.
- Use Duplicate spreadsheet to clone the configuration. The copy gets a "(Copy)" suffix and starts deactivated.
- Use Go to spreadsheet to open the Google Sheet in a new tab.
- Tick a row's checkbox and use Delete spreadsheets to remove one or more configurations.
Editing a configuration
Click a row to open the edit form with every field pre-filled, change what you need, and click Save.
Good to know
- Completed orders are written in real time; abandoned orders arrive about 10 minutes after they start, and only when Automator is installed.
- Disconnecting your Google account removes all credentials and configurations permanently.