You have no favorites... yet!
Use the Library tree on the left to select a Choreo to call from your gateway device.
Use the Library tree on the left to select a Choreo to call from your edge device via the gateway.
Library . Google . Sheets . BatchUpdateValues
Updates values in one or more ranges of a spreadsheet.
/*
TembooTask class placeholder
*/
/*
TembooTask header placeholder
*/
Since you've changed your device configuration, you'll need to tell us about this new device.
This feature is in experimental mode - pricing coming soon.
Send your code straight to a GitHub repository.
Your code will be visible by others in your repos. Keep credentials private by saving a Profile or commit code with Placeholder inputs.
The following files will be added to this repo:
You'll be able to edit and share your code from TI's CCS Cloud IDE.
The following will be sent to CCS Cloud:
/*
Your auto-generated code will appear here once you've configured your device above.
*/
/*
A header file containing your Temboo account information will appear here once you've
configured your device above.
*/
/*
Please log in to generate proxy server code for use with the JavaScript SDK.
*/
This Choreo updates values in one or more ranges of a spreadsheet. The documentation for this Google Sheets resource can be found here.
Note: this Choreo requires a SpreadsheetID which can be found in the URL when veiwing your spreadsheet at Google. The ID will be in this part of the URL:
https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit#gid=0
The optional Fields input is used to limit the number of fields returned in the response. This is useful when a response is large and when your application only needs a specific property returned in the response. You can read more about the syntax used with this input here.
Here is an example input set:
ClientID: {YOUR CLIENT ID}
ClientSecret: {YOUR CLIENT SECRET}
RefreshToken: {YOUR REFRESH TOKEN}
SpreadsheetID: 1nO26nl0L2rlpwSDyjztNqzBFf9UUs5yPbjx-FirIexA
Data:
[ { "range": "Sheet1!A4:C4", "values": [ [ "a", "b", "c" ] ] }, { "range": "Sheet1!A7:C7", "values": [ [ "d", "e", "f" ] ] } ]
The following is a sample of the JSON information returned by this Choreo:
{ "spreadsheetId": "1nO26nl0L2rlpwSDyjztNqzBFf9UUs5yPbjx-FirIexA", "totalUpdatedRows": 2, "totalUpdatedColumns": 3, "totalUpdatedCells": 6, "totalUpdatedSheets": 1, "responses": [ { "spreadsheetId": "1nO26nl0L2rlpwSDyjztNqzBFf9UUs5yPbjx-FirIexA", "updatedRange": "'Sheet1'!A4:C4", "updatedRows": 1, "updatedColumns": 3, "updatedCells": 3 }, { "spreadsheetId": "1nO26nl0L2rlpwSDyjztNqzBFf9UUs5yPbjx-FirIexA", "updatedRange": "'Sheet1'!A7:C7", "updatedRows": 1, "updatedColumns": 3, "updatedCells": 3 } ] }
https://ACCOUNT_NAME.temboolive.com/callback/google
© 2025 Temboo, Inc Privacy Terms