# Unable to connect to script.google.com

**URL:** <https://forum.arduino.cc/t/unable-to-connect-to-script-google-com/637818>\
**Category:** General Guidance\
**Created:** [February 20, 2020, 7:23am UTC](https://forum.arduino.cc/t/unable-to-connect-to-script-google-com/637818 "2020-02-20T07:23:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![CR\_07](https://avatars.discourse-cdn.com/v4/letter/c/dfb087/32.png) [@CR\_07](https://forum.arduino.cc/u/CR_07)\
**Post date:** [February 20, 2020, 7:23am UTC](https://forum.arduino.cc/t/unable-to-connect-to-script-google-com/637818/1 "2020-02-20T07:23:56Z")

</div>

Hello experts..

I am using wemos D1 to update multiple sensor data on Google spreadsheet using 4051IC.. but every time my serial monitor says connection failed.. and I am not able to connect to [script.google.com](http://script.google.com) ☹

Please suggest a solution.

Thanks in advance. 🙂

---

<div class="post-metadata">

**Author:** ![UKHeliBob](https://dub1.discourse-cdn.com/arduino/user_avatar/forum.arduino.cc/ukhelibob/32/215663_2.png) [@UKHeliBob](https://forum.arduino.cc/u/UKHeliBob)\
**Post date:** [February 20, 2020, 7:30am UTC](https://forum.arduino.cc/t/unable-to-connect-to-script-google-com/637818/2 "2020-02-20T07:30:16Z")

</div>

Start by posting your code

---

<div class="post-metadata">

**Author:** ![CR\_07](https://avatars.discourse-cdn.com/v4/letter/c/dfb087/32.png) [@CR\_07](https://forum.arduino.cc/u/CR_07)\
**Post date:** [February 20, 2020, 11:33am UTC](https://forum.arduino.cc/t/unable-to-connect-to-script-google-com/637818/3 "2020-02-20T11:33:41Z")

</div>

Thanks for prompt reply sir.. This is what I am writing..

//[https://script.google.com/macros/s/AKfycbwnjWGj4E1AGmi-EZ2rgG7CUaePn7LiuzRbRsQfBJNcngUKmXcx/exec](https://script.google.com/macros/s/AKfycbwnjWGj4E1AGmi-EZ2rgG7CUaePn7LiuzRbRsQfBJNcngUKmXcx/exec)  
#include \<ESP8266WiFi.h\>  
#include \<WiFiClientSecure.h\>

const char \*ssid = "WiFi SSID";  
const char _password = "WiFi PASSWORD";  
const char_ host = "[script.google.com](http://script.google.com)";  
String url;

void setup()  
{  
pinMode(D1, OUTPUT);  
pinMode(D2, OUTPUT);  
pinMode(D3, OUTPUT);  
Serial.begin(115200);  
delay(100);  
Serial.println();  
Serial.println();  
Serial.print("Connecting to ");  
Serial.println(ssid);

WiFi.begin(ssid, password);  
while (WiFi.status() != WL\_CONNECTED)  
{  
delay(500);  
Serial.print(".");  
}

Serial.println("");  
Serial.println("WiFi connected");  
Serial.println("IP address: ");  
Serial.println(WiFi.localIP());  
Serial.print("Netmask: ");  
Serial.println(WiFi.subnetMask());  
Serial.print("Gateway: ");  
Serial.println(WiFi.gatewayIP());  
}

void loop()  
{  
Serial.print("connecting to ");  
Serial.println(host);

WiFiClientSecure client;

const int httpPort = 443;  
if (!client.connect(host, httpPort))  
{  
Serial.println("connection failed");  
return;  
}  
digitalWrite(D1, LOW);  
digitalWrite(D2, LOW);  
digitalWrite(D3, LOW);  
float t = analogRead(A0);  
delay(1000);  
digitalWrite(D1, LOW);  
digitalWrite(D2, LOW);  
digitalWrite(D3, HIGH);  
float r = analogRead(A0);  
delay(1000);  
digitalWrite(D1, LOW);  
digitalWrite(D2, HIGH);  
digitalWrite(D3, LOW);  
float c = analogRead(A0);  
delay(1000);  
PrintData();  
delay(5000);  
}

void PrintData()  
{  
WiFiClientSecure client;  
float t;  
float r;  
float c;  
url = "macros/s/AKfycbwnjWGj4E1AGmi-EZ2rgG7CUaePn7LiuzRbRsQfBJNcngUKmXcx/exec?func=addData&val="+ String(t) + String(r) + String(c);  
Serial.print("Requesting URL: ");  
Serial.println(url);

client.print(String("GET ") + url + " HTTP/1.1\r\n" +  
"Host: " + host + "\r\n" +  
"Connection: close\r\n\r\n");  
delay(500);  
String section="header";  
while(client.available())  
{  
String line = client.readStringUntil('\r');  
Serial.print(line);  
}  
Serial.println();  
Serial.println("closing connection");  
}

---

<div class="post-metadata">

**Author:** ![AndreCigna](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@AndreCigna](https://forum.arduino.cc/u/AndreCigna)\
**Post date:** [April 21, 2021, 8:05pm UTC](https://forum.arduino.cc/t/unable-to-connect-to-script-google-com/637818/4 "2021-04-21T20:05:39Z")

</div>

I had the same problem. You only have to downgrade the esp8266 version at 2.4.2 from the Board Manager

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/arduino/user_avatar/forum.arduino.cc/system/32/1140315_2.png) [@system](https://forum.arduino.cc/u/system)\
**Post date:** [August 19, 2021, 8:06pm UTC](https://forum.arduino.cc/t/unable-to-connect-to-script-google-com/637818/5 "2021-08-19T20:06:09Z")

</div>

Closed on August 19, 2021, 8:06pm UTC

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.