Skip to content
+

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

MetricHow it is computed
Cost of goods soldUnits sold × cost per SKU in Google Sheets
Contribution marginNet revenue − cost of goods − marketplace fees − payment fees − seller-paid shippingFees come from TikTok Shop settlements.
COGS coverageOrder 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.

MetricDefinitionUnit
Cost of goods soldQuantity 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 marginNet 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 costCurrency
COGS coverageShare 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_totalRatio (%)
Marketing spend to revenue ratioTotal marketing spend (campaigns plus marketplace ads) divided by net retail revenue.= (Marketing spend + Ad spend) / Net revenueRatio (%)
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency

Common sheets

SheetKey columnsMetrics it unlocks
Cost of goodsSKU, unit cost, effective dateCost of goods, contribution margin, COGS coverage
Off-marketplace marketing spendDate, channel, costTotal marketing spend, spend to revenue ratio
SKU mappingInternal code, TikTok Shop codeMerges products when codes differ

Steps

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