Data Visualization Quickstart Guide

Finally, you will run a configuration sketch to prepare your Yún for sending sensor data to Temboo.

If you're using a Yún: go to the File > Examples > Temboo > ArduinoYun menu and run the TembooDeviceConfig sketch.

If you're using a Yún shield: go to the File > Examples > Temboo > YunShield menu and run the TembooDeviceConfig sketch.

Use the dropdown menu at the top of the Choreo page to select as your platform.

The first step in monitoring sensor data is to set up the sensor you wish to monitor. We provide unit converted data for specific sensor models, such as Celsius and Fahrenheit for temperature sensors. We also support unconverted data which is reported as raw values for analog data and high/low for digital.

For this tutorial we're going to read temperature data from a Texas Instruments LMT84P. Our unit conversion formula assumes that your temperature sensor is connected to your 's 5V pin for its voltage in, and set up as specified in the sensor's data sheet.

Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category Temperature, then choose the Texas Instruments LMT84LP.

Each time you set up a sensor you'll be asked to specify the safe bounds and the caution bounds. These bounds are used to determine the color coding of the data that appears on your graph. Safe data is colored green and data near the bounds is orange. Data outside the bounds is red.

Set the safe bounds as 40º and 45º, and the caution bounds as 5º. That's all we need to do to set up our sensor, so press Save.

We will focus only on getting sensor data graphs running, so set a condition based on your sensor so that it doesn't trigger the email. Use the conditions interface to set a condition that will always be false so we don't send any emails.

Next, we'll generate the code that will send our sensor data to Temboo. Scroll down and find the code box. Click the triangle next to Simple Code to open the code menu, and choose Enhanced Code.

Now you will register your device. To do so, name your device and, optionally, give it a description. Specify the device location—this will allow you to view your devices on a map. For testing purposes, it's good to set a relatively short sensor interval so that you can see sensor data populate your graphs quickly. You can use the custom interval option for this. Press Save when you're done.

In order to run this sketch, it needs to be configured with an appropriate TembooAccount.h header file containing your Temboo account information. Header files for certain boards will also include the device’s internet connection details.

To create the header file, make a new tab in the IDE, and name it TembooAccount.h.

Now that your code is running, open a new browser window to head over to your Devices page to see it in action. A virtual representation of your device will be waiting for you.

Select your new device and you'll see a sensor data graph for the sensor that you set up. Over time, you'll be able to see sensor data graphs for various time periods. Additionally, at any time, you can request the latest value of your sensors. This is a handy feature for when you're between sensor intervals but want to know what's happening on your device.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

We are logging sensor readings, so we need to set up a sensor. For this tutorial we're going to read temperature data from a Texas Instruments LMT84P.

Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category 'Temperature', and name your sensor.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

To dynamically insert sensor values into your Values JSON, use the blue sensor icon in the corner of the Values input field. Take care when inserting dynamic values into JSON.

In order to run this sketch, it needs to be configured with an appropriate TembooAccount.h header file containing your Temboo account information. Header files for certain boards will also include the device’s internet connection details.

To create the header file, make a new tab in the IDE, and name it TembooAccount.h.

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

If this is your first time using Temboo, you'll need to set up your ARTIK board to find the Temboo libraries. To do so, you'll need to create the file temboo.conf in /etc/ld.so.conf.d. Inside of temboo.conf, you'll want to copy the line below and paste it into the file:

/opt/iothub/artik/temboo/temboo_artik_library/lib

You’ll also need to get the IP address of your ARTIK board using ifconfig. The example below shows the results when the ARTIK board is connected to the internet through an ethernet cable. The IP address you'll want to use is listed next to inet.

[root@localhost ~]$ ifconfig
eth0: flags=4163  mtu 1500
        inet 10.11.6.200  netmask 255.255.255.0  broadcast 10.11.6.255

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

We are logging sensor readings, so we need to set up a sensor. For this tutorial we're going to read temperature data from a Texas Instruments LMT84P.

Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category 'Temperature', and name your sensor.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

To dynamically insert sensor values into your Values JSON, use the blue sensor icon in the corner of the Values input field. Take care when inserting dynamic values into JSON.

Download the generated code to your computer by clicking Download source code to the right of the code.

Copy the downloaded zip file to your ARTIK board using scp. From your computer, go to the directory where the zip file is located and type the command below. Make sure you use the IP address for your board you found using ifconfig.

[root@localhost ~]$ scp .zip root@xxx.xxx.xxx.xxx:/home

