# INITIALIZE GOOGLE SHEET DATA
#------------------------------
worksheetName = "rangeTest"
scope = ['https://spreadsheets.google.com/feeds']
credentials = ServiceAccountCredentials.from_json_keyfile_name('/home/jat0021/Development/Garden Watering-78f48eddaea0.json', scope)
gc = gspread.authorize(credentials)
worksheet = gc.open(worksheetName).sheet1
#--------------------------------
# INITIALIZE SERIAL PORT
#--------------------------------
UART.initUART()
#---------------------------------
# MAIN PROGRAM LOOP
#---------------------------------
# Compile data message polling information from HC-SR04 sensor 1
sensorRequest = [UART_Messages.WATER_TANK_LVL,
UART_Messages.OPTION_1,
UART_Messages.NULL_BYTE,
UART_Messages.NULL_BYTE]
# Get sensor data
sensorData = UART.transmitMessage( sensorRequest )
# Write sensor data to google sheet
worksheet.update_cell(3,2, sensorData[2])
