import ChangeLog from ‘../changelog/connector-google-sheets.md’;
GoogleSheets source connector
Used to read data from GoogleSheets.
name | type | required | default value |
---|---|---|---|
service_account_key | string | yes | - |
sheet_id | string | yes | - |
sheet_name | string | yes | - |
range | string | yes | - |
schema | config | no | - |
google cloud service account, base64 required
sheet id in a Google Sheets URL
the name of the sheet you want to import
the range of the sheet you want to import
the schema fields of upstream data
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 } } }