From the ARTIK command line (either through a serial terminal or ssh session), change your current directory to /home. Next, unzip the generated code you just copied over. You can unzip the file by using the command below:

[root@localhost ~]$ unzip .zip

Now go to the directory and compile and run your code using the commands below. Run the first command to compile your code. After compiling has finished and no errors have been reported, run your program using the second command. After running the program, you should see the response from in your console.

[root@localhost ~]$ gcc -L/opt/iothub/artik/temboo/temboo_artik_library/lib -ltemboo -I/opt/iothub/artik/temboo/temboo_artik_library/include s.c -o 
[root@localhost ~]$ ./

Note: If you get an error about cdefs.h not being found, this could mean your ARTIK board was not shipped with glibc-headers. This can be solved by reinstalling glibc-headers using the command below. After reinstalling glibc-headers, run the two commands above to compile and run your code.

[root@localhost ~]$ yum reinstall glibc-headers

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

We are logging sensor readings, so we need to set up a sensor. For this tutorial we're going to read temperature data from a Texas Instruments LMT84P.

Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category 'Temperature', and name your sensor.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

To dynamically insert sensor values into your Values JSON, use the blue sensor icon in the corner of the Values input field. Take care when inserting dynamic values into JSON.

In order to run this sketch, it needs to be configured with an appropriate TembooAccount.h header file containing your Temboo account information. Header files for certain boards will also include the device’s internet connection details.

To create the header file, make a new tab in the IDE, and name it TembooAccount.h.

The final step before running any sketch is to confirm that you've selected the appropriate board and serial port in Energia. Go to the Tools > Board menu and select the LaunchPad you're working with. Then go to Tools > Serial Port and select the port your board is connected to.

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Use the dropdown menu at the top of the Choreo page to select as your platform.

The first step in monitoring sensor data is to set up the sensor you wish to monitor. We provide unit converted data for specific sensor models, such as Celsius and Fahrenheit for temperature sensors. We also support unconverted data which is reported as raw values for analog data and high/low for digital.

For this tutorial we're going to read temperature data from a Texas Instruments LMT84P. Our unit conversion formula assumes that your temperature sensor is connected to your 's 5V pin for its voltage in, and set up as specified in the sensor's data sheet.

Using the virtual pin board on the Choreo page, select pin to set up your sensor. Select the category Temperature, then choose the Texas Instruments LMT84LP.

Each time you set up a sensor you'll be asked to specify the safe bounds and the caution bounds. These bounds are used to determine the color coding of the data that appears on your graph. Safe data is colored green and data near the bounds is orange. Data outside the bounds is red.

Set the safe bounds as 40º and 45º, and the caution bounds as 5º. That's all we need to do to set up our sensor, so press Save.

We will focus only on getting sensor data graphs running, so set a condition based on your sensor so that it doesn't trigger the email. Use the conditions interface to set a condition that will always be false so we don't send any emails.

Next, we'll generate the code that will send our sensor data to Temboo. Scroll down and find the code box. Click the triangle next to Simple Code to open the code menu, and choose Enhanced Code.

Now you will register your device. To do so, name your device and, optionally, give it a description. Specify the device location—this will allow you to view your devices on a map. For testing purposes, it's good to set a relatively short sensor interval so that you can see sensor data populate your graphs quickly. You can use the custom interval option for this. Press Save when you're done.

Scroll down to the code box of the Choreo page. Click Send to CCS Cloud to the right of your generated code. Name your application and click Send. Click the link that appears to visit the CCS Cloud IDE in your browser.

Run the code on your CC3220 from CCS Cloud. After running the code, open the Serial Monitor and you'll see the response from the Choreo.

Now that your code is running, open a new browser window to head over to your Devices page to see it in action. A virtual representation of your device will be waiting for you.

Select your new device and you'll see a sensor data graph for the sensor that you set up. Over time, you'll be able to see sensor data graphs for various time periods. Additionally, at any time, you can request the latest value of your sensors. This is a handy feature for when you're between sensor intervals but want to know what's happening on your device.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

Because network operations block the main thread execution, we'll need to make our calls to Temboo using AsyncTask. Create a new class that extends AsyncTask called SheetsTask (or whatever you like), adding the @Override implementations for doInBackground and onProcessComplete:

package com.temboo.android.gettingstarted.app;

import android.os.AsyncTask;
import android.util.Log;
import android.widget.TextView;

