Skip to content
Docs Getting Connected

Connecting Pricemaster to a Google Sheet

How to use a Google Sheet as your product source for Pricemaster: required columns, sharing setup, sample template, and what happens after you submit the form.

Who This Is For

Use a Google Sheet when you don't have a standard storefront integration

If your catalogue isn't in Shopify, Magento, or WooCommerce — for example you're a brand publishing an RRP list, or a retailer maintaining a master sheet — you can point Pricemaster at a Google Sheet and it will treat that sheet as your product source. The same flow works for both retail and brand accounts.

Sample CSV

Start from the template

The fastest way to get the format right is to download our sample CSV, open it in Google Sheets, and replace the example rows with your products.

1

Download the sample CSV

pricemaster-sample-products.csv — it contains the header row plus a handful of example product rows so you can see how each column should be populated.

2

Open it in Google Sheets

In Google Sheets choose File → Import → Upload, drop the CSV in, and select Replace spreadsheet. Set Convert text to numbers, dates, and formulas to No — this keeps the 13-digit GTINs as text instead of collapsing them into scientific notation like 5.01E+12.

3

Replace the example rows with your catalogue

Keep the header row as-is. Delete the sample rows once you've added at least one of your own products.

Required Columns

Column order and meaning

The first row must be a header row. The first ten columns must appear in this exact order; asin is matched by header name so it can be placed anywhere or left out.

  • gtin — global trade item number / barcode. Optional value but the column must exist.
  • sku — your SKU. Used as the product identifier if it's set.
  • mspn — manufacturer part number. Optional value.
  • title — product title shown in the app.
  • RRP — recommended retail price. Currency symbols are stripped automatically.
  • cost — your cost price. Used by margin calculations and rules.
  • stock — current stock level (integer).
  • image — public URL to a product image.
  • enabled — Y to track this product, N to import as disabled.
  • Category — free-text category label.
  • asin (optional) — Amazon ASIN. Pricemaster matches this column by header name, so it can be placed in any position or omitted.

If sku is blank we fall back to gtin, then mspn, then a synthetic identifier derived from the row.

Sharing Setup

Make the sheet readable by Pricemaster

Pricemaster reads your sheet over the public CSV export, so it needs view access via the link.

1

Open Share in Google Sheets

Top-right corner of the sheet, click Share.

2

Set General access to "Anyone with the link"

Under General access, change it from Restricted to Anyone with the link, and leave the role as Viewer.

3

Copy the link

Click Copy link. That's the URL you'll paste into Pricemaster.

Connecting In The App

Submit the onboarding form

1

Pick Google Sheets on the onboarding screen

From the onboarding "What platform are you using?" screen, click Google Sheets.

2

Fill in the form

Enter the site name and website URL, optionally a site logo, and paste the Google Sheet link you copied.

3

Submit

Pricemaster will verify it can read the sheet, count the rows, then create the site.

After You Connect

What happens next

For retail accounts, Pricemaster immediately kicks off the first product import in the background and walks you through the standard onboarding steps (match competitors, select competitors, set rules). The same daily-import job is then scheduled for your sheet.

For brand accounts, the site is created and you go straight into the products area — there's no competitor-matching step because brands publish prices rather than reprice against the market.

Edits you make to the Google Sheet later (RRP changes, new SKUs, stock updates) flow through on the next daily import.

Troubleshooting

Common errors

  • "Could not connect to Google Sheets" — the sharing setting is still Restricted. Switch it to Anyone with the link.
  • Product count looks wrong — make sure the first row is a header row and there are no blank rows between data rows.
  • Prices import as 0 — the RRP / cost columns are read as numbers with currency symbols stripped; values like £12.50 are fine, but completely empty cells will land as 0.
  • Stock values aren't whole numbers — the stock column is cast to integer. Use whole numbers only.