ESP8266 Community Forum

- Sun May 06, 2018 7:15 pm #75806

Arduino is not an option

Not sure what to think of this...

You are aware that I was referring to the Arduino IDE with ESP-core (the software product), not an Arduino board (the hardware with Atmel controller)?
So you write your own firmware (using the Arduino IDE) in C/C++ and flash it into the ESP.

This code would accept requests as serial (or if you'd like I2C, SPI, parallel, ...) data, forms that into a valid request Google understands and do a POST to the Google Sheets-server.

I managed to upload data to Ubidots with the following

AT+CIPSTART="TCP","things.ubidots.com",80

AT+CIPSEND=204
POST /api/v1.6/variables/VAR_ID/values/?token=TOKEN HTTP/1.1
Host: things.ubidots.com
Content-Type: application/json
Content-Length: 17

{"value": "36.8"}


From there send it to google sheets, but It's just a way around the problem.
Hope I could get a protocol like this for google sheets.

- Mon May 07, 2018 3:00 am #75812 I'm not familiar with Google Sheets nor the protocol used.

You should ask around on the Google (Sheets) development platform, not here on ESP8266.com since this is a forum about some hardware product (the ESP-controller), not protocol implementations used by Google, Twitter, Facebook or whatever.

Perhaps Google needs some cookies with your credentials (API-key, username, password, ...), I don't know.

Assumption is the mother of all f*ckups. At least: that's what I'm assuming.