Skip to content

Google Spreadsheet

Display information from cells in a Google Spreadsheet.

Configuration

gspreadsheets:
  colors:
    values: "green"
  cells:
    names:
    - "Cell 1 name"
    - "Cell 2 name"
    addresses:
    - "A1"
    - "A2"
  enabled: true
  position:
    top: 0
    left: 0
    width: 1
    height: 1
  refreshInterval: "5m"
  secretFile: "~/.config/wtf/gspreadsheets/client_secret.json"
  sheetId: "id_of_google_spreadsheet"

Attributes

Name Value
colors.values
Optional The color to display the cell values in. 		Any X11 color name or long-form hex value (i.e.: #ff0000).
colors.names
Optional 		Any X11 color name or long-form hex value (i.e.: #ff0000).
colors.addresses
Optional 		Any X11 color name or long-form hex value (i.e.: #ff0000).
secretFile
Your Google client secret JSON file. 		A string representing a file path to the JSON secret file.

Source Code

https://github.com/wtfutil/wtf/tree/master/modules/gspreadsheets