Cell value from google spreadsheet to arduino with SIM800l via PUSHINGBOX

hello :slight_smile:

im stuggling for days on a project and hope that somebody can help me out or give me some new input.

What i want to do
-read a value from a cell from a google spreadsheet and get it into the arduino+SIM800l with the help of pushingbox service

What i have already done
-setting up a spreadsheet and wrote a short google app script and deployed it as web app. I got the web app URL (google app script, klick me), which is working. i can run it in a browser and the returned value is correct (666).
-creating a new service on pushingbox and insert the google app script link there
-setting up the arduino with connected SIM800l module to make a request to pushingbox
-connection to pushingbox is working (i got a entry in the history on the Dashboard of pushingbox)
-BUT: there is NO value returned to the arduino

The problem
-When checking the serial monitor, the AT+HTTPREAD command is returning nothing. I must missed something out, maybe on the way from pushingbox to SIM800l? Because the web app URL by it self is working…

Here are my codes so far:

google app script code

// Get Cell value
function doGet()
{  
  var id = '1IHwMhpe2mtGSrqdoZ7wQqthyzWKnMqGL0vrbX5M7DpM';
  var sheet = SpreadsheetApp.openById(id).getSheetByName("tab1");
  var range = sheet.getRange(1,1);
  var value = range.getValue();
  var textOutput = ContentService.createTextOutput(value);
  Logger.log(value);
  
// Return result of operation
  return ContentService.createTextOutput(value);
}

arduino code:

#include <SoftwareSerial.h>
SoftwareSerial Sim800l(3, 2);
#define SIMpower 9

String url = "api.pushingbox.com/pushingbox?devid=v72844200CBAC938";

void setup() {
  pinMode(SIMpower, OUTPUT);
  digitalWrite(SIMpower, HIGH);
  Serial.begin(9600);
  Sim800l.begin(9600);
  Serial.println("startup");
}

void loop() {
  2google();
}

void 2google() {
  Sim800l.listen();
  delay(20000);

  Sim800l.println("AT+SAPBR=3,1,APN,internet");   //o2 Internet
  delay(2000);
  while (Sim800l.available()) {
    Serial.write(Sim800l.read());
  }
  Sim800l.println("AT+SAPBR=1,1");
  delay(2000);
  while (Sim800l.available()) {
    Serial.write(Sim800l.read());
  }
  Sim800l.println("AT+httpinit");
  delay(2000);
  while (Sim800l.available()) {
    Serial.write(Sim800l.read());
  }
  Sim800l.println("AT+HTTPPARA=URL," +  url) ;

  delay(2000);
  while (Sim800l.available()) {
    Serial.write(Sim800l.read());
  }

  Sim800l.println("AT+httpaction=0");
  delay(2000);
  while (Sim800l.available()) {
    Serial.write(Sim800l.read());
  }
  Sim800l.println("AT+httpread");
  delay(2000);
  while (Sim800l.available()) {
    Serial.write(Sim800l.read());
  }
  Sim800l.println("AT+HTTPTERM");
  delay(2000);
  while (Sim800l.available()) {
    Serial.write(Sim800l.read());
  }
  Sim800l.println("AT+SAPBR=0,l");

  while (Sim800l.available()) {
    Serial.write(Sim800l.read());
  }
  Sim800l.println("AT+CGATT=0");  //NEU
  while (Serial.available()) {
    Sim800l.write(Serial.read());
  }
}

serial monitor output

startup
AT+SAPBR=3,1,APN,internet
OK
AT+SAPBR=1,1
OK
AT+httpinit
OK
AT+HTTPPARA=URL,api.pushingbox.com/pushingbox?devid=v72844200CB
AT+httpaction=0
OK
+HTTPACTION: 0,200,0
AT+httpread
OK
AT+HTTPTERM
OK
AT+SAPBR=0,l
AT+CGATT=0
ERROR

Maybe somebody of you also tried to read values from spreadsheet with an arduino and SIM800l ?
Pls ask me if you need more information/code to help me with this problem.

Greetings and a happy day :slight_smile:

Really nobody tries to read values from googlespreadsheets using SIM800l ? :frowning: :frowning:
Maybe somebody have a different approach?