import json
import gspread
import sys
import time
import datetime
import urllib2
from oauth2client.service_account import ServiceAccountCredentials

#open Google drive
scope = ['https://spreadsheets.google.com/feeds']

# Variabelen
FREQ_SEC=600
LEES=1
#sheet open with JSON keyfile
credentials = ServiceAccountCredentials.from_json_keyfile_name('MY_JSON_KEY.json', scope)
gc = gspread.authorize(credentials)

#open TEST XLS sheet on Google DRIVE
wks = gc.open('TEST').sheet1

#sense hat values reading
from sense_hat import SenseHat
sense = SenseHat()

while True:

        t = sense.get_temperature()
        p = sense.get_pressure()
        h = sense.get_humidity()

        t = round(t,1)
        p = round(p,1)
        h = round(h,1)

        #display screen
        msg = "Temperature = %s, Pressure=%s, Humidity=%s" % (t,p,h)
        print msg
        #add record
        wks.append_row([datetime.datetime.now(),p,h,t])

        # 8x8 RGB
        sense.clear()
        info = 'Temperature (C): ' + str(t) + 'Humidity: ' + str(h) + 'Pressure: ' + str(p)
        sense.show_message(info, text_colour=[255, 0, 0])
        time.sleep(FREQ_SEC)