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.
[Read more]
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 |
YES |
| 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
| Name |
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
| Name |
DataType |
Length |
Raw |
Description |
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |
