Hey, I am trying to send data to google sheets using webhook. I have setup an IFTTT particle plugin which receives data from event in JSON format and sends it to the sheets. It is not parsing the JSON, rather adding the whole payload in a cell. It is like,
{"sensorOne": 0.2, "sensorTwo": 0.2, "sensorThree": 0.0, "sensorFour": 0.0, "sensorFive": 0.0}
.
I want each of them to be a column and then its data, just like Sensor One | 0.2 and so on.
Can you please suggest how to do it, and if there’s a way to do it without the IFTTT.
Secondly, In the IFTTT plugin we have to select a particular device from which the event is coming, but in my use case there are many devices. How do I address this ?
Last question, My end goal is to create report in google data studio, so is there a better way to get data there apart from Google sheets.
Thanks .