Skip to content

Files and storage

Connect Google Cloud Storage (GCS) to DataxLand

The Google Cloud Storage (GCS) connector reads CSV, Parquet, Avro or JSONL files in a GCS bucket. You declare each stream with a path pattern, for example every exports/orders_*.csv file, and it becomes one table in the workspace warehouse. When your systems already export data to GCS on a schedule, Si reads a masked sample to propose a mapping to the standard model, giving you net revenue, cost of goods and contribution margin just like an Excel upload, but refreshed automatically.

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

What you can do with Google Cloud Storage (GCS)

  • Build a profit and loss dashboard from order files exported to GCS every day.
  • Read tables exported from BigQuery to GCS as Parquet when you'd rather not grant dataset access.
  • Combine internal files with marketplace and ads data.

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 path pattern (glob) and a format; all matching files merge into one table.
CSVOptions for delimiter, character encoding and header row.
Parquet, AvroRead using the schema in the file.
JSONLOne JSON record per line.

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 inBucket, Authentication, 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 Cloud Storage (GCS) in 4 steps

  1. 1

    Create a service account

    In Google Cloud, create a service account with object read access on the bucket (Storage Object Viewer) and download its JSON key.

  2. 2

    Add the GCS source

    In the workspace choose Add source, find Google Cloud Storage, enter the Bucket, choose Service Account Authentication and paste the JSON key.

  3. 3

    Declare streams

    Add each stream with a name, path pattern and 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

  • The metrics on this page are examples for files with orders and cost of goods; actual metrics depend on the files you bring.
  • Each refresh reads only new or modified files; if new files repeat old rows, a primary key is needed to merge without duplicates.
  • Requires the Starter plan or above. This is an Airbyte connector (ELv2) run inside DataxLand.

Frequently asked questions

Is the service account key safe?

The key is encrypted when saved and never shown again; grant read-only access to just the bucket you need.

Can it read BigQuery directly?

Yes, with DataxLand's BigQuery source (incremental loads, Si investigates with read-only SQL); GCS fits when you only want to share files.

What about .xlsx files?

Use DataxLand's Excel source, or export to CSV before putting files on GCS.

Dashboard templates that use this source

All data sources →

Connect Google Cloud Storage (GCS) and get verified dashboards

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