Skip to content

Files and storage

Connect Google Drive to DataxLand

The Google Drive connector reads files in a Drive folder (CSV, JSONL, Parquet, Avro) and merges matching files into tables in the workspace warehouse. Many shops and accountants keep exports from their sales software or expense files on Drive: connect the folder once, and new files are read on the next refresh. Si proposes a mapping from a masked sample, then you get net revenue, cost of goods and contribution margin as the pack defines them.

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

What you can do with Google Drive

  • Update dashboards automatically when your accountant drops a new order file into the Drive folder each week.
  • Combine expense files on Drive with marketplace orders.
  • Stop uploading files to DataxLand by hand every time new numbers arrive.

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
(your stream name)Each stream has a name, a file name pattern (glob) and a format; all matching files in the folder merge into one table.
CSVOptions for delimiter, character encoding and header row.
JSONL, Parquet, AvroRead using the file's own structure.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inAuthentication, Folder Url, The list of streams to sync
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
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
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count

Connect Google Drive in 4 steps

  1. 1

    Grant read access

    Create a service account in Google Cloud, download its JSON key, then share the Drive folder with the service account's email as a viewer.

  2. 2

    Add the Google Drive source

    In the workspace choose Add source, find Google Drive, paste the Folder Url, choose Service Account Key Authentication and paste the JSON key.

  3. 3

    Declare streams

    Add a stream with a name, a file name pattern such as orders_*.csv and a format, then click Test connection.

  4. 4

    Review and build

    Si proposes a mapping to the standard model; you approve, then build.

Limits and caveats

  • Google Sheets spreadsheets use the Google Sheets connector; this connector is for files in a folder.
  • The metrics on this page are examples for files with orders and cost of goods; actual metrics depend on the files.
  • Each refresh reads only new or modified files; files with duplicate content need a primary key so rows are not counted twice.
  • Requires the Starter plan or above. This is an Airbyte connector (ELv2) run inside DataxLand.

Frequently asked questions

Do I need to share my whole Drive?

No. Share only the folder to read with the service account email, as a viewer.

What about Excel .xlsx files on Drive?

Use DataxLand's Excel source (upload), or save the files as CSV in the folder.

Does DataxLand delete or change files on Drive?

No. The connector is read-only.

Dashboard templates that use this source

All data sources →

Connect Google Drive and get verified dashboards

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