How to control the temperature of your terrarium room remotely

We are almost there, now that we can read the sensor correctly, we need to create a Python code that reads the sensor and pushes the reading to a Google Sheets.

As a first step, open your terminal an run the command:

pip install --upgrade google-api-python-client oauth2client

Then, use Thonny (pre-installed on you Raspberry Pi) to create a file called bme280-reading.py in the folder python-bme280 and paste in it the following code:

#-*- coding: utf-8 -*-
# import many libraries
from __future__ import print_function  
from googleapiclient.discovery import build  
from httplib2 import Http  
from oauth2client import file, client, tools  
from oauth2client.service_account import ServiceAccountCredentials  
import bme280  
import datetime

# My Spreadsheet ID ... This is the code of the gsheet file, you can find it into the url
MY_SPREADSHEET_ID = 'SpreadsheetID'
#My Sheet Name ... This is the name of the sheet where you will log the data
MY_SHEET_NAME = 'SheetName'

#This function takes care of uploading the main function to Google Sheet
def update_sheet(sheetname, temperature, pressure, humidity):  
    # This is where the authentication happens. Make sure the name of your key matches bme280-key.json
    SCOPES = 'https://www.googleapis.com/auth/spreadsheets'
    creds = ServiceAccountCredentials.from_json_keyfile_name( 
            'bme280-key.json', SCOPES)
    service = build('sheets', 'v4', http=creds.authorize(Http()))

    # Call the Sheets API, append the next row of sensor data
    # values is the array of rows we are updating, its a single row
    values = [ [ str(datetime.datetime.now()), 
        temperature, pressure, humidity] ]
    body = { 'values': values }
    # call the append API to perform the operation
    result = service.spreadsheets().values().append(
                spreadsheetId=MY_SPREADSHEET_ID, 
                range= MY_SHEET_NAME+'!A1:D1',
                valueInputOption='USER_ENTERED', 
                insertDataOption='INSERT_ROWS',
                body=body).execute()                     

#This function takes the reading from the BME280 sensor and uploads them to the Google Sheet
def main():  
    bme = bme280.Bme280()
    bme.set_mode(bme280.MODE_FORCED)
    tempC, pressure, humidity = bme.get_data()
    pressure = pressure/100.
    print ('Temperature: %f °C' % tempC)
    print ('Pressure: %f hPa' % pressure)
    print ('Humidity: %f %%rH' % humidity)
    
    update_sheet(MY_SHEET_NAME, tempC, pressure, humidity)

if __name__ == '__main__':  
    main()

Once you paste the code, change SpreadsheetID into your Google Sheet File ID, and SheetName into the name of the sheet you want to log the reading into.

At this point everything is ready.

Open the terminal in the folder python-bme280 and run this command:

python bm280-reading.py

If everything went well, you should now see the sensor reading into your google sheet, with the order: Time of reading, temperature, pressure and humidity.