Skip to content

Files and storage

Connect Google Sheets to DataxLand

Google Sheets fits the tables you still edit by hand every day - cost per SKU, sales targets, marketing budget, fixed costs. Unlike an uploaded Excel file, DataxLand reads the spreadsheet on a schedule, so new numbers reach the dashboard without exporting anything. Each tab becomes a table in the workspace warehouse; Si proposes how to join them with marketplace, website or accounting data, for example product cost with order lines for contribution margin.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with Google Sheets

  • Keep your cost table in Google Sheets and get contribution margin for Shopee, TikTok Shop and Lazada orders.
  • Set monthly sales targets in a sheet and track attainment on the dashboard.
  • Manage marketing budget and monthly costs without retyping them into other software.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
<tab name>Each tab (worksheet) becomes a table; first row as column names, with an option to normalise column names.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run)
Fields to fill inAuthentication, Spreadsheet Link
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2
Technical docsConnector documentation ↗

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
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
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 (%)
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
Sales targetTotal sales targets of sales reps. Targets are set monthly and recorded on the first day of the month.Currency
Quota attainmentWon amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales targetRatio (%)
Campaign budgetTotal budget of campaigns starting in the period. The full campaign budget is recorded on its start date.Currency
Expense budgetBudget for selling and administrative expense accounts. Budgets are set monthly, recorded on the first day of the month.Currency

Connect Google Sheets in 3 steps

  1. 1

    Create access

    In Google Cloud, create a service account and download its JSON key; share the spreadsheet with the service account's email as a viewer.

  2. 2

    Add the source

    In the workspace choose Add source, find Google Sheets in the connector library, paste the spreadsheet link and the JSON key, click Test connection.

  3. 3

    Pick tabs and review

    Choose the tabs to load; Si proposes what each tab is (cost, target, budget) and how it joins other sources; you approve and build.

Limits and caveats

  • The Google Sheets connector reloads fully on each refresh, so the fastest refresh is hourly.
  • The form also accepts your own OAuth client (client ID, secret, refresh token), but DataxLand does not run the Google sign-in for you; a service account is the simplest path.
  • Keep the first row as column names and avoid merged cells in the data range.
  • This is an Airbyte connector (ELv2 license) run inside DataxLand; you need no Airbyte account.

Frequently asked questions

How is this different from sending reports to Google Sheets?

This page reads data from Sheets into DataxLand. The other direction, sending a metrics table to a sheet on a schedule, is a separate report channel.

How soon does the dashboard reflect a sheet edit?

At the next scheduled refresh, or right away when you refresh the source.

Does the Free plan include it?

No; the Free plan takes Excel files only. Google Sheets is available from the Starter plan.

Dashboard templates that use this source

Ask Si about your Google Sheets data →Google Sheets + TikTok Shop →Google Sheets + PostgreSQL →All data sources →

Connect Google Sheets and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes