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.
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.