![\"\"](\"https:\/\/iotthinghub.com\/wp-content\/uploads\/2025\/05\/BMP280-IC.jpg\")
<\/figure>\n<\/div>\n\n\n\n![\"\"](\"https:\/\/iotthinghub.com\/wp-content\/uploads\/2025\/05\/BMP280-pin.jpg\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nNow it times to download some driver for our project. Let\u2019s begin with some settings- <\/p>\n\n\n\n
- \n
- Install the latest version of Arduino : https:\/\/www.arduino.cc\/en\/software\/<\/a><\/li>\n\n\n\n
- In Arduino: File>Preferences>Setting : http:\/\/arduino.esp8266.com\/stable\/package_esp8266com_index.json<\/a><\/li>\n\n\n\n
- In Arduino Install: Tools>Board>esp8266<\/li>\n\n\n\n
- In Arduino: Tools>Board>esp8266>Generic ESP8266 Module<\/li>\n<\/ul>\n\n\n\n
- \n
- In Arduino Install: Library Manager\n
- \n
- Adafruit SSD1306<\/li>\n\n\n\n
- Adafruit GFX Library<\/span><\/li>\n\n\n\n
- Adafruit BusIO<\/span><\/li>\n\n\n\n
- Adafruit BME280<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
Deploying a Google Sheet involves preparing, sharing, and managing access to ensure the spreadsheet is effectively used by intended users. The process can vary depending on the purpose\u2014whether for collaboration, embedding, or automation. For full process please see my YouTube video. Google Script Program-<\/p>\n\n\n
\nfunction doGet(e) {\n var sheet = SpreadsheetApp.openById("Sheet_ID").getActiveSheet();\n var temp = e.parameter.temp ;\n var hum = e.parameter.hum ;\n var press = e.parameter.press ;\n var alt = e.parameter.alt ;\n var heatIndex = e.parameter.hi ;\n var Curr_Date = Utilities.formatDate(new Date(), "GMT+6", "yyyy-MM-dd");\n var Curr_Time = Utilities.formatDate(new Date(), "Asia\/Dhaka", 'HH:mm:ss'); \/\/ Time in column B\n sheet.appendRow([Curr_Date, Curr_Time,temp, hum, press, alt, heatIndex]);\n return ContentService.createTextOutput("Success");\n}\n<\/pre><\/div>\n\n\n![\"\"](\"https:\/\/iotthinghub.com\/wp-content\/uploads\/2025\/05\/ESP8266-Project-3.jpg\")
<\/figure>\n\n\n\nI live in Bangladesh so my Geographical Date & Time is – “Asia\/Dhaka” & “GMT+6”. Change according to your Geographical Date & Time. In our entire previous articles we communicate through pipe line port:80 with HTTP protocol. But Google Sheets communicates over HTTPS (port 443), ensuring encrypted, secure data transfer. The platform employs SSL\/TLS certificates issued by trusted CAs to authenticate its servers and encrypt data. That\u2019s why Google Sheets can\u2019t operate in AT command mode. If you want to communicate Google Sheet in AT command mode with different microcontroller it will not work.<\/p>\n\n\n
\n#include <ESP8266WiFi.h>\n#include <WiFiClientSecure.h>\n\/\/ WiFi & ThingSpeak\nconst char* ssid = "Your_WiFi_Name"; \/\/ provide your WiFi Name\nconst char* password = "Your_WiFi_Password"; \/\/ provide your WiFi Password\nconst char* host = "script.google.com"; \/\/ URL\nconst int httpsPort = 443; \/\/ SSL Port\n\/\/ Change according to gogle script\nconst char* scriptPath = "AKfycbyJUFW5Y-yGb5vgTeRG63zie2hreilg0GNRLha52TVwJNBJfX_yiI3gqOgzjVgj4CQ3";\n\/\/ Value to send Google sheet\n WiFiClientSecure client;\n client.setInsecure(); \/\/ Disable SSL certificate validation (easier for testing)\n Serial.print("Connecting to ");\n Serial.println(host);\n \/\/ Connecting to script.google.com with port 443\n if (!client.connect(host, httpsPort)) {\n Serial.println("Connection failed");\n delay(10000);\n return;\n }\n String url = "\/macros\/s\/"+ String(scriptPath) + "\/exec?temp=" + tStr +\n "&hum=" + hStr +\n "&press=" + pStr +\n "&alt=" + aStr +\n "&hi=" + hiStr;\n\n Serial.print("Requesting URL: ");\n Serial.println(url);\n\n client.print(String("GET ") + url + " HTTP\/1.1\\r\\n" +\n "Host: " + host + "\\r\\n" +\n "Connection: close\\r\\n\\r\\n");\n\n while (client.connected()) {\n String line = client.readStringUntil('\\n');\n Serial.println(line);\n if (line == "\\r") break;\n }\n\n String response = client.readString();\n Serial.println("Response:");\n Serial.println(response);\n<\/pre><\/div>\n\n\nOther parameter such as BME280 reading & OLED display is same as my previous article.<\/p>\n\n\n\n
- Adafruit BusIO<\/span><\/li>\n\n\n\n
- In Arduino: File>Preferences>Setting : http:\/\/arduino.esp8266.com\/stable\/package_esp8266com_index.json<\/a><\/li>\n\n\n\n