Comments on: ESP32 Datalogging to Google Sheets (using Google Service Account)

By: Greg

Greg — Tue, 11 Nov 2025 14:01:25 +0000

Hello,
I have followed this tutorial and i have it working perfectly.
I am using an esp8266 for this.
I would like to add some sort of visual indication that the connection is good as i will be running this without the serial monitor connected.
I’d like to make the onboard LED blink at a 1hz rate, when the data connection to the google sheet is valid, somewhere around this line? bool ready = Gsheet.ready();
I’m just not sure where/how to make that work.

By: Eric

Eric — Wed, 30 Jul 2025 15:59:40 +0000

Hi,

Thank you for this excellent tutorial, it works very well! 🙂

I would just like to modify it so that the latest data always appears on the first row of the Google Sheet.
Before writing the data, I would therefore need to insert a row above the first row.

Is this possible?

Thank you for your help 🙂

By: Sara Santos

Sara Santos — Tue, 15 Jul 2025 16:12:27 +0000

In reply to Giacomo.

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

By: Giacomo

Giacomo — Tue, 15 Jul 2025 07:39:51 +0000

hi,
my concern is that when there is no wifi connection, no data will be recorded. is there a way to store it in the JSON Valuerange in the sram and when the connection is present append all the previous recordings?

thanks

By: Sara Santos

Sara Santos — Fri, 11 Jul 2025 09:34:29 +0000

In reply to Pat.

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

By: Pat

Pat — Fri, 11 Jul 2025 05:13:32 +0000

Hi 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?

By: Sara Santos

Sara Santos — Thu, 26 Jun 2025 10:00:30 +0000

In reply to Thomas.

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

By: Thomas

Thomas — Wed, 25 Jun 2025 20:06:48 +0000

Hi Sara and Rui,

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.

By: Kevin Maher

Kevin Maher — Mon, 07 Apr 2025 18:48:58 +0000

Hi Rui and Sara,
excellent job with the tutorials. I have learned so much! The Googlesheets upload works great!. One question – how can I suppress the verbose response back to my serial from google each time a data packet is received? I would like to toggle ON as needed for trouble shooting, when necessary. Thanks

By: Edward

Edward — Fri, 14 Mar 2025 08:59:00 +0000

In reply to Frank. Is there any solution?