Skip to content

Instantly share code, notes, and snippets.

@ivanahuckova

ivanahuckova/cold-plunges-grafana-google-sheets.md

Last active February 18, 2024 12:55
Show Gist options
  • Save ivanahuckova/ca34674abad44360d0eb18d554d776d1 to your computer and use it in GitHub Desktop.
Save ivanahuckova/ca34674abad44360d0eb18d554d776d1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cold-plunges-grafana-google-sheets.md

Resources for cold plunges monitoring using Google Sheets and Grafana

You can find here

Raw
google-sheets.csv
Date Time Location Latitude Longitude How long (seconds) Water temperature Air temperature
12/3/2023 12:34 Zlate Piesky 48.18641343 17.19468017 60 5.5 -1
Raw
grafana-dashboard.json
{
"__inputs": [
{
"name": "DS_COLD-PLUNGE-FORM",
"label": "cold-plunge-form",
"description": "",
"type": "datasource",
"pluginId": "grafana-googlesheets-datasource",
"pluginName": "Google Sheets"
}
],
"__elements": {},
"__requires": [
{
"type": "panel",
"id": "geomap",
"name": "Geomap",
"version": ""
},
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "10.4.0-pre"
},
{
"type": "datasource",
"id": "grafana-googlesheets-datasource",
"name": "Google Sheets",
"version": "1.2.5"
},
{
"type": "panel",
"id": "stat",
"name": "Stat",
"version": ""
},
{
"type": "panel",
"id": "table",
"name": "Table",
"version": ""
}
],
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "grafana",
"uid": "-- Grafana --"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
"id": null,
"links": [],
"liveNow": false,
"panels": [
{
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 21,
"w": 13,
"x": 0,
"y": 0
},
"id": 2,
"options": {
"basemap": {
"config": {},
"name": "Layer 0",
"type": "default"
},
"controls": {
"mouseWheelZoom": true,
"showAttribution": true,
"showDebug": false,
"showMeasure": false,
"showScale": false,
"showZoom": true
},
"layers": [
{
"config": {},
"filterData": {
"id": "byRefId",
"options": "A"
},
"location": {
"mode": "auto"
},
"name": "Map",
"tooltip": true,
"type": "osm-standard"
},
{
"config": {
"showLegend": true,
"style": {
"color": {
"fixed": "dark-blue"
},
"opacity": 0.7,
"rotation": {
"fixed": 0,
"max": 360,
"min": -360,
"mode": "mod"
},
"size": {
"fixed": 10,
"max": 50,
"min": 1
},
"symbol": {
"fixed": "img/icons/marker/circle.svg",
"mode": "fixed"
},
"symbolAlign": {
"horizontal": "center",
"vertical": "center"
},
"text": {
"field": "",
"fixed": "",
"mode": "field"
},
"textConfig": {
"fontSize": 12,
"offsetX": 0,
"offsetY": 0,
"textAlign": "center",
"textBaseline": "middle"
}
}
},
"filterData": {
"id": "byRefId",
"options": "A"
},
"location": {
"mode": "auto"
},
"name": "Plunges",
"tooltip": true,
"type": "markers"
}
],
"tooltip": {
"mode": "details"
},
"view": {
"allLayers": true,
"id": "coords",
"lat": 48.268506,
"lon": 17.193673,
"zoom": 7.52
}
},
"pluginVersion": "10.4.0-pre",
"targets": [
{
"cacheDurationSeconds": 0,
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"range": "Sheet1!A1:H",
"refId": "A",
"spreadsheet": "FILL_SPREADSHEET_UID"
}
],
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Image link": true,
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"type": "geomap"
},
{
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"fieldConfig": {
"defaults": {
"custom": {
"align": "auto",
"cellOptions": {
"type": "auto"
},
"inspect": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Image link"
},
"properties": [
{
"id": "links",
"value": [
{
"targetBlank": true,
"title": "Show image",
"url": "${__data.fields[\"Image link\"]}"
}
]
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 11,
"x": 13,
"y": 0
},
"id": 1,
"options": {
"cellHeight": "sm",
"footer": {
"countRows": false,
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"showHeader": true,
"sortBy": [
{
"desc": true,
"displayName": "Time"
}
]
},
"pluginVersion": "10.4.0-pre",
"targets": [
{
"cacheDurationSeconds": 0,
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"range": "Sheet1!A1:I",
"refId": "A",
"spreadsheet": "FILL_SPREADSHEET_UID"
}
],
"title": "Plunges",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Image": true,
"Latitude": true,
"Longitude": true,
"Time": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"type": "table"
},
{
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "blue",
"value": null
}
]
},
"unit": "none"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 5,
"x": 13,
"y": 8
},
"id": 6,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"count"
],
"fields": "",
"values": false
},
"showPercentChange": false,
"textMode": "value",
"wideLayout": true
},
"pluginVersion": "10.4.0-pre",
"targets": [
{
"cacheDurationSeconds": 0,
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"range": "Sheet1!A1:I",
"refId": "A",
"spreadsheet": "FILL_SPREADSHEET_UID"
}
],
"title": "Plunge count",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Air temperature": true,
"Date": true,
"How long (seconds)": true,
"Image": true,
"Latitude": true,
"Location": true,
"Longitude": true,
"Time": true,
"Water temperature": false
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"type": "stat"
},
{
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "blue",
"value": 80
}
]
},
"unit": "s"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 6,
"x": 18,
"y": 8
},
"id": 3,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showPercentChange": false,
"textMode": "value",
"wideLayout": true
},
"pluginVersion": "10.4.0-pre",
"targets": [
{
"cacheDurationSeconds": 0,
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"range": "Sheet1!A1:I",
"refId": "A",
"spreadsheet": "FILL_SPREADSHEET_UID"
}
],
"title": "Average time in water",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Air temperature": true,
"Date": true,
"How long (seconds)": false,
"Image": true,
"Latitude": true,
"Location": true,
"Longitude": true,
"Time": true,
"Water temperature": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"type": "stat"
},
{
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "blue",
"value": null
}
]
},
"unit": "celsius"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 5,
"x": 13,
"y": 14
},
"id": 5,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showPercentChange": false,
"textMode": "value",
"wideLayout": true
},
"pluginVersion": "10.4.0-pre",
"targets": [
{
"cacheDurationSeconds": 0,
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"range": "Sheet1!A1:I",
"refId": "A",
"spreadsheet": "FILL_SPREADSHEET_UID"
}
],
"title": "Average air temperature",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Air temperature": false,
"Date": true,
"How long (seconds)": true,
"Image": true,
"Latitude": true,
"Location": true,
"Longitude": true,
"Time": true,
"Water temperature": true
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"type": "stat"
},
{
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "blue",
"value": null
}
]
},
"unit": "celsius"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 6,
"x": 18,
"y": 14
},
"id": 4,
"options": {
"colorMode": "background",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"mean"
],
"fields": "",
"values": false
},
"showPercentChange": false,
"textMode": "value",
"wideLayout": true
},
"pluginVersion": "10.4.0-pre",
"targets": [
{
"cacheDurationSeconds": 0,
"datasource": {
"type": "grafana-googlesheets-datasource",
"uid": "${DS_COLD-PLUNGE-FORM}"
},
"range": "Sheet1!A1:I",
"refId": "A",
"spreadsheet": "FILL_SPREADSHEET_UID"
}
],
"title": "Average water temperature",
"transformations": [
{
"id": "organize",
"options": {
"excludeByName": {
"Air temperature": true,
"Date": true,
"How long (seconds)": true,
"Image": true,
"Latitude": true,
"Location": true,
"Longitude": true,
"Time": true,
"Water temperature": false
},
"includeByName": {},
"indexByName": {},
"renameByName": {}
}
}
],
"type": "stat"
}
],
"refresh": "",
"schemaVersion": 39,
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now-6h",
"to": "now"
},
"timepicker": {},
"timezone": "",
"title": "Cold plunges",
"uid": "cold-plunges",
"version": 1,
"weekStart": ""
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment