Data only posting 4 times

[BigBillTolbert]

I got everything set up or so I think so. What is weird is I get an error message (Error while connecting) and yet a row is posted into the spreadsheet. Then It does that four times and then I get an additional error (Error! Not connected to host.) and no posting to the spreadsheet.

Is there some sort of limiter on the API that would disconnect me if they posts are too close together?

Here is the serial output:

Connection established! IP address: 192.168.4.89 Connecting to script.google.com Connected Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": "1,890,51422"} Error while connecting Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": "2,12,17691"} Error while connecting Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": "3,809,22357"} Error while connecting Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": "4,399,66705"} Connection to re-directed URL failed! Error while connecting Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": "5,65,15800"} Error! Not connected to host. Error while connecting Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": "6,546,78424"} Error! Not connected to host. Error while connecting Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": "7,716,25744"} Error! Not connected to host. Error while connecting Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": "8,289,47307"} Error! Not connected to host. Error while connecting

[StorageB]

How frequent are you publishing to Google sheets? Not exactly sure why, but I have noticed if you're trying to connect too often it will not work correctly. I believe it was recommended by the author of the HTTPSRedirect library used in this tutorial to wait 4 or 5 seconds between each publishing attempt.