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. |