Reference

Endpoint Update Sheet Data (Overwrite Cells)

Name

update_sheet_data

Description

Update data to spreadsheet on desired tab / cell location (i.e. start/end range). Limit is 10MB per request. [API reference]

Related Tables

[Dynamic Table] , Sheets

Parameters

Parameter Required Options
Name: Range

Label: Range for Table Boundary (Including Header)

Enter Range to detect Table column names and datatypes. Example: enter A1:C if you have table of 3 columns starting from Cell A1 		YES
Name: WriteRange

Label: Range for Data Cells

Cell Range which needs to be update. Example: Enter A2 if you like to start update from cell A2 		YES
Name: TabName

Label: 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.
Name: valueRenderOption

Label: valueRenderOption
Option Value
FORMATTED_VALUE FORMATTED_VALUE
UNFORMATTED_VALUE UNFORMATTED_VALUE
FORMULA FORMULA
Name: valueInputOption

Label: valueInputOption
Option Value
USER_ENTERED USER_ENTERED
RAW RAW
Name: majorDimension

Label: majorDimension
Option Value
DIMENSION_UNSPECIFIED DIMENSION_UNSPECIFIED
COLUMNS COLUMNS
ROWS ROWS
Name: dateTimeRenderOption

Label: dateTimeRenderOption
Option Value
SERIAL_NUMBER SERIAL_NUMBER
FORMATTED_STRING FORMATTED_STRING
Name: SpreadSheetId

Label: SpreadSheetId

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.
Option Value
Enter Your Sheet Id
Example Sheet Id 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
spreadsheetId DT_WSTR nvarchar(100) 100
updatedRange DT_WSTR nvarchar(255) 255
updatedRows DT_I4 int
updatedColumns DT_I4 int
updatedCells DT_I4 int
If the column you are looking for is missing, consider customizing Google Sheets Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the [Dynamic Table] table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to update sheet data:

API Destination - Google Sheets
Read / write Google Sheets data inside your app, perform many Google Sheets operations without coding using easy to use high performance API Connector for Google Sheets
Google Sheets
[Dynamic Table]
Update
Required Parameters
Range for Table Boundary (Including Header) Fill-in the parameter...
Range for Data Cells Fill-in the parameter...
Update Mode Fill-in the parameter...
Optional Parameters
ArrayTransformType TransformColumnslessArray
ArrayTransEnableCustomColumns True
ArrayTransCustomColumns Col1,Col2,Col3
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Update Sheet Data (Overwrite Cells) 

-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!

update_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:

Update Sheet Data (Overwrite Cells) 

DECLARE @MyQuery NVARCHAR(MAX) = '-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_SHEETS_IN_GATEWAY];

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