EndPoint Read Sheet Data

Name

read_sheet_data

Description

Read google spreadsheet data from desired tab / cell location (i.e. start/end range) [API reference]

Parameters

Parameter

Label

Required

Options

Description

Range

YES

TabName

If you have multiple tabs on your spreadsheet then you can specify here. By default first tab is used if you do not enter.

valueRenderOption

Option	Value
FORMATTED_VALUE	FORMATTED_VALUE
UNFORMATTED_VALUE	UNFORMATTED_VALUE
FORMULA	FORMULA

valueInputOption

Option	Value
USER_ENTERED	USER_ENTERED
RAW	RAW

majorDimension

Option	Value
DIMENSION_UNSPECIFIED	DIMENSION_UNSPECIFIED
COLUMNS	COLUMNS
ROWS	ROWS

dateTimeRenderOption

Option	Value
SERIAL_NUMBER	SERIAL_NUMBER
FORMATTED_STRING	FORMATTED_STRING

SpreadSheetId

Option	Value
Enter Your Sheet Id
Example Sheet Id	1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

Enter unique spreadsheet Id. To obtain sheet Id. Open spreadsheet in browser and check URL. You will example value like 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms that is your sheet id.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

If the column you are looking for is missing, consider customizing Google Sheets Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Google Sheets Connector in API Source component to read data or in API Destination component to read/write data:

Read Sheet Data using API Source

Google Sheets

Read Sheet Data

SSIS API Source - Read from table or endpoint

Read Sheet Data using API Destination

Google Sheets

Read Sheet Data