⚠️ This feature is currently in Beta.

If your sheet looks correctly structured but Validate Sheet keeps failing with "failed to validate spreadsheet", your account may need Beta access enabled. A human agent on the Link My Books team will need to enable Beta access on your account so the validation step can complete — let us know you're trying to set up the Google Sheets product cost sync.

Step 1 — Sign in and Connect Google Sheets

Go to Inventory → Product Costs.
Click the Integrations tab.
Select Connect Google Sheets.
Choose the Google account that owns the spreadsheet.
Click Continue.
Click Allow to grant permissions.

Step 3 — Download the Template

Inside the Google Sheets setup window:

Click Download Template File.

This downloads a CSV containing the required structure.

Step 4 — Create the Google Sheet

To create a new Google Sheet file, go directly to https://sheets.new
Rename the file.

Step 5 — Import the Template

Inside the Google Sheet:

Click File then Import.
On the pop-up screen, go to the Upload tab and drag and drop the CSV file downloaded earlier.

When importing:

Set Import location to Replace spreadsheet to create a new sheet on the same file you just created.
Click Import data

The spreadsheet will now contain the data from the downloaded template:

SKU
Cost
Product Name
Product Group

Step 6 — Connect the Sheet

Copy the URL from the Google Sheets address bar.
Return to Link My Books.
Paste the URL into the Google Sheets URL field.
Click Validate Sheet.

💡 If "Validate Sheet" keeps failing

Most validation failures are caused by one of these:

• Column headings have been edited or columns added/removed (the template structure is required, even though you can map column order in the next step).

• The sheet contains duplicate SKUs.

• Cost values are blank or 0 (every row needs a cost of at least 0.01).

If the sheet structure is correct and validation still fails, your account may need Beta access enabled — a human agent on the Link My Books team can switch it on for you.

Step 7 — Map Columns

Users must confirm the column mapping.

Field	Required
SKU Column	Required
Cost Column	Required
Product Name	Optional
Product Group	Optional

Optional setting: Create new SKUs for unknown codes
When enabled, SKUs found in the spreadsheet but not in Link My Books will be automatically created.

Click Next, then Save & Connect.

Your Product Costs > Inventory page should now show the connected Google Sheet file.

Note: Changes sync twice a day automatically.

Changing the Google Sheet you are synced to

If you want to swap to a different spreadsheet — for example a new COGS sheet — disconnect the current one and connect the new one. Follow all four steps. Skipping step 3 is what leaves the old sheet showing.

Go to Inventory → Product Costs → Integrations.
Click Settings on the Google Sheets integration, then Disconnect.
Click Connect Google Sheets and re-authorise: choose the Google account that owns the new sheet, click Continue, then Allow.
Paste the new sheet's URL into the Google Sheets URL field, click Validate Sheet, then work through Columns and Confirm to Save & Connect.

⚠️ Old sheet still showing, or "Google Sheets not connected"?

Disconnecting also removes the Google account permission, so the new sheet cannot be validated until you re-authorise. If the old spreadsheet reappears after you refresh, or you see Google Sheets not connected, go back to step 3 and reconnect the Google account before pasting the new URL.

Disconnect Google Sheets

If you no longer want Link My Books to sync product costs from your Google Sheet, you can disconnect the integration.

Steps

Go to Inventory → Product Costs.
Click the Integrations tab.
Find the Google Sheets integration.
Click Settings.
Select Disconnect.

Once disconnected:

Link My Books will stop syncing any new product cost updates from Google Sheets.
The Google account permission is also removed. If you later want to connect a sheet again, you will need to re-authorise the Google account first.

How to Sync Product Costs from Google Sheets