StorageB/Google-Sheets-Logging

Html error

gersmit opened this issue · 1 comments

Hi,
My name is Ger from the Netherlands and like the program.
Only one thing, i get error in HTML?? and cannot find the problem.
Can someone help me to solve the problem below

Publishing data...
18:24:11.007 -> {"command": "insert_row", "sheet_name": "Sheet1", "values": "9,209,25349"}
18:24:12.467 -> <title>Fout</title><style type="text/css" nonce="6UrDIdle-vwJo0et9lN6IQ">body {background-color: #fff; margin: 0; padding: 0;}.errorMessage {font-family: Arial,sans-serif; font-size: 12pt; font-weight: bold; line-height: 150%; padding-top: 25px;}</style>

Google Apps Script
TypeError: Cannot read properties of null (reading 'insertRows') (regel 48, bestand 'Code')

Many thanks in advance
Greetings Ger

Hello! I am not familiar with this error, and it's difficult to diagnose without seeing your code or having access to your spreadsheet. Also, what device are you using?
My suggestion is to start over with a blank spreadsheet and blank sketch and try the tutorial again as one missed step could cause an error publishing data.
Much less likely, but if you're not able to send data at all, it could be a firewall issue not letting the esp device send data out.
Also, don't forget to create a new new deployment whenever you make changes https://github.com/StorageB/Google-Sheets-Logging?tab=readme-ov-file#important-note