⚠️ 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. Please contact our support team via the blue chat icon or at [email protected] and let us know you're trying to set up the Google Sheets product cost sync. We'll enable Beta access on your account so the validation step can complete.
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 — please contact support and we'll sort it.
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.
If you have any questions about this article or feedback on how we could make it better please reach out to the support team via the blue chat icon on the bottom right of the page or via email to [email protected].