Test Update ESP8266 + Google Spreadsheets https Redirect V2.0 : PDAControl

Our hardware an ESP8266 NodeMCU More than a year ago I did some tests with ESP8266 12E and Google Spreadsheet Background… on the websites pdacontrolen.com and pdacontroles.com collect the results of previous tests looking for the word “spreadsheets” we tried how to send an email from esp8266 using gmail read a temperature sensor and record on a sheet I also made a routine to read as modbus RTU slave a plc and register in Google spreadsheets at that time use a esp6266 01 and a MAX232 Initially, thanks to Sujay Phadke, creator of the HTTPSRedirect.h library, which we use in these tests. For me it is gratifying to give recognition to the creator of such useful libraries a year ago I made an update of these libraries making improvements and optimizations creating version Although version works very well, finally take some time and try the new version the improvements technically are optimizations of code and guarantees of correct operation I also recommend reading the complete “Readme” on library use, given that there are certain considerations of use.

I have downloaded and executed the available files The Arduino IDE code, Requires the network parameters and the execution URL, generated by Google Script or .gs The Google Script code, in google drive only create new gs files and paste example, associate to Google Sheets sheet and configure persmisos and copy URL of execution, the whole process is in one of my previous videos. Google Spreadsheets, I believe in google drive a new blank sheet and its url is associated with Google script The question they asked me the most was how to generate the necessary “fingerprint” to execute the code well I did the exercise testing for both Linux and Windows, on Mac it’s similar generate the “fingerprint” in Linux is very simple, in my case I use Lubuntu .. very good porcierto must have open a terminal and paste the client’s application opessl and return the code and all that remains is to copy and adapt to the required format in the variable of arduino ide the “fingerprint” is temporary ..

Separate from a space and without points in the case of windows it requires downloading some things download the file “fingerprint.bat” in the documentation in “github” the creator details how to execute it you must download an openssl client for windows another option is to create a virtual machine with linux, and run it in virtualbox in this case we will download gnuwin32-openssl download the binary version, a compressed file will be downloaded 1. Unzip and paste folder opensslxxxxx-bin on disk C: / 2. Paste “fingerprint.bat” file into the “bin” folder located at opensslxxxxx-bin 3. Open command terminal “cmd” always opens in the current user folder location, we must go to disk C: / using “cd ..” 4.

Enter “bin” folder and execute “fingerprint.bat” It takes a few seconds processing … and finally the “fingerprint” is generated and paste in arduino ide similar to the one seen previously we download to esp8266 Let’s see how it connects Automatically … accepted certificate and send data without problems Well the example makes other requests to other applications like Google Calendar, but I will not use it Modify the cell .. to see what happens if you see the change reflected in the Arduino IDE Terminal But this value can only be visualized, perhaps modifying the library a bit, capture it. Let’s restart the esp8266 Reconnect without any problem good the test was a slight introduction, the configuration process is the same or similar to the one seen previously I created a playlist with tutorials about esp8266 and google spreadsheets explained and full documentation at pdacontroles.com and pdacontrolen.com, regards

PDAControl Present….
————————————————————————————————————-

Rapid test Updated https library Redirect version 2.0 allows the communication of ESP8266 and google Sheets without intermediary applications, we will explain how to generate the fingerprint in Linux and Windows.
Thanks to the creator of the library github HTTPSRedirect by Sujay Phadke electronicsguy

Tutorial, documentation and downloads Complete:

Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

Materials and where to buy them Cheap !!!:

ESP8266 12 Node MCU v3 http://s.click.aliexpress.com/e/b6QNZfy
ESP8266-01 http://s.click.aliexpress.com/e/zFmAuRV

Recommended tutorials:

http://pdacontrolen.com/?s=spreadsheets

————————————————————————————————————-

Prueba rapida Actualizada libreria de https Redirect version 2.0 permite la comunicaci贸n del ESP8266 y google Sheets sin aplicaciones intermediarias, se explicaremos como generar el fingerprint en Linux y Windows.

Gracias al creador de la libreria github HTTPSRedirect por Sujay Phadke electronicsguy

Tutorial, documentacion y descargas Completa:

Actualizacion HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

Actualizacion HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

Materiales y donde comprarlos Baratos!!!:

ESP8266 12 Node MCU v3 http://s.click.aliexpress.com/e/b6QNZfy
ESP8266-01 http://s.click.aliexpress.com/e/zFmAuRV

Tutoriales recomendados:

http://pdacontroles.com/?s=spreadsheets

————————————————————————————————————-
github
https://github.com/electronicsguy/ESP8266/tree/master/HTTPSRedirect

Web English Web Espa帽ol
http://pdacontrolen.com http://pdacontroles.com

Audio Video: ThornsOfOmarV2 for Jason Shaw
Licensed under a Creative Commons Attribution 3.0 Unported License.
http://audionautix.com