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 . AddListRows
Adds one or more rows to a worksheet in a Google spreadsheet using a simple XML file you provide.
/*
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 one or more rows to a worksheet in a Google spreadsheet using a simple XML file you provide. The XML you submit to the Choreo must be in the following schema:
<rowset> <row> <firstname>stan</firstname> <lastname>johnson</lastname> <email>stan@temboo.com</email> </row> <row> <firstname>john</firstname> <lastname>smith</lastname> <email>john@temboo.com</email> </row> </rowset>
The column names above are just examples. You can have as many columns as you want, but they must correspond exactly to existing column names in your Google worksheet. Note that since column names exist as XML element names in a Google feed, characters that result in invalid XML element names are converted to a valid naming convention in the feed. For this reason, the column names that you provide in the RowsetXML should follow this convention too. For example, if your column name is "First Name", the column name in the RowsetXML that you provide should be: <FirstName></FirstName>
or <firstname></firstname>
(column names with upper-case letters are converted to lower-case in a Google feed, but you can use upper-case in the RowsetXML if you want). Any character that is not legal in XML element names (such as a space or ampersand) should be removed.
The SpreadsheetKey and WorksheetId are required and can be retrieved using the RetrieveSpreadsheetDetailsByName Choreo.
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}
SpreadsheetKey: 0ArNdNVaZJYRqdGJiZ3M3MEE2ZU42NUlLcFlOTHdlN1E
WorksheetId: od6
RowsetXML:
<rowset> <row> <firstname>stan</firstname> <lastname>johnson</lastname> <email>stan@temboo.com</email> </row> </rowset>
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:gsx='http://schemas.google.com/spreadsheets/2006/extended' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='"H1hBIjt7Myt7ImA9CEACRkkN"'> <id>https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/c0p7u</id> <updated>2011-11-29T20:44:22.042Z</updated> <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-11-29T20:44:22.042Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/> <title>stan</title> <content>lastname: johnson, email: stan@temboo.com</content> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/c0p7u'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/0Aryw6-lKEQSZdE5EOE54YU05NDExcE1pRVhSLWdYc0E/od4/private/full/c0p7u'/> <gsx:firstname>stan</gsx:firstname> <gsx:lastname>johnson</gsx:lastname> <gsx:email>stan@temboo.com</gsx:email> </entry>
https://ACCOUNT_NAME.temboolive.com/callback/google
© 2025 Temboo, Inc Privacy Terms