Read google spreadsheet data from desired tab / cell location (i.e. start/end range)
[API Help]
| Parameter |
Label |
Required |
Options |
Description |
| Range |
Range |
YES |
|
|
| 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.
|
