Combine Google Sheets with TikTok Shop: costs that update themselves
Many TikTok sellers keep purchase prices, packaging costs, KOC fees and fixed costs in a Google Sheet shared with their accountant. TikTok Shop knows none of these numbers. Connect that spreadsheet to TikTok Shop and DataxLand joins cost per SKU to every order line and computes contribution margin, profit after ads and COGS coverage. Unlike an Excel file, Google Sheets is read again on your plan's refresh schedule, so when the accountant edits a purchase price in the sheet, the next build uses the new number and nobody has to upload a file again.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- Cost of goods and KOC fees usually live outside the marketplace; without them you cannot tell which products make money.
- The shared spreadsheet is the accountant's source of truth; reading it directly avoids drift between copies.
- Scheduled refreshes keep the profit dashboard in step with new purchase prices.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Cost of goods sold | Units sold × cost per SKU in Google Sheets |
| Contribution margin | Net revenue − cost of goods − marketplace fees − payment fees − seller-paid shippingFees come from TikTok Shop settlements. |
| COGS coverage | Order line revenue with a known cost ÷ total order line revenue |
| Total marketing spend to revenue | (Marketing spend + ad spend) ÷ net revenueLog KOC costs by day in a separate sheet to get this metric. |
Standard metrics from the analytics packs
Once both sources map to the same model, these metrics run on the joined data with one definition.
| Metric | Definition | Unit |
|---|---|---|
| Cost of goods sold | Quantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS. | Currency |
| Contribution margin | Net revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return cost | Currency |
| COGS coverage | Share of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_total | Ratio (%) |
| Marketing spend to revenue ratio | Total marketing spend (campaigns plus marketplace ads) divided by net retail revenue.= (Marketing spend + Ad spend) / Net revenue | Ratio (%) |
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
Common sheets
| Sheet | Key columns | Metrics it unlocks |
|---|---|---|
| Cost of goods | SKU, unit cost, effective date | Cost of goods, contribution margin, COGS coverage |
| Off-marketplace marketing spend | Date, channel, cost | Total marketing spend, spend to revenue ratio |
| SKU mapping | Internal code, TikTok Shop code | Merges products when codes differ |
Steps
- 1
Connect TikTok Shop
Click Connect with TikTok Shop, sign in to your seller account and grant read access to orders, settlements, returns and products.
- 2
Connect Google Sheets
Paste the spreadsheet link and a service account key (share the spreadsheet with the service account email), or your own OAuth client details.
- 3
Review Si's mapping
Si reads the column names and a masked data sample, proposes which sheet holds costs, which holds marketing spend and how SKUs match; you approve.
- 4
Build and read the dashboards
The Products, P&L overview and Total marketing spend dashboards update on schedule; ask Si which SKUs lost money this week.
Frequently asked questions
Is Google Sheets loaded incrementally?
No. The Google Sheets connector rereads the whole spreadsheet on every refresh, so it suits sheets of a few thousand to a few tens of thousands of rows, such as costs and expenses. Larger data belongs in a database.
What if I rename a column in the spreadsheet?
The data check flags it when an approved column disappears. You review the mapping again for the new column; the dashboard never silently uses the wrong column.
Which plan can combine two sources?
The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.
Dashboard templates that use this source
Connect Google Sheets →Connect TikTok Shop →Ask Si about your Google Sheets data →Ask Si about your TikTok Shop data →
Other combinations
Combine Google Sheets and TikTok Shop in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes