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 . Spreadsheets . RetrieveWorksheet
Retrieves a specified worksheet from a Google spreadsheet in CSV, XML, or JSON format.
/*
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 retrieves a specified worksheet from a Google spreadsheet in CSV, XML, or JSON format. The Choreo returns worksheet data in CSV by default, but you can request XML or JSON by setting the optional ResponseFormat input.
There are two options for specifying the spreadsheet and worksheet you want to retrieve:
Note: This Choreo retrieves the worksheet feed using the list-based feed method described here. The feed will contain all rows after the first row up to the first blank row. The first blank row terminates the result set. If you find that expected data isn't appearing in the Choreo result, check the worksheet for an unexpected blank row in the middle of the data, and remove it. In particular, if the second row of the worksheet is empty, the list will contain no data.
Here is an example of acceptable inputs:
ClientID: {YOUR CLIENT ID}
ClientSecret: {YOUR CLIENT SECRET}
RefreshToken: {YOUR REFRESH TOKEN}
SpreadsheetName: MyNewSpreadsheet
WorksheetName: Sheet2
The following is a sample of the CSV information returned by this Choreo:
firstname,lastname,email Stan,Johnson,stan@temboo.com Lucy,Phillips,lucy@temboo.com John,Smith,john@temboo.com
https://ACCOUNT_NAME.temboolive.com/callback/google
© 2025 Temboo, Inc Privacy Terms