/**
 * An AsyncTask that will be used to interact with Temboo
 */
class SheetsTask extends AsyncTask<Void, Void, String> {

    private TextView textView;

    public SheetsTask(TextView textView){
        this.textView = textView;
    }

    @Override
    protected String doInBackground(Void... arg0) {
        try {
            // Temboo code will go here
        } catch(Exception e) {
            // if an exception occurred, log it
            Log.e(this.getClass().toString(), e.getMessage());
        }
        return null;
    }

    protected void onPostExecute(String result) {
        try {
            // Will update UI here
        } catch(Exception e) {
            // if an exception occurred, show an error message
            Log.e(this.getClass().toString(), e.getMessage());
        }
    }
}

Now that our AsyncTask is set up, copy the generated code snippet from the Temboo website and paste it into the doInBackground method of your AsyncTask class. We'll also add the required imports to create a AppendValues Choreo, AppendValuesInputSet, and AppendValuesResultSet:

import com.temboo.Library.Google.Sheets.AppendValues;
import com.temboo.Library.Google.Sheets.AppendValues.AppendValuesInputSet;
import com.temboo.Library.Google.Sheets.AppendValues.AppendValuesResultSet;
import com.temboo.core.TembooSession;

Add the following code at the bottom of the try block of the doInBackground method in your class:

return appendValues.get_Response() ;

The return value we've just added is passed by Android as an argument to the onPostExecute method, we'll update the UI there:

    protected void onPostExecute(String result) {
        try {
            // Update the UI
            textView.setText(result);
        } catch(Exception e) {
            // if an exception occurred, show an error message
            Log.e(this.getClass().toString(), e.getMessage());
        }
    }

In order to see your new task in action, you will need to invoke it from the MainActivity class created with your project. The simplest way to do this is to add a call to it in the onCreate method, which should end up looking like this:

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    TextView textView = (TextView) findViewById(R.id.response);
    new SheetsTask(textView).execute();
}

In order to post dynamic values to your sheet from your Android application, you'll need to build a String object to pass as input to the AppendValues Choreo. Create a String object containing properly formatted JSON in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then pass it to appendValuesInputs.set_Values() like so:

appendValuesInputs.set_Values(customValueSet);

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

In order to post dynamic values to your sheet from your C# application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then edit appendValuesChoreo.setValues(), passing in customValueSet like so:

appendValuesChoreo.setValues(customValueSet);

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

Finally, update the main method in main.m with the code below so that your file calls the AppendValues Choreo:

int main(int argc, const char * argv[]) {

    @autoreleasepool {
		// Create a new instance of our class
		AppendValues *tutorial = [[AppendValues alloc] init];
        
		// Run it
		[tutorial runAppendValuesChoreo];
        
		// Only needed for command line tools, this simply keeps the program from exiting immediately
		[[NSRunLoop currentRunLoop] run];
	}
    return 0;
}

In order to post dynamic values to your sheet from your iOS application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then edit appendValuesInputs setValues, passing in customValueSet like so:

[appendValuesInputs setValues:customValueSet];

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

In order to post dynamic values to your sheet from your Java application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then edit appendValuesInputs.set_Values(), passing in customValueSet like so:

appendValuesInputs.set_Values(customValueSet);

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Change the name of the resulting folder to php-sdk and move it into the same folder as your temboo-example.html file. Your project folder should look similar to the screenshot below:

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

In your temboo-example.html file, make sure that your script source points to the correct location of the temboo.js SDK file.

<script src="js-sdk/js/temboo.js"></script>

In the same file, we'll also want to confirm that the location of our proxy is correctly specified. Our server is proxy-server.php.

// Instantiate the client proxy with the URI of your server proxy
var temboo = new TembooProxy('proxy-server.php');

Back on the Choreo page, scroll down to the Proxy Code snippet and select PHP or another server-side proxy language from the Proxy Code Language dropdown menu. Copy the proxy code snippet and paste it into your proxy-server.php file.

In the same .php file, make sure that the line points to the correct location of the php-sdk SDK folder that you downloaded earlier.

require 'php-sdk/src/temboo.php';

In order to post dynamic values to your sheet from your web application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then edit appendValuesChoreo.setInput(), passing in customValueSet like so:

appendValuesChoreo.setInput('Values', customValueSet);

Run the PHP server. For instance, if you're running the code using a web host, you can upload your project folder to your site via FTP client. If you're using Apache for PHP to run a local server, you'd run the following command from Terminal:

