I attempted to use the mobizt/ESP-Google-Sheet-Client library with the Uno R4 WiFi, expecting it to be compatible. However, I had to make several manual adjustments just to get it to compile. This included adding an NTP library to set the board time and modifying the autoreconnect feature, which also failed to compile with the library.
I managed to authenticate with Google, but when I ran the "create" example to make a sheet, the API function returned an "unknown error." I primarily tested using the library's "Create" example and a few simplified examples suggested by Arduino Maestro GPT, but none worked.
Before I dive deeper into troubleshooting, are there any libraries compatible with the Uno R4 WiFi that allow pushing data to a Google Sheet? Ideally, I want the sketch to be able to create a sheet. The logging rate is not critical, but I aim to update one cell every second.
I've grown frustrated over the past few days as my initial expectation that the ESP-Google-Sheet-Client would "just work" with the Uno R4 WiFi has proven incorrect. The examples don't compile straight out of the box, despite the board being listed as supported in the library manager.
I haven't posted any code yet because I think it's best to start by identifying the appropriate library/libraries to use. Then, I can spend time cleaning up and verifying the code from there.