CoRE - Get peer assistance here with setting up Pistons

[alanrosesf (Alan)]

Help With Web Request - POST Time and Temperature to Google Sheets

Preface: For my first web request, I wish to post the time and temperature to the end of a Google Sheet each time a motion sensor is tripped.

Code.gs: I’ve based my Post/Get code off of this great blog on the subject
Google Sheets as a Database – INSERT with Apps Script using POST/GET methods

I am ‘confident’ my Google side is online and working and a test of the sheet did show from the Google side success. I am using JSON, the Sheet name is filled in correctly, and I’m using the proper key in all the right spots.

I guess my question is, am I missing any part of this method to get this to work?

As for my Piston:

UPDATE 1:
I’ve revised my .gs code and I’m am receiving ‘something’ into the sheet now. However, the data I’m receiving is ‘undefined’.

Question: Is there a way to print the web request going to google to see what the data is?

UPDATE 2: WORKING I had to change the output of the Piston Web Request from JSON to FORM.

How To Log Temperature Changes To Google Sheets Using Web Request

Case Study - How To Log Temperature Changes To Google Sheets Using Web Request This example will demonstrate how to set up a Google sheet to receive data from a Piston that is posting data to it using Web Request and POST. The first section will cover setting up the Google sheet and the script. The second part will cover the creation of the piston and what is needed to pass data from CoRE to the spreadsheet. What is important to keep in mind with this example is the names of the columns in your Google sheet must match exactly the names of the variables you are passing to it. In our example, we will create and pass the variables Time, Temperature, and Device. Required: -1 sensor capable of giving temperature -basic working knowledge of spreadsheets, how to create one Part 1: Google …