Lab 7: Cloud Platforms

First I set up an account at https://thingspeak.com and linked my mathworks account to it and then created a new channel

After that I ran the following steps to create a new channel cpu_loop with field1 cpu_pc and field2 mem_avail_mb

$ sudo pip3 install -U psutil

$ cd demo

$ cp ~/iot/lesson7/thingspeak_cpu_loop.py .

Then Copy the Write API Key from https://thingspeak.com/channels

$ nano thingspeak_cpu_loop.py

and finally run thingspeak_cpu_loop.py

python3 thingspeak_cpu_loop.py

Part 2 : Google Sheets

Generate and download a JSON key after setting up the good cloud platform identity

sudo pip3 install -U gspread oauth2client

cd demo

cp ~/iot/lesson3/system_info.py .

cp ~/iot/lesson7/rpi_spreadsheet.py .

Set GDOCS_OAUTH_JSON = 'rpidata-*.json' and GDOCS_SPREADSHEET_NAME = 'rpidata'

Then run the program

$ nano rpi_spreadsheet.py

$ python3 rpi_spreadsheet.py