Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Html error #14

Open
gersmit opened this issue Jul 12, 2024 · 1 comment
Open

Html error #14

gersmit opened this issue Jul 12, 2024 · 1 comment

Comments

@gersmit
Copy link

gersmit commented Jul 12, 2024

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

@StorageB
Copy link
Owner

StorageB commented Jul 18, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants