Hi.
Yes. You can save your values in files on the ESP32 filesystem or using Preferences:

-Save data on the filesystem: https://randomnerdtutorials.com/esp32-write-data-littlefs-arduino/
– Save data using the Preferences library: https://randomnerdtutorials.com/esp32-save-data-permanently-preferences/

Regards,
Sara

thanks

Hi.
That’s a weird error.
I recommend going to ‘C:/Users/Win10 and delete the AppData folder.
If that doesn’t work.
I recommend unninstalling and installing Arduino IDE and the ESP32 from scratch and all the libraries.
Regards,
Sara

Thank you for the tutorial. I have completed to the point of uploading the code to ESP32 board. I have to use DHT11 sensor instead as I don’t have the sensor you use. However, I could not upload due to this error:

xtensa-esp-elf-g++.exe: fatal error: cannot execute ‘C:/Users/Win10/AppData/Local/Arduino15/packages/esp32/tools/esp-x32/2411/bin/../libexec/gcc/xtensa-esp-elf/14.2.0/cc1plus.exe’: CreateProcess: No such file or directory
compilation terminated.
exit status 1

Compilation error: exit status 1

(…)
I seek advice from AI and reinstall esp32 board but still show same error. Could you please help me?

Hi.
Yes, you’re right.

I have a notice about that in the tutorial: Note: if your Google Sheets is not in English language, you might need to change Sheet1 with the corresponding in your language on the following line.

But, maybe it is not highlighted enough.

Thanks for your comment.

Regards,
Sara

very helpful, indeed, thanks a lot.

Remark for the German-language users:
I had to change “sheet1” to “Tabellenblatt1” (and not “Tabelle1”) to get it running.

Is there any solution?

Hi.
Great.
Thank you so much for describing this.
This will definitely be helpful for other readers.
Regards,
Sara

I solved a problem that others might find useful. After following your instructions exactly, I got the following error:
Token info: type = OAuth2.0 access token, status = on exchange request
Token info: type = OAuth2.0 access token, status = error
Token error: code: -1, message: Missing required parameter: assertion

What happened is that:
– I used a project name containing spaces, which Google automatically converted to hyphens in the service account.
– when copying the JSON file that includes the private key to my computer, I used the Windows default app Notepad.
– When I pasted the Notepad entry for “client_email” into the Arduino IDE, the IDE incorrectly added spaces between the hyphens. The IDE did this all by itself – must be some kind of bug. I checked this several times and each time the behavior was the same – it added unwanted spaces to the name. Those spaces had to be removed for the OAuth2.0 error to go away, leading to the lovely:

Token info: type = OAuth2.0 access token, status = on initializing
Token info: type = OAuth2.0 access token, status = on signing
Token info: type = OAuth2.0 access token, status = on exchange request
Token info: type = OAuth2.0 access token, status = ready

and a working ESP32-S2 -> Gsheets link!
(except every entry into the spreadsheet is repeated twice, I’ll have to figure that out later)

This might save someone some time to figure out at least a potential solution for the “OAuth2.0 access token, status = error” issue.