Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

by Jhon_Control

7.9K112

Intro: Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

In previous tests we made the communication of an ESP8266 module and bidirectional sending of data to a Google Sheet with the help of Google Script, Initially thanks to Sujay Phadke "electronicsguy" the creator of the HTTPSRedirect library, a few months ago I made considerable improvements to said library and we will do a quick test.

PDAControl Tutorials

Complete Info: Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets
http://pdacontrolen.com/update-https-redirect-ver...

Informacion Completa: Actualizacion HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

http://pdacontroles.com/actualizacion-https-redire...

STEP 1: Materials Very Cheaps !!! & Test Performed

Materials Very Cheaps !!!

Module ESP8266 12E

Test performed The integration process between ESP8266and Google Docs has not changed. Among the improvements, allows connections with Google Sheets,Calendar, Drive, have improved performance to see detailed improvements in the following link.

HTTPSRedirect Library API

In our case we will only make the connection with the Google sheet and we will prove the creation of the fingerprint.

STEP 2: Video: Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets 2018

Video: Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

STEP 3: Download Library Examples From Github & Copy Google Script Code

1. Download Library examples from Github

The use of the library has some conditions of use mentioned by the creator to take into account mentioned at the end of the README github.

2. Copy Google Script Code

In our Google Drive we create a folder and create a new Google Script or .gs file and paste the code, compile and execute it.

Add Sheet ID and I have made the modification line 38 'Sheet1' for 'Hoja 1' in my case my drive is in Spanish.

STEP 4: Create New Google Spreadsheets File & Generate Fingerprint

3. Create new Google Spreadsheets file

In our Google Drive we create a new Google Spreadsheets file, copy ID from URL.

4. Generate fingerprint

The creator of the library explains in case of Linux, Windows and MAC OS here in SSL Certificates,in this case we will test the method of generating the fingerprint for Windows and Linux, for MAC it is similar to Windows.

Note: Complete explanation here.

STEP 5: Previous Tests With Version 1.0

Quick Test ESP8266 + Google Script app IoT Connection Full

STEP 6: ESP8266 Send Email With (Google Docs) Script App -Spreadsheets - Gmail

ESP8266 Send Email with (Google Docs) Script App -Spreadsheets - Gmail

STEP 7: Test Prueba 01- ESP8266 + DS18B20 Onewire + Google Speadsheets (Google Docs)

Test Prueba 01- ESP8266 + DS18B20 Onewire + Google Speadsheets (Google Docs)

STEP 8: Connection ESP8266 and Google Spreadsheet (Google Docs) Direct : PDA_Control

Connection ESP8266 and Google spreadsheet (Google Docs) Direct : PDA_Control

STEP 9: Connection PLC Fpx Panasonic and Google Spreadsheets (Google Docs) With ESP8266 PDAControl

Connection PLC fpx Panasonic and Google spreadsheets (Google docs) with ESP8266 PDAControl

STEP 10: Conclusions and Considerations

Conclusions and Considerations

Even if I do not perform a complete test with all the new improvements in the application such as the connection with Calendar, Drive I see that the bidirectional connection works perfectly.

Some time ago it was suggested to the developer to implement a means of capturing the values from the cells in ESP8266, I indicate that in future versions, I will verify if it was implemented, it would be very useful since previously only cell values could be displayed in the terminal .

Read the considerations of use of the library in Github, its use is free non-commercial.

To conclude thanks to the developer Sujay Phadke "electronicsguy "for his contribution and share its implementation, I have seen that people perform tests and never thanks or provides credit to the creators.

Downloads and More information Complete Info: Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

http://pdacontrolen.com/update-https-redirect-ver...