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 free Google sheets app from the Apps market, in the Utilities and Enhancements tab, 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 and complete the Google sign-in. Storeep keeps the connection alive for you, so you do not need to sign in again.
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.
Share orders between sheets
When Share orders between sheets is on (off by default), new orders go to each tab of the selected spreadsheet in turn, so every tab gets the same number of orders. Useful for splitting orders between staff members, one tab each.
Phone number format
The Phone number format list decides how numbers are written. It applies to both the Customer's phone and the Customer's whatsapp columns.
- International number (the default): the number keeps its country code, for example
+212612345678. - Local number with 0: the country code is removed and a 0 is put in its place, for example
0612345678. - Local number without 0: the country code is removed and nothing is put in its place, for example
612345678. Most dialers and courier tools import this shape cleanly.
One line per order
By default an order with several products uses one row per product, with the order and customer columns filled on the first row only. When One line per order is on (off by default), the whole order is written on one row instead, and each product column lists every item separated by commas: three items give SKU1, SKU2, SKU3 in the SKU column and 1, 2, 1 in the quantity column, always in the same order across every product column. This applies both to orders arriving in real time and to Export all orders.
Spreadsheet name
A short label for this configuration inside Storeep. Required.
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 created for you when you save. If Storeep cannot reach your Google Drive for a moment, a warning asks you to close the window and try again.
The Generate new spreadsheet toggle, when on, creates a brand new spreadsheet 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 reach the sheet only when the Automator app is installed and turned on, once the recovery time you set in Automator has passed.
Products
The Products list decides which orders go to the spreadsheet:
- All products: orders of every product are written to the spreadsheet.
- Specific products: only the products you pick. Search for a product, select it, then click the plus button to add it.
- All products except some: every product except the ones you pick.
- Products in collections: only the products of the collections you pick. The collections are grouped by market.
Columns and day to day management
The full list of columns you can send, and what you can do with a configuration once it exists (export every past order, duplicate it, edit it, delete it), is covered in Google Sheets columns and management.