# Problem sending sensor data to Gsheet

**URL:** <https://discourse.nodered.org/t/problem-sending-sensor-data-to-gsheet/52024>\
**Category:** General\
**Created:** [8 October 2021 16:53 UTC](https://discourse.nodered.org/t/problem-sending-sensor-data-to-gsheet/52024 "2021-10-08T16:53:24Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![grant1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/grant1/32/49890_2.png) [@grant1](https://discourse.nodered.org/u/grant1)\
**Post date:** [11 October 2021 09:55 UTC](https://discourse.nodered.org/t/problem-sending-sensor-data-to-gsheet/52024/2 "2021-10-11T09:55:20Z")

</div>

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](https://discourse.nodered.org/t/split-string-into-text-and-integers/49889).

Another possibility is to use [this node](https://flows.nodered.org/node/node-red-contrib-json2csv). 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.

---

_[View the full topic](https://discourse.nodered.org/t/problem-sending-sensor-data-to-gsheet/52024)._