In order to send data to google spreadsheet I need to request HTTP access to the unique URL, something like this:
https://script.google.com/macros/s/AKfycbz7jkkd7nfa6ThjOqGw5KZgnUUxIOrxCV_m8WithLQD4EAS7hx6/exec?SOMEDATEHERE
I tried with:
GET https://script.google.com/macros/s/AKfycbz7jkkd7nfa6ThjOqGw5KZgnUUxIOrxCV_m8WithLQD4EAS7hx6/exec?SOMEDATEHERE HTTP/1.0
,
but with no success.
Any idea how to execute this HTTP request with AT Commands?
I manage to do it.
First of all I wasn't able to make it work with Arduino IDE Serial Monitor because of Carriage Return and New Line characters so I switched to RealTerm. In it I manually write "\r\n" after every AT command. New i connected Googles Spreadsheet link with Pushingbox (as shown in this video). After that I used next AT commands:
Thanks for help.