const char* ssid = "Leeroy Jenkins";
const char* password = "12345678";
const char* scriptId = "AKfycbyByeSvX-wBP0sSa5U-T4D5u4z5IAjQM-N7fJx_ngrVmiw2g_qmmLMafnU7EiOFollm7g";
void setup() {
Serial.begin(9600);
delay(1000);
WiFi.begin(ssid, password);
while (WiFi.status() != WL_CONNECTED) {
delay(1000);
Serial.println("Connecting to WiFi...");
}
Serial.println("Connected to WiFi");
}
void loop() {
if (WiFi.status() == WL_CONNECTED) {
WiFiClientSecure client;
if (client.connect("script.google.com", 443)) {
String postData = "{"function": "insertStudentData", "id": 123, "code": "ABC", "name": "John"}";
client.println("POST /macros/s/" + String(scriptId) + "/exec HTTP/1.1");
client.println("Host: script.google.com");
client.println("User-Agent: ESP8266/1.0");
client.println("Connection: close");
client.println("Content-Type: application/json");
client.print("Content-Length: ");
client.println(postData.length());
client.println();
client.println(postData);
client.println();
delay(500);
while (client.available()) {
String line = client.readStringUntil('\r');
Serial.print(line);
}
client.stop();
} else {
Serial.println("Connection to Google Apps Script failed");
}
}
delay(1000); // Adjust delay as needed
}
serial returns Connection to Google Apps Script failed
magdykhedr
copilot