Skip to main content

Connecting Google Sheets

The Google Sheet app syncs the details of every new order that comes into your store straight into a Google Sheet you choose — handy if you like keeping your own copy of orders outside the dashboard, or sharing it with your team using Google Sheets' own permissions.

This app is available on the Starter plan and above. On the Free (pay-per-order) plan it appears locked with an upgrade button.

What gets synced​

  • Order details are sent to the sheet only after the order is actually placed — abandoned or unconfirmed orders are never sent.
  • Sync starts from the moment you turn the connection on. Orders placed before you connected it are not backfilled into the sheet automatically.
  • Each order writes to a single row and is never sent twice to the same sheet.
  • If you rearrange the columns, or regenerate and redeploy the script, the header row in the sheet is updated in place — you won't end up with duplicate header rows.

Available columns​

You can arrange 11 columns in any order, choosing one of the following for each position:

  • Date and time — when the order was placed
  • Product — a summarized list of the order's products
  • Quantity — total item count
  • Total — the order's total price
  • Client name
  • Phone number
  • City
  • State
  • Commune
  • Delivery type
  • Empty — a blank column, for laying out the sheet however you like

Setup steps​

From the Apps section of the dashboard, open the Google Sheet app and follow the steps in order:

1. Activate​

Choose Activated from the status dropdown to start syncing new order details to your connected sheet. Choose Deactivated to pause the sync without losing the rest of your settings.

2. Sheet name​

Enter a name for the sheet, however you'd like to recognize it — this is only for your own reference.

3. Columns​

Arrange the columns to match the actual header order in your Google Sheet. Follow the same sequence your sheet's headers are already in so the data lines up correctly with each column.

4. Generate script​

Click Generate & Copy Code to get a Google Apps Script (GAS) code snippet, which is copied to your clipboard automatically. Then:

  1. Open the Google Sheet you want to connect.
  2. From the menu, open the Apps Script editor and create a code.gs file.
  3. Paste in the code you copied, in full.
  4. Deploy the project as a Web App from inside the editor, and get the deployment URL.

5. Connect URL​

Paste the web app URL you got after deploying into the URL field. It must start with https://script.google.com/macros/s/ — any URL that doesn't match this shape will be rejected on save.

6. Setup & Verify​

Click Setup Headers to send the column headers to the sheet. This verifies that the URL you entered actually works, and initializes the sheet's first row according to the column order you chose.

Finally, click Save to persist all the settings together (status, sheet name, columns, and URL).

Good to know​

  • If you had an older Google Apps Script deployed from before, and you notice duplicate header rows after changing your settings, regenerate the script (step 4) and redeploy it — older script deployments don't automatically get the duplicate-prevention behavior.
  • If the connection fails when you click Setup Headers, make sure you copied the URL for the latest deployment of the web app (not the project's edit URL), and that the deployment's access is set to allow anyone to access it.
  • Turning the app off in the Activate step stops sending new orders immediately, but it does not delete your saved settings — you can turn it back on later without re-entering anything.