Update data to spreadsheet on desired tab / cell location (i.e. start/end range)
[API Help]
| Parameter |
Label |
Required |
Options |
Description |
| Range |
Range for Table Boundary (Including Header) |
YES |
|
Enter Range to detect Table column names and datatypes. Example: enter A1:C if you have table of 3 columns starting from Cell A1
|
| WriteRange |
Range for Data Cells |
YES |
|
Cell Range which needs to be update. Example: Enter A2 if you like to start update from cell A2
|
| 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.
|