sudo apachectl start

Go to temboo-example.html in the browser at the url where you're server is running. For instance, if you're running the PHP server locally:

127.0.0.1/projectFolderName/temboo-example.html

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

Make sure that all of your import statements are included. Both of the following lines should be present and uncommented in your code.

var tsession = require("temboo/core/temboosession");
var Google = require("temboo/Library/Google/Sheets");

In order to post dynamic values to your sheet from your Node.js application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then edit appendValuesInputs.set_Values(), passing in customValueSet like so:

appendValuesInputs.set_Values(customValueSet);

Now you're ready to run the script to post values to Google Sheets. Here's the command you need to run if you're executing this from the command line. Otherwise just run it from your IDE.

node tembootest.js

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Unzip the downloaded SDK and move the resulting php-sdk folder into the same parent folder as your new, blank PHP file.

Add the Temboo PHP SDK to your script:

require 'php-sdk/src/temboo.php';

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

In order to post dynamic values to your sheet from your PHP application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then edit $appendValuesInputs->setValues(), passing in customValueSet like so:

$appendValuesInputs->setValues($customValueSet);

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

In order to run this sketch, your Temboo account name and application details must be included in the TembooSession, like so:

When you're logged in, this information is automatically populated in your generated sketch. Remember to remove your account details if you share your sketch.

In order to post dynamic values to your sheet from your Processing sketch, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then edit appendValuesChoreo.setValues(), passing in customValueSet like so:

appendValuesChoreo.setValues(customValueSet);

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

In order to post dynamic values to your sheet from your Python script, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it custom_value_set or whatever you like, then edit appendValuesInputs.set_Values(), passing in custom_value_set like so:

appendValuesInputs.set_Values(custom_value_set)

Now you're ready to run the script and post the data to your Google Sheet. Here's the command you need to run if you're executing this from the command line. Otherwise just run it from your IDE.

python TembooTest.py

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

Make sure your imports are in place at the top of the file. They should look like the sample below.

require "temboo"
require "Library/Google"

In order to post dynamic values to your Sheet from your Ruby application, you'll need to build a JSON string to pass as input to the AppendValues Choreo. Create a properly formatted JSON string in your code that includes any variables you wish to post to your sheet and name it customValueSet or whatever you like, then edit appendValuesInputs.set_Values(), passing in customValueSet like so:

appendValuesInputs.set_Values(customValueSet);

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.

Save the Consent Screen details and specify the callback URL below as the Authorized Redirect URI. Make sure to replace ACCOUNT_NAME with your Temboo account name.

https://ACCOUNT_NAME.temboolive.com/callback/google

Go to the Google > OAuth > InitializeOAuth Choreo page, and fill in the Client ID from the app you registered at Google and the following Scope: https://www.googleapis.com/auth/spreadsheets . Then click Generate Code to run the Choreo from our site. The InitializeOAuth Choreo will return an authorization URL and a callback ID (required for the FinalizeOAuth step).

Open a new web browser, navigate to the authorization URL returned by the InitializeOAuth Choreo, and click Accept to grant the app access to your Google account.

Create a Google Spreadsheet. When viewing your spreadsheet, you'll see a spreadsheet ID in your browser's URL bar. Copy this ID because you'll need it when running the AppendValues Choreo. In the example below, the highlighted part is the Spreadsheet ID.

Select from the drop down menu at the top of the page.

Next, fill in the SpreadsheetID from your Google Sheet's URL, and the Values you wish to send.

The Values input should be formatted in JSON as an array of arrays.

[
  [
    "100",
    "200",
    "300"
  ]
]

To send a single row, you'll specify just one inner array as shown above, and each item in the inner array will represent a cell value in a row. To send multiple rows, add additional inner arrays e.g.:

[
  [
    "100",
    "200",
    "300"
  ],
  [
    "400",
    "500",
    "600"
  ]
]

Click Generate Code to test your inputs from the Temboo site, and you'll see the value "true" for the Success output in the Output section. If you check your Google Sheet, you’ll see that new values have appeared.

Clean-looking data visualization is built-in to Sheets. Just select the range of data you want to graph and select Insert > Chart to get Sheets’ recommendations on the best visualizations for your dataset.

See the Google Sheets documentation for more information about formatting your chart.

Conditional formatting can communicate your data at a glance. Charts aren’t the only way to visually communicate data. Setting conditional formatting rules about what the incoming data means to you can boost legibility.