Arduino UNO R4 WiFi + Google Sheets

[johnchugh]

I am using a battery powered Arduino UNO R4 WiFi which is interfaced with phone through IoT. Is there a means to write the data from Arduino to Google Sheets. FYI - I will not have access to PC and hence no serial monitor.

Thanks is advance for the help and guidance

[thomas945]

Hello, @johnchugh
You can log data from your Arduino to Google Sheets without using a PC or serial monitor. Here are a couple of approaches you can explore:

ESP32 Datalogging to Google Sheets (Google Service Account):
Use an ESP32 board (similar to Arduino) to securely and reliably log data to Google Sheets.
Set up a Google Service Account, create a Google project, and associate the service account with that project.
Follow the steps outlined in the tutorial to save temperature, humidity, pressure, and timestamps on a Google spreadsheet.
ESP8266 Tutorial: Logging Data to Google Sheets:
If you’re using an ESP8266 (NodeMCU), you can follow a step-by-step tutorial to log data directly to a Google Sheets spreadsheet.

Logging data to Google Sheets - ESP8266 Tutorial

Hi everyone, I created a step by step tutorial for logging data from an ESP8266 device to a Google Sheets spreadsheet without the need for any third party services: https://github.com/StorageB/Google-Sheets-Logging I have several NodeMCU devices that are logging data, and wanted to document the process of setting them up to make it easier on myself when adding new devices. I just wanted to share this for others that may find it useful. It should also work with other ESP8266 devices like Wemos…

Hope this work for you.
Best regards,
thomas945