Hello,
I am trying to connect data from the arduino to google sheets via an ESP8266 module. I am not using the node mcu, which is what majority of the tutorials are based off of. I have an esp8266-01 connected to an arduino mega.
I've looked up and down the internet and I think the library won't work with my set up. I've tried installing the library in two different ways. Is there a way to connect to google sheets without this library?
Thank you
You should be able to do it using the WiFiEsp library:
and the Temboo library (comes with the Arduino IDE).
You can't send the data directly to Google Sheets this way, you need to do it through Temboo. I have done something similar to this a few years ago and it worked fine. Unfortunately, Temboo no longer offers a permanent free plan. They have a 30 day trial, but after that it's $25/month.
You might be better off to buy a standalone ESP8266 like the WeMos D1 Mini (same thing as the NodeMCU, but smaller). With the standalone ESP8266 board, I believe you can connect to Google Sheets directly due to its SSL capabilities.
One possible (free) alternative to temboo might be the IFTTT webhooks (Webhooks Integrations - Connect Your Apps with IFTTT) input channel connected to the Google Sheets output channel. (The limited processing and memory resources of the ESP-01 are probably inadequate to perform the SSL encryption and login requirements to access Google Sheets directly.)
Follow this link, it's what I used for a similar project.