Google Sheets Connector
Google Sheets Connector Help
Version 5
ZappySys Logo File Version: v5
Supported Engine: 9

EndPoint Insert Sheet Data (Append at the end)


Name

insert_sheet_data

Description

Append data to spreadsheet on desired tab. Data is appended after last non-empty row/cell location. You can supply cell offset to start scan to find non-empty cell. [API Help]

Parameters

Parameter Label Required Options Description
Range Start Range YES This is the range in which next row location is detected based on first empty cell and row (Examples: A1, A1:GR, A1:GR200). This range is also used to detect metadata. Values are appended after the last row of the table.
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 DataType Length Raw Description
spreadsheetId DT_WSTR 100 False
tableRange DT_WSTR 255 False
updatedRange DT_WSTR 255 False
updatedRows DT_I4 0 False
updatedColumns DT_I4 0 False
updatedCells DT_I4 0 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.