Send Data to Google Sheets

Projects General Guidance
1

I have search all over and cannot find a good article or help on how to post data from an arduino to google sheets. Any help would be appreciated.

I have a DHT22 that I would like to send the data to google sheets using my wemos mini. Right now I am using the blynk server and it works good but I would like to manipulate the data on a spread sheet.

Thanks.

2

I'm working right now on a project that uses a WeMos D1 Mini to log data to Google Sheets. My current approach is to use Temboo because the person I'm working with is already using it for another project but I'm not sure if there's any real benefit to using Temboo vs just sending the data directly to Google Sheets so I may end up changing directions once I get farther along.

The Temboo library doesn't support running on ESP8266 but can be easily modified by changing all the:

#include <avr/pgmspace.h>

to:

#ifdef ESP8266
#include <pgmspace.h>
#else 
#include <avr/pgmspace.h>
#endif

I have been able to successfully use the library(1.1.4) on ESP8266 with those changes but for some reason I have problems with TembooChoreo::read().

The Temboo website has instructions for doing a variety of different actions and will generate the code for you: Library - Google - Spreadsheets API :: Temboo
You just need to be sure you're setting it up to pass the ESP8266WiFi client object, for example:

TembooChoreo AppendRowChoreo(tembooClient);

instead of how it's done on the Arduino Yun:

TembooChoreo AppendRowChoreo;
3

I think you must use Temboo. I do not believe the ESP8266 library, the WiFi library, or the ethernet library supports SSL. That will be required to access Google spreadsheets directly.

Here is a thread where I tried with the ethernet library to access Google spreadsheets server. Got an Error 301.
https://forum.arduino.cc/index.php?topic=402692.0

4

It seems to be possible to use Google scripts to access Google docs. Send the data to Google scripts, then have the script and it to sheets. ESP8266/README.md at master · electronicsguy/ESP8266 · GitHub

But I don't know how to use it.

5

@SurferTim thanks for the info. I hadn't considered that. It looks like there is some limited SSL support in the ESP8266WiFi library but I don't know if it would work with Google Spreadsheet and I'm not sure it's really worth it to me to put a lot of effort into investigating that path since both the person I'm working with and myself are already familiar with Temboo from a previous project.

I'm pretty new to all this "cloud" stuff. I've previously focused on using Arduino with Ethernet on my LAN but I guess everything is supposed to be connected to the Internet these days.

I'll report back here if I discover anything of interest to this topic as the project progresses.

6

What are your thoughts on this ESP8266/README.md at master · electronicsguy/ESP8266 · GitHub

7

Give it a try and let us know.

8

@pert and others. Please try out the HTTPSRedirect library and let me know. I've tested it for quitea few ESP8266 based dev boards. If you face any issue, please mention it on github and I'll do my best to help you out.

Currently, it supports full reading and writing to Google sheets, google calendar. In fact, it is generic enough to communicate with any HTTP based REST API service, including Amazon AWS. (I'll post an example for this in the future).