Fixed several issues with the code and suggest this as a new version

[arduino]

Fixed several issues with the code and suggest this as a new version

[chinchillajared]

Is there something the user has to change to be able to make it work?
I just changed the variable name sheet: var sheet = ss.getSheetByName('ArduinoIOTCloudSensorData');
I put my sheet name but still not working even with the original name.

[Bodobolero]

Is there something the user has to change to be able to make it work?
I just changed the variable name sheet: var sheet = ss.getSheetByName('ArduinoIOTCloudSensorData');
I put my sheet name but still not working even with the original name.

Still works for me, maybe I can help if you describe your problem more clearly with error messages or the steps you did.

[BBope9k]

Hello Bodobolero, Can you help med out with this error?

TypeError: Cannot read property "postData" from undefined.
doPost @ code.gs:38

[per1234]

Hi @BBope9k. Thanks for your interest in this open source project. This issue tracker is only to be used to report bugs or feature requests specific to the project. This topic is more appropriate for the Arduino Forum. I'm sure we will be able to help you out over there:

https://forum.arduino.cc/c/software/iot-cloud/152

[Bodobolero]

Hello Bodobolero, Can you help med out with this error?

TypeError: Cannot read property "postData" from undefined. doPost @ code.gs:38

as per1234 said I cannot provide support in this repository.

The error indicates that the scripting engine can not resolve the variable e.postData.contents

Did you correctly follow the steps to create a google spreadsheet and deploy the script as web app ?

First thing first, go to Google Sheets and create a new blank spreadsheet. Rename the sheet to something like “RawData”, then click on Tools > Script Editor to open Google Apps Script.
Select the "doPost" method in the dropdown above the code. Then in order to actually use this code we first need to publish it, thus go to Publish > Deploy as web app.

[Vado75]

hi all, thanks for sharing the code, original code didn't work for me right away, but after editing
var ss = SpreadsheetApp.getActiveSpreadsheet();
and control of the year
if (date.getFullYear() > 2018) { ....
get.year returns the number of years since 1900, i.e. 122
now everything works perfectly for me :)
original code super checks repeated writing and empty spaces...