writeToGoogleSheets v1.1.4

Write to Google Sheets

Writes a value to a given Google Sheets file. If this file does not exist then it will be created. The worksheet where the data is written to defaults to Data if there is no name for the actuator.

Multiple column support: begin by specifing the header of the worksheet in the column property. This is a ||| seperated list. When you don’t specify this than by default it will make them for you (eg: temperature|||humidity). Then in message specify your list of items seperated by ‘|||’. The first value (timestamp) will automaticly be added, so you dont need to specify this (eg: 18.4|||65)

Required properties:

  • file
  • message
  • timezone
  • worksheet
  • columns
  • decimalSeperator