Reply To: Library alternatives to achieve same goal as dataLogger in Modular Sensors

@cameronlight, very interesting needing to be clear about security of readings. Hard to do but a requirement for some property owners.

I was interested in doing something with sheets, however it was to learn about Oauth2 security as I remember.  Obviously security access for google is core to the simplicity of their interfaces/APIs – but how does it work. Still evolving for me.

What I would do with this, is attempt to prototype it with  CURL (or any other CLI) which can provide a log of all its internet activity. When there is a reliable script, running on the local PC that can POST  to google sheets, with a traceable log, that takes into account security renewables and timeouts, then you have the algorithm that is needed.

Then translate that algorithm to C++ (publisher subsystem) running on the Mayfly.

I tried asking these questions to get some insights

gemini.google.com: Create a curl script with Oauth2 access to post values to google sheets
Answer Analysis : identifies an Oauth2 Access Token and a Refresh Token. Access tokens expire (typically in 1 hour). To automate this process without human intervention, you must first get a Refresh Token and then use it to request a new access token.
https://gemini.google.com/app/2c95df171b1a80b1    (it gave me this reference, may only work if logged in. Didn’t work for me when moving to another browser that I wasn’t logged in on)