Google Sheets Connector
Documentation
Version: 9
Documentation
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]

Related Tables

[Dynamic Table] , Sheets

Parameters

Parameter Label Required Options Description
Range Range YES
TabName TabName NO 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 valueRenderOption NO
Option Value
FORMATTED_VALUE FORMATTED_VALUE
UNFORMATTED_VALUE UNFORMATTED_VALUE
FORMULA FORMULA
valueInputOption valueInputOption NO
Option Value
USER_ENTERED USER_ENTERED
RAW RAW
majorDimension majorDimension NO
Option Value
DIMENSION_UNSPECIFIED DIMENSION_UNSPECIFIED
COLUMNS COLUMNS
ROWS ROWS
dateTimeRenderOption dateTimeRenderOption NO
Option Value
SERIAL_NUMBER SERIAL_NUMBER
FORMATTED_STRING FORMATTED_STRING
SpreadSheetId SpreadSheetId NO
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 from [Dynamic Table] table using API Destination

This Endpoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Google Sheets
[Dynamic Table]
Select, Lookup
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read sheet data 

SELECT * FROM read_sheet_data
WITH
(
    "Range" = 'A1:GR'
)

read_sheet_data endpoint belongs to [Dynamic Table] , Sheets table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Read sheet data 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM read_sheet_data
WITH
(
    "Range" = ''A1:GR''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_SHEETS_IN_GATEWAY];

read_sheet_data endpoint belongs to [Dynamic Table] , Sheets table(s), and can therefore be used via those table(s).