search

Leafony / Sample-Sketches

Example Sketches
https://docs.leafony.com/docs/examples/
MIT License
5 stars 8 forks source link

Apps script error #7

Open shengcopypaste opened 3 years ago

shengcopypaste commented 3 years ago

Hi, I follow your script and all the steps. But, may I know why when I check for the operation of Google Sheets by using my URL and it shows the error as below? Exception: Unexpected error while getting the method or property openById on object SpreadsheetApp. (line 11, file "Code") TypeError: Cannot read property 'getLastRow' of null (line 12, file "Code")

Hope to hear from you soon. Thanks

taltalp commented 3 years ago

Hi, Shengcopypaste, Could you tell me which example code? You mean this getLastRow?

We're looking forward to hearing from you. Thank you.

shengcopypaste commented 3 years ago

Hi, I think it's because my sheet name was changed and not update with the new version deployment. I follow ESP32_GoogleSheets example code. My URL for Apps Script can function. Just I am not sure why my ESP 32 show this error : [HTTP] GET... failed, error: send header failed, but the HTTP URL link generated by ESP32 is still valid. Do you have any suggestions?