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 . GetLastRow
Returns the last row in a sheet.
/*
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 returns the last row in a sheet. The documentation for this Google Sheets resource can be found here.
Note: This Choreo will return the last row in a spreadsheet. If your last row has only empty cells, the values property will not be present in the response. In this case, you may want to remove all empty rows from the end of your spreadsheet so that the last row with populated cells will be returned.
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
The following is a sample of the JSON information returned by this Choreo:
{ "range": "Sheet1!A100:C100", "majorDimension": "ROWS", "values": [ [ "100", "200", "300" ] ] }
https://ACCOUNT_NAME.temboolive.com/callback/google
© 2025 Temboo, Inc Privacy Terms