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 . AddWorksheet
Creates a new worksheet within an existing 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 adds a new worksheet to an existing Google spreadsheet using a specified SpreadsheetKey that you specify.
The SpreadsheetKey can be retrieved using the RetrieveSpreadsheetDetailsByName Choreo. It is also visible in your browser URL bar when viewing the spreadsheet. For example, in the URL below, the key is: 1jQs-kZ701HXdwMMtYO1dadsKtoxS57Vt5G92tdx1lcw.
https://docs.google.com/a/temboo.com/spreadsheets/d/1jQs-kZ701HXdwMMtYO1dadsKtoxS57Vt5G92tdx1lcw/edit#gid=1683670957
The documentation for this Google Spreadsheets resource can be found here.
Here is an example of acceptable inputs:
ClientID: {YOUR CLIENT ID}
ClientSecret: {YOUR CLIENT SECRET}
RefreshToken: {YOUR REFRESH TOKEN}
Title: Sheet2
SpreadsheetKey: 0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E
WorksheetId: od7
ColumnCount: 20
RowCount: 10
The following is a sample of the XML information returned by this Choreo:
<?xml version='1.0' encoding='UTF-8'?> <entry xmlns='http://www.w3.org/2005/Atom' xmlns:gs='http://schemas.google.com/spreadsheets/2006' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='"YDwreyI."'> <id>https://spreadsheets.google.com/feeds/worksheets/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od7</id> <updated>2011-11-21T17:22:05.253Z</updated> <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-11-21T17:22:05.253Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#worksheet'/> <title>My New Worksheet</title> <content type='application/atom+xml;type=feed' src='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od7/private/full'/> <link rel='http://schemas.google.com/spreadsheets/2006#cellsfeed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/cells/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od7/private/full'/> <link rel='http://schemas.google.com/visualization/2008#visualizationApi' type='application/atom+xml' href='https://spreadsheets.google.com/tq?key=0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E&sheet=od7'/> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/private/full/od7'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/private/full/od7'/> <gs:rowCount>10</gs:rowCount> <gs:colCount>5</gs:colCount> </entry>
https://ACCOUNT_NAME.temboolive.com/callback/google
© 2025 Temboo, Inc Privacy Terms