Arduino to google sheet


#1

Welcome:

I’ve worked on a program to receive the data from the Arduino board to another Arduino board via serial to serial
Then the other Arduino linked me to the ethrnet board to send data to Google sheet.
When a connection TX and RX, I receives data in serial monitor but does not send anything to google sheet.

      please help me`




indent preformatted text by 4 spaces

#include <SPI.h>
#include <Ethernet.h>
//-------------------------------------------------------------------------------
byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED }; //Setting MAC Address
char server[] = “api.pushingbox.com”; //pushingbox API server
IPAddress ip(192,168,1,7); //Arduino IP address. Only used when DHCP is turned off.
EthernetClient client; //define ‘client’ as object
String data; //GET query with data
String suhu; //suhu (bahasa Indonesia) means temperature
boolean koneksi = false;
//------------------------------------------------------------------------------
void setup() {
Serial.begin(115200);
if (Ethernet.begin(mac) == 0) {
Serial.println(“Failed to configure Ethernet using DHCP”);
Ethernet.begin(mac, ip);
}
delay(1000);
}
//------------------------------------------------------------------------------
void loop(){
if (Serial.available() > 0) {
suhu = Serial.readString();
}// ADC to celcius conversion
kemasData(); //packing GET query with data
Serial.println(“connecting…”);
if (client.connect(server, 80)) {
sendData();
koneksi = true; //connected = true
}
else{
Serial.println(“connection failed”);
}
// loop
while(koneksi){
if (client.available()) {
char c = client.read(); //save http header to c
Serial.print©; //print http header to serial monitor
}
if (!client.connected()) {
Serial.println();
Serial.println(“disconnecting.”);
Serial.print(“Temperature Sent :”);
Serial.println(suhu); //print sent value to serial monitor
client.stop();
koneksi = false;
data = “”; //data reset
}
}
delay(5000); // interval
}

void kemasData(){
data+="";
data+=“GET /pushingbox?devid=vB990F945F7F0481&tempData=”; //GET request query to pushingbox API
data+=suhu;
data+=" HTTP/1.1";
}
void sendData(){
Serial.println(“connected”);
client.println(data);
client.println(“Host: api.pushingbox.com”);
client.println(“Connection: close”);
client.println();
}


#2

Hey @anwar,

It looks like your question is about the PushingBox notification service. This is Exosite’s forum to help people connect their devices to our IoT platform and our software products.

It looks like you ended up on the wrong help page; PushingBox specific help looks to be available.

If you find that are interested in connecting your Arduino to Murano feel free to get started!

Happy to help,
-Martin


#3