Like many other people, one of the more fun things to get your :spark: Core to do is interact with the real-world with sensors. The beauty of the Core, perhaps over the arduino, is the ability to access this sensor-read data from anywhere :smile: without the need for additional Shields / punching h…

Thanks so much for the help. I’m very new to all of this. My mistake was using the the angled brackets and not including result! My electron now publishes to my google spreadsheet! :grinning: Now on to the next part. Maybe I should start a new thread? I want to Electron to log the quality and stren…

You are exceeding the rate limit of max 1 publish per second. If you put both values together into one publish you might have more luck.

Hi guys, I’m back with a couple questions. I’ve formatted my particle so that it outputs the cellular signal, but I seem to be having a little trouble getting it to actually add to the spreadsheet. When I put my postman request in, I get these results: { "cmd": "VarReturn", "name": "result", "resul…

Hi @binaryfrost thanks for the great project share. I got completely stuck with the Spark.variable(“result”, &resultstr, STRING); and was wondering if you (or anyone else here) could have a look at my code to see what Im not seeing. I don’t know if it’s customary that people directly paste code i…

Yes, it is customary (and necessary) to post the code you’re having trouble with. Also, please elaborate on what “got completely stuck” means. What’s the problem? Does the code not work, or do you not know how to write the code?

Hi @Ric Thanks for your reply. Below my code, I’ve made as many notes as possible so you can see where the problem is (I hope). Everything work but I get stuck when enter: Spark.variable(“result”, &resultstr, STRING); Marked in the code between // PROBLEM STARTS HERE JDM and // PROBLEM ENDS HERE JD…

I see several things that may be the problem, though you still haven’t told me what “getting stuck” means. What happens when you uncomment the code that you say is the problem? I don’t know where you got this code, but you should definitely check out the docs to make sure you’re using the current a…

Hi @Ric Thanks for your quick reply! The code is part of a library (found in the Particle Build library) for the Sparkfun sht1x. As you suggested I’ve changed: Spark.variable(“result”, &resultstr, STRING); to Particle.variable(“result”, resultstr); and I don’t get any more error message when verif…

@Ric I am very excited to let you know I allready got to the results I wanted! And learned lots in doing so. Massive thanks to you for your help. Next part of the project is going to be uploading the data to http://wunderground.com All the best, J [image]

Example: Logging and graphing data from your Spark Core using Google

Social Project Share

ScruffR May 18, 2018, 2:41pm 206

You may have more luck with this thread, which is more up to date

Or this Hackster project

Pushing data from the photon into google sheets

Topic		Replies	Views
Pushing data from the photon into google sheets Firmware	92	19152	April 11, 2020
Webhook builder to google sheets Firmware	11	4072	July 5, 2020
Atomiot (Formerly Spark Tools) - Monitor Spark Projects with zero code.. and other stuff General	61	7697	February 6, 2019
Control, monitor, and log a Spark Core with ThingSpeak Troubleshooting	15	8636	April 16, 2016
Using Spark.publish() with Simple JSON Data Tutorials	119	36203	November 11, 2017

Example: Logging and graphing data from your Spark Core using Google

Related topics