Google Sheets is an app you install from the Apps market. It syncs orders from your store to a Google Sheet in real time. Go to Apps, find Google Sheets in the Utilities & Enhancements collection, install it, then click the gear icon to connect your Google account and create spreadsheet configurations.
Connecting your Google account
After installing the app, open its settings. If your account is not yet connected, the panel shows a Sign in with Google button. Click it to go through the Google sign-in flow. Once authorised, Storeep stores the connection and keeps it refreshed automatically.
To disconnect your account, click Disconnect Google account at the bottom of the settings panel. A note warns: "If you choose to disconnect your account, all data will be permanently erased."
Adding a spreadsheet configuration
After connecting your Google account, click Add new spreadsheet and fill in the following fields:
Activate
The Activate toggle controls whether this configuration is live. When active, new orders that match your rules are written to the sheet immediately.
Round robin method
When Round robin method is enabled, new orders are distributed evenly across all sheet tabs in the selected spreadsheet. This is useful when you want to split orders between multiple agents, each working from their own tab.
International country code
When International country code is enabled, phone numbers are sent to your sheet with their full international dialling prefix. This option is on by default when you add a new configuration.
Spreadsheet name
A label for this configuration in Storeep's interface. This field is required.
Markets
The Markets selector restricts which of your store markets this configuration covers. Only orders from the selected markets are sent to the sheet. Leave this empty to include orders from all markets.
Spreadsheet and sheet selection
If your Google account has existing spreadsheets, they are loaded from Google Sheets and shown in a searchable Spreadsheet dropdown. After selecting a spreadsheet, the Sheet dropdown loads the tabs inside it; select the tab where orders will be written.
If you have no existing spreadsheets, a message appears: "You don't have any Google spreadsheet on your Google Sheets account, so we will generate one for you automatically after you click save."
The Generate new sheet toggle, when enabled, creates a new tab inside the selected spreadsheet each time you save. This is useful when you want a fresh tab per configuration.
Orders type
The Orders type field controls which orders are sent to the sheet:
- All orders: every order regardless of status.
- Only completed orders: only orders that were successfully placed and not abandoned.
- Only abandoned orders: only orders where the customer did not complete checkout. Requires the Automator app to be installed and configured; see Automator: recover abandoned orders.
Filter type
The Filter type field controls which products trigger the sync:
- All products: every product in your store.
- Only specific products: only the products you select. Use the product search field to add products one by one to the inclusion list.
Selected fields (columns)
A dual-panel selector lets you choose which data columns appear in the sheet and in what order. Move columns from Available fields to Selected fields using the arrow buttons. The full list of available fields includes:
- Order fields: Order's ID, Order's Number, Order's date, Order's shipping method, Order's weight, Order's payment method, Order's subtotal, Order's discount, Order's shipping, Order's VAT, Order's total, Order's currency, Order's market, Order's market code, Order's status, Order's abandoned status, Order's duplicated status, Order's returning customer status, Order's test status, Order's URL.
- Product fields: Product's ID, Product's name, Product's price, Product's quantity, Product's SKU, Product's barcode, Product's weight, Product's variants, Product's link.
- Customer fields: Customer ID, Customer's full name, Customer's birthday, Customer's gender, Customer's company, Customer's address (line 1 and line 2), Customer's national ID, Customer's neighborhood, Customer's district, Customer's apartment, Customer's floor, Customer's state / region, Customer's city, Customer's commune, Customer's province, Customer's postal code, Customer's country, Customer's real country, Customer's email, Customer's phone, Customer's WhatsApp, Customer's map link, Customer's colour tag, Customer's note, Customer's browser, Customer's operating system, Customer's device type, Customer's IP address, Customer's user agent, Customer's referrer, Customer's VPN/Proxy status.
- UTM fields: UTM source, UTM medium, UTM campaign, UTM term, UTM content.
- Store fields: Store's name.
Managing existing configurations
The main Google Sheets panel shows a table of all your configurations with the spreadsheet name, date created, markets, and activation status. For each row you can:
- Click the row to edit the configuration.
- Click the Export all orders icon to push a full historical export of matching orders to the sheet. Only one export can run at a time; if an export is already in progress, the button is disabled and shows "Export already in progress".
- Click the Duplicate spreadsheet icon to clone the configuration.
- Click the Go to spreadsheet icon to open the Google Sheet directly in a new tab.
- Tick the checkbox and use Delete spreadsheets to remove one or more configurations.
Editing a configuration
Click a row to open the edit form. All fields are pre-filled with the current values. Click Save to apply your changes.
Notes
- Orders are written to the sheet in real time as they are placed (or converted from abandoned by the Automator app). There is no delay.
- Disconnecting your Google account removes all stored credentials and configuration data permanently.
- If your Google connection expires or is revoked in your Google account, the integration is automatically marked as disconnected and you must reconnect.