Skip to content

Connect a Google Sheet ​

Connect your store once, from Settings > Integrations, and your products, stock and prices stay in sync with the marketplace without any work on your side: you keep selling from your store, and the marketplace follows.

With Google Sheets, the spreadsheet is your store.

What syncs ​

  • ✅ Products: the Products tab, read every 15 minutes
  • ✅ Orders: written to the Orders tab as they are placed
  • ✅ Tracking: the Tracking tab, read every hour
  • ❌ Cancellations and refunds

Connect ​

  1. Make a copy of the sample Google Sheet: it has the three tabs with their columns
  2. Click Share and invite google-sheet-integration@garnet-marketplace.iam.gserviceaccount.com as Editor
  3. In Settings > Integrations, pick Google Sheets, paste the sheet's URL and save

The Products tab of the sample sheet

The three tabs ​

  • Products: one row per variant, with sku, title and price required; compare price, stock (empty or Untracked for untracked stock), weight (kg), images (URLs), description and up to three option N name / option N value pairs. The SKU of a product's first row identifies it: edit the row to update the product, remove it to archive the product.
  • Orders: filled by the marketplace, one row per item, with the customer's shipping address. Do not edit it.
  • Tracking: one row per order, written by the marketplace. Fill in tracking number and tracking company (and tracking url): the order is fulfilled within the hour, and the customer receives the tracking.

If it does not work ​

  • A product is not imported: its first row has no SKU, or a required column is empty; a change shows within 15 minutes.
  • The sheet is refused: the marketplace's address is not an Editor of the sheet, or the URL is not the sheet's.
  • The tracking is not sent: the order id and order name must match the Orders tab; a tracking cannot be changed once sent.

Ask your marketplace ​

Whether it imports all your products or picks them.