Comments on: ESP32 Publish Sensor Readings to Google Sheets (ESP8266 Compatible)

By: Sara Santos

Sara Santos — Sat, 17 Aug 2024 08:39:41 +0000

In reply to Jerzy.

Hi.
Press the board RST button with the Serial Monitor opened.
Regards,
Sara

By: Jerzy

Jerzy — Fri, 16 Aug 2024 13:23:52 +0000

I entered the BME280 server code into the
ESP32–D0WD-v3 board but the IP address does not appear on the monitor.

By: Sara Santos

Sara Santos — Tue, 05 Mar 2024 17:30:19 +0000

In reply to Claudop.

Hi.
That function is to be used o the Google Sheets and not on the Arduino sketch.
Regards,
Sara

By: Claudop

Claudop — Tue, 05 Mar 2024 13:55:25 +0000

In reply to Sara Santos.

Thanks so much Sarah.
I successfully followed your advice.
But now I can’t display the timestamp legibly.
In the tutorial we recommend using the EPOCHTODATE() function.
I tried replacing the string:
valueRange.set(“values/[0]/[0]”, epochime);
with
valueRange.set(“values/[0]/[0]”, EPOCHTODATE(A5));
(as per the example found at the indicated link)
but the compiler gives the following error:
“Compilation error: ‘EPOCHTODATE’ was not declared in this scope”

can you help me please?
Thank you
claudio

By: Sara Santos

Sara Santos — Sun, 03 Mar 2024 17:32:06 +0000

In reply to claudio.

Hi.
IFTTT changed the Google Sheets option to a paid service just a few days ago.
As an alternative, you can check this tutorial instead: https://randomnerdtutorials.com/esp32-datalogging-google-sheets/
Regards,
Sara

By: claudio

claudio — Sat, 02 Mar 2024 17:54:05 +0000

Hi Sara, Hi Ruy,
I follow your turials with great interest and in fact I have purchased two of your books. I need to save data from some sensors and, as a first test, I wanted to use Google Sheets.
I followed your tutorial step by step “ESP32 Publish Sensor Readings to Google Sheets (ESP8266 Compatible)” but I can’t create the IFTTT service because I have the impression that it is only paid.
Do you have any suggestions on this or am I doing something wrong?
Thanks in advance
Claudio

By: Sara Santos

Sara Santos — Wed, 17 Jan 2024 10:02:44 +0000

In reply to Eric Emond.

Hi.
It will be published this Thursday.
Regards,
Sara

By: Eric Emond

Eric Emond — Tue, 16 Jan 2024 21:48:18 +0000

In reply to Sara Santos. Can wait to see the new tutorial as the Webhook used in this tutorial is no longer as it falls it the "Pro" category.

By: Sara Santos

Sara Santos — Thu, 04 Jan 2024 23:32:51 +0000

In reply to Joey.

Hi.
There is a better way to publish using this library: https://github.com/mobizt/ESP-Google-Sheet-Client
We already have a tutorial for this that will be published in two weeks.
Regards,
Sara

By: Joey

Joey — Thu, 04 Jan 2024 23:29:33 +0000

I was wondering if the IFTTT was still necessary even with the capabilities of Google App Scripts?