Update HTTPS Redirect V2.0 ESP8266 & Google Spreadsheet

In previous tests we made the communication of an ESP8266 module and bidirectional sending of data to a Google SpreadSheet.

AdvancedWork in progress4 hours10,167

Update HTTPS Redirect V2.0 ESP8266 & Google Spreadsheet

Things used in this project

Hardware components

NodeMCU ESP8266 Breakout Board

Software apps and online services

Google Sheets

Story

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.

Materials

Module ESP8266 12E

Test performed

The integration process between ESP8266 and 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.

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.

3. Create new Google Spreadsheets file

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

Tutorial Video: Test Update ESP8266 Spreadsheets https Redirect

Complete Info: Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

http://pdacontrolen.com/update-https-redirect-version-2-0-esp8266-google-spreadsheets/

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

http://pdacontroles.com/actualizacion-https-redirect-version-2-0-esp8266-spreadsheets/

Note: Complete explanation here.

Tutorial Video: Test Update ESP8266 Spreadsheets https Redirect

Other Test VERSION 1.0

Quick Test ESP8266 + Google Script app IoT Connection Full

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

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

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

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

Complete Info: Update HTTPS Redirect Version 2.0 ESP8266 & Google Spreadsheets

http://pdacontrolen.com/update-https-redirect-version-2-0-esp8266-google-spreadsheets/

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

http://pdacontroles.com/actualizacion-https-redirect-version-2-0-esp8266-spreadsheets/

Code

HTTPS Redirect (Version 2.0)

This library extends the WiFiClientSecure library (Ivan-github). HTTPSRedirect uses the header information in the server's reply to a HTTP GET or POST request, and follows the re-direction URL by making another suitable GET request. In many cases, it is this re-directed URL which would present the final data that was required. HTTPSRedirect implements a novel HTTP client with follow-redirects which can directly work with many web services (including Google Sheets, Calendar, Drive) without the need for 3rd party services like IFTTT, Temboo, Pushingbox, Thingspeak, Xively, etc.