⚠️ 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
Sign in to your Link My Books account and follow the steps below:
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. |
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.