import ChangeLog from '../changelog/connector-google-sheets.md';

GoogleSheets

GoogleSheets source connector

Description

Used to read data from GoogleSheets.

Key features

• batch
• stream
• exactly-once
• column projection
• parallelism
• support user-defined split
• file format
  • text
  • csv
  • json

Options

service_account_key [string]

google cloud service account, base64 required

sheet_id [string]

sheet id in a Google Sheets URL

sheet_name [string]

the name of the sheet you want to import

range [string]

the range of the sheet you want to import

schema [config]

fields [config]

The schema fields of upstream data. Please refer to Schema Feature.

Example

simple:

GoogleSheets {
  service_account_key = "seatunnel-test"
  sheet_id = "1VI0DvyZK-NIdssSdsDSsSSSC-_-rYMi7ppJiI_jhE"
  sheet_name = "sheets01"
  range = "A1:C3"
  schema = {
    fields {
      a = int
      b = string
      c = string
    }
  }
}

Changelog