跳到主要内容
版本:Next

GoogleSheets

GoogleSheets 源连接器

描述

用于从GoogleSheets读取数据.

关键特性

选项

名称类型必需默认值
service_account_keystring-
sheet_idstring-
sheet_namestring-
rangestring-
schemaconfig-

service_account_key [string]

谷歌云服务帐户,需要base64编码

sheet_id [string]

Google表格URL中的表格id

sheet_name [string]

要导入的工作表的名称

range [string]

要导入的 sheet 页的范围

schema [config]

fields [config]

上游数据的字段

示例

简单示例:

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
}
}
}

变更日志

Change Log
ChangeCommitVersion
[improve] google sheets options (#8922)https://github.com/apache/seatunnel/commit/48ede612dcdev
[Improve] restruct connector common options (#8634)https://github.com/apache/seatunnel/commit/f3499a6eebdev
[Improve][API] Make sure the table name in TablePath not be null (#7252)https://github.com/apache/seatunnel/commit/764d8b0bc82.3.7
[Feature][Kafka] Support multi-table source read (#5992)https://github.com/apache/seatunnel/commit/60104602d12.3.6
[Improve][Connector-V2] Replace CommonErrorCodeDeprecated.JSON_OPERATION_FAILED (#5978)https://github.com/apache/seatunnel/commit/456cd177142.3.4
[Improve][Common] Introduce new error define rule (#5793)https://github.com/apache/seatunnel/commit/9d1b2582b22.3.4
Support config column/primaryKey/constraintKey in schema (#5564)https://github.com/apache/seatunnel/commit/eac76b4e502.3.4
Merge branch 'dev' into merge/cdchttps://github.com/apache/seatunnel/commit/4324ee19122.3.1
[Improve][Project] Code format with spotless plugin.https://github.com/apache/seatunnel/commit/423b5830382.3.1
[improve][api] Refactoring schema parse (#4157)https://github.com/apache/seatunnel/commit/b2f573a13e2.3.1
[Improve][build] Give the maven module a human readable name (#4114)https://github.com/apache/seatunnel/commit/d7cd6010512.3.1
[Improve][Project] Code format with spotless plugin. (#4101)https://github.com/apache/seatunnel/commit/a2ab1665612.3.1
[Feature][shade][Jackson] Add seatunnel-jackson module (#3947)https://github.com/apache/seatunnel/commit/5d8862ec9c2.3.1
[Feature][Connector] add get source method to all source connector (#3846)https://github.com/apache/seatunnel/commit/417178fb842.3.1
[Hotfix][OptionRule] Fix option rule about all connectors (#3592)https://github.com/apache/seatunnel/commit/226dc6a1192.3.0
[Improve][Connector-V2][GoogleSheets] Unified exception for GoogleSheets source connector (#3524)https://github.com/apache/seatunnel/commit/eb42d629ad2.3.0
[Feature][Connector-V2][Google Sheets] Add Google Sheets option rules (#3364)https://github.com/apache/seatunnel/commit/da33f730ca2.3.0
fix: schema get error (#3361)https://github.com/apache/seatunnel/commit/fdaa85ed242.3.0
[Feature][Connector-V2][GoogleSheets] Support GoogleSheets Source (#3185)https://github.com/apache/seatunnel/commit/60ecc6428b2.3.0