Hello…
I have the following data type structure publishing to particle website and want to send it (AND parse into columns) to google excel.
Will I be able to parse each published line out into separate columns using the comma/slash as a delimiter into google excel?
Can someone point me to a video on how this is all done? (I’ve found bits and pieces but nothing that shows a complete example from start to published )
Thanks
chipmc
April 4, 2022, 2:47pm
2
@ridgerunnersjw ,
First, yes you can get your data into a Google sheet and put each value in their own column.
Second, First stop is the Particle Application Note on this subject:
https://docs.particle.io/datasheets/app-notes/an011-publish-to-google-sheets/
Also, you can see what several of us have done and posted here in the forums:
I have been working on pushing data to Google Sheets and I thought I would share what I have learned and see if anyone can help me with one more refinement to this approach.
Use Case - My sleepy cellular devices send data to Ubidots every hour. However, Ubidots does not like textual data (except as context for a numerical variable) and it is not well suited for data that is related to system configuration as these values only rarely change. So, I thought it would be cool to send system config…
Hope this helps,
Chip
3 Likes
system
Closed
October 4, 2022, 2:47am
3
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.