Problem sending sensor data to Gsheet

Welcome to the forum.

I believe your problem boils down to the need to split a string into text & integers, and then create the CSV. For this, some good Function and Change nodes were proposed when I had a similar issue. See here.

Another possibility is to use this node. It's very old, but it worked for me in a simple use case where passing thru the JSON and the Change nodes did not work correctly.