RFID data sent to Google sheets.

Hi all,
does anyone have any experience with sending RFID data from arduino mkr1000 to Google sheets? i am trying to send data from the mkr1000 to Google sheets through pushingbox but the data seems to be getting lost somewhere in between the arduino and pushingbox, i’m hoping someone could help me with this issue or if anyone knows how to send data directly from the arduino to Google sheets without the use of pushingbox that would make things a lot easier, below is the arduino code and then the G.script for Google sheets -
arduino -
//Created by = Austin Goodall
//Date created on: 15/10/2020
//Modified on:
#include <WiFi101.h>
#include <Wire.h>
#include <SPI.h>
#include <MFRC522.h>
#define SS_PIN 1
#define RST_PIN 0
MFRC522 mfrc522(SS_PIN, RST_PIN); //Create MFRC522 instance
int greenLED = 5;
int redLED = 4;
int x = 0;
const char WEBSITE = “api.pushingbox.com”;//pushingbox API server
const String devid = “”;// device ID on Pushingbox for your scenario
const char* MY_SSID = “”;//your wifi name
const char* MY_PWD = “”;//wifi password
int status = WL_IDLE_STATUS;
WiFiClient Client; //Instantiate WiFi object, can scope from here or Globally
void setup()
{
Serial.begin(9600);//initiate a serial communication
while (!Serial){
;//wait for serial port to connect. needed for native USB port only
}
//check for the presence of the shield:
if (WiFi.status() == WL_NO_SHIELD){
Serial.println(“Wifi shield not present”);
while (true);
}
//attempt to connect to wifi network:
while (status != WL_CONNECTED)
{
Serial.print("Attempting to connect to SSID: ");
Serial.println(MY_SSID);
//Connect to WPA/WPA2 network. change this line if using open/WEP network
status = WiFi.begin(MY_SSID, MY_PWD);
delay(10000);
}
Serial.println(“Connected to Wifi”);
printWifiStatus();
SPI.begin();//initiate the SPI bus
mfrc522.PCD_Init();//initiate MFRC522
pinMode(greenLED, OUTPUT);
pinMode(redLED, OUTPUT);
Wire.begin();
Serial.println(“Approximate your card to the reader…”);
Serial.println();
}
void loop()
{
// look for new cards
if (! mfrc522.PICC_IsNewCardPresent())
{
return;
}
// show UID on serial monitor
Serial.print(“UID tag :”);
String content= “”;
byte letter;
for (byte i = 0; i < mfrc522.uid.size; i++)
{
Serial.print(mfrc522.uid.uidByte <0x10 ? " 0": " ");
_ Serial.print(mfrc522.uid.uidByte*, HEX);_
_ content.concat(String(mfrc522.uid.uidByte < 0x10 ? " 0": " "));
content.concat(String(mfrc522.uid.uidByte, HEX));
}
Serial.println();
Serial.print("Message : ");
content.toUpperCase();
if (Client.connect(WEBSITE, 80)){*_

* Client.print(“GET /pushingbox?devid=&allowed_members=”);
_ if (x >= 5){
Client.print(“Max Cap no access”);
Client.print(0);
Serial.print(“Max Cap no access”);
digitalWrite(greenLED, LOW);
digitalWrite(redLED, HIGH);
}
else if (content.substring(1) == “A3 55 68 1A”)
{
Serial.println(“Welcome Austin”);
Client.print(“Austin”);
Client.print(1);
x = x + 1;
Serial.print(x);
digitalWrite(greenLED, HIGH);
digitalWrite(redLED, LOW);
delay(3000);
}
else if (content.substring(1) == “9A 41 EE 3F”)
{
Serial.println(“Welcome Margaret”);
Client.print(“Margaret”);
Client.print(1);
x = x + 1;
Serial.print(x);
digitalWrite(greenLED, HIGH);
digitalWrite(redLED, LOW);
delay(3000);
}
else if (content.substring(1) == “6B 48 53 0D”)
{
Serial.println(“Welcome Lachlin”);
Client.print(“Lachlin”);
Client.print(1);
x = x + 1;
Serial.print(x);
digitalWrite(greenLED, HIGH);
digitalWrite(redLED, LOW);
delay(3000);
}
else if (content.substring(1) == “45 3B D4 2A”)
{
Serial.println(“Welcome Sienna”);
Client.print(“Sienna”);
Client.print(1);
x = x + 1;
Serial.print(x);
digitalWrite(greenLED, HIGH);
digitalWrite(redLED, LOW);
delay(3000);
}
else {
Serial.print(“Access Denied”);
Client.print(“Accees Denied”);
Client.print(0);
digitalWrite(greenLED, LOW);
digitalWrite(redLED, HIGH);
delay(3000);
}
// HTTP 1.1 provides a persistent connection, allowing batched requests*

* // or pipelined to an output buffer*
* Client.println(" HTTP/1.1");
Client.print(“Host: “);
Client.println(WEBSITE);
Client.println(“User-Agent: MKR1000/1.0”);
//for MKR1000, unlike esp8266, do not close connection*

* Client.println();
Serial.println(”\nData Sent”); *_

* } *
}
void printWifiStatus() {
* // print the SSID of the network you’re attached to:*
* Serial.print("SSID: ");*
* Serial.println(WiFi.SSID());*
* // print your WiFi shield’s IP address:*
* IPAddress ip = WiFi.localIP();*
* Serial.print("IP Address: ");*
* Serial.println(ip);*
* // print the received signal strength:*
* long rssi = WiFi.RSSI();*
* Serial.print(“signal strength (RSSI):”);*
* Serial.print(rssi);*
* Serial.println(" dBm");*
}
*G.script - *
*function doGet(e) { *
* Logger.log( JSON.stringify(e) ); *
* var result = ‘Ok’;*
* if (e.parameter == undefined) {*
* result = ‘No Parameters’;*
* }*
* else {*
* var id = ‘1IdD_xZi-mMJaFfc5ZFZwpzejlfmVDXLd5HNVHA9aXH0’; // Spreadsheet ID*
* var sheet = SpreadsheetApp.openById(id).getActiveSheet();*
* var newRow = sheet.getLastRow() + 1;*
* var rfidData = [];*
* rfidData[0] = new Date();*
* for (var param in e.parameter) {*
* Logger.log(‘In for loop, param=’+param);*
* var value = stripQuotes(e.parameter[param]);*
* switch (param) {*
* case ‘allowed_members’: //Parameter*
* rfidData[1] = value; //Value in column B*
* break;*
* case ‘Member_ID’:
_ rfidData[2] = value;
break;
default:
result = “Wrong parameter”;
}
}
Logger.log(JSON.stringify(rfidData));
// Write new row below*

* var newRange = sheet.getRange(newRow, 1, 1, rfidData.length);
newRange.setValues([rfidData]);
}
// Return result of operation*

* return ContentService.createTextOutput(result);
}
/**
Remove leading and trailing single or double quotes_

*/
function stripQuotes( value ) {
* return value.replace(/^["’]|[’"]$/g, “”);*
}