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​

name	type	required	default value
service_account_key	string	yes	-
sheet_id	string	yes	-
sheet_name	string	yes	-
range	string	yes	-
schema	config	no	-

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

Example​

simple:

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