if (client.connect("sheets.googleapis.com", 443) == true) { enviar = "GET /v4/spreadsheets/" + id_planilha + "/values/" + aba + "!" + celulas + "?key=" + chave_de_API + " HTTP/1.1"; client.println(enviar); client.println("Host: sheets.googleapis.com"); client.println(dados); client.println(); client.stop();

if (client.connect("sheets.googleapis.com", 443) == true) { enviar = "GET /v4/spreadsheets/" + id_planilha + "/values/" + aba + "!" + celulas + "?valueInputOption=USER_ENTERED?key=" + chave_de_API + " HTTP/1.1"; dados = "{"majorDimension": "ROWS",rn"; dados += ""values": [rn"; dados += "[rn"; dados += "60"; dados += "rn"; dados += "]rn"; dados += "]rn"; dados += "}rn"; client.println(enviar); client.println("Host: sheets.googleapis.com"); client.println(dados); client.println(); client.stop();