tr-o/switchbot-data-logger-for-google-sheets

Collect data from SwitchBot devices and the OpenWeatherMap API and log the data (temperature, humidity, and absolute humidity) to a Google Sheets document.

switchbot-data-logger-for-google-sheets's Issues

help :)

Hello Harutaro, hope you're fine
have you been able to check my latest Issue posted ?
thanks for your help
regards

Html improvement

Hello
i would like to suggest one or two new feature on your excellent project

on the HTML page , it should be great to add a calendar option to choose exacte date (daily) to retrive old temperature/humidity data
i've a project to install many switchbot thermometer independently (solar panel, 4G router, battery) on some specific place and i need to read data to extract statistics , you're project is incredible to do it
it missed only some data manipulation over html page :)

another great html tips should be to integrate the Max , Min and median during the period we chosse...(as switchbot applisation)

Many thanks

Cricou

ps: as you can seen in screenshot summer is coming in Marseille (FRANCE) :)
green line is a sensor out of range keeping the same temperature from several weeks, it will be solved next month

Battery value seems always at 100% using API request

Hello
i don't know if you are still working on the code but you may never know...

i've modified the gs file to get battery % on each device
but seems battery always at 100%
execution of WriteDataOnSheet.gs script
deviceName: 'Salon',
deviceType: 'Meter',
enableCloudService: true,
hubDeviceId: 'XXXXXXXXXXX,
temperature: 20.7,
humidity: 55,
battery: 100,
absoluteHumidity: 9.9 } ]

but battery is 70% when i check on the switchbot application...

do you know where the issue persits ?

thanks and best regards

Switchbot API changes.

getSwitchbotData() stopped pulling data on 2024-05-23.
After troubleshooting, found out that there is a new API version available.
Was able to fix getSwitchbotData() simply by changing the URL for the new API

Changes:
//var url = "https://api.switch-bot.com/v1.0/devices";
var url = "https://api.switch-bot.com/v1.1/devices";

Hope this help others! :)

export only personnal data from meter to sheet

Hello !
many thanks for the code provided
i'm a newbie , but i just need to export data from my personnal meter (Temperature / Humidity) on a google sheet , without comparing from wheaterdatamap data
the goal is to create, later, web site to see dashboard of all temp/humidity reading the google sheet....
how can i do it ?

again thanks for your code !!
Cricou