Difference between revisions of "EBC Exercise 37 Logging to Sheets"

From eLinux.org
Jump to: navigation, search
m (Plot the Data)
m (Run the example)
Line 26: Line 26:
  
 
== Run the example ==
 
== Run the example ==
* Edit either '''demo.js''' or '''demo.py''' and change the '''sheetID''' string to the string you noted above.
+
=== JavaScript ===
 +
* Edit '''demo.js''' and change the '''sheetID''' string to the string you noted above.
 +
* Load the API
 +
bone$ '''npm install googleapis'''
 +
* Then, run the example on your Bone.  The arguments are the values to be logged on the sheet.
 +
bone$ '''./demo.js 3.14 10'''
 +
 
 +
=== Python ===
 +
* Edit '''demo.py''' and change the '''sheetID''' string to the string you noted above.
 +
* Load the API
 +
bone$ '''pip3 install --upgrade google-api-python-client oauth2client'''
 +
* Run
  
 
Then, run the example on your Bone.  The arguments are the values to be logged on the sheet.
 
Then, run the example on your Bone.  The arguments are the values to be logged on the sheet.
 
bone$ '''./demo.js 3.14 10'''
 
or
 
 
  bone$ '''./demo.py 3.14 10'''
 
  bone$ '''./demo.py 3.14 10'''
  

Revision as of 12:06, 10 October 2018

thumb‎ Embedded Linux Class by Mark A. Yoder


Here are instructions on how to log data to a Google Sheet from JavaScript.

Create a new Sheet

Create a new sheet by:

  • Going to https://sheets.google.com and clicking to Start a new spreadsheet, Blank
  • Give the sheet a meaningful name
  • Enter some column labels

Blank Google Sheet

  • Note the sheetID in the path

SheetID

Get Credentials

Go to the class repo and change to the sheets directory

bone$ cd exercises/iot/google/sheets

If you are using JavaScipt, go to https://developers.google.com/sheets/api/quickstart/nodejs and follow step 1.

If you are using Python, got to https://developers.google.com/sheets/api/quickstart/python and follow step 1.

Either way put the credentials.json file in the sheets directory.

Run the example

JavaScript

  • Edit demo.js and change the sheetID string to the string you noted above.
  • Load the API
bone$ npm install googleapis
  • Then, run the example on your Bone. The arguments are the values to be logged on the sheet.
bone$ ./demo.js 3.14 10

Python

  • Edit demo.py and change the sheetID string to the string you noted above.
  • Load the API
bone$ pip3 install --upgrade google-api-python-client oauth2client
  • Run

Then, run the example on your Bone. The arguments are the values to be logged on the sheet.

bone$ ./demo.py 3.14 10

Go to your Google sheet and the new data, and a time stamp should be there.

Plot the Data

  • Select the A column and select Format:Number:Date time

Formatting the Date

  • Select all the columns and click Insert chart

Insert chart

  • Select Line chart
  • Select Use row 1 as headers
  • Select Use column A as labels

Chart formatting options

Your data should be plotted. Try running your script again and the chart will update.




thumb‎ Embedded Linux Class by Mark A. Yoder