1) Give a description of the problem
I cannot get my data to log to a google sheet
2) What is the expected behaviour?
A switch is turned “On”
The time and status are captured and stored to a variable
Variables are then logged onto a google sheet
3) What is happening/not happening?
I have everything working apart from the data being applied to the google sheet
**4) Post a Green Snapshot of the piston![image|45x37]![image|690x305]![image|690x305]
5) Attach logs after turning logging level to Full
|+0ms|╔Received event [Floor Lamp - LR].switch = on with a delay of 30ms|
|---|---|
|+29ms|║RunTime Analysis CS > 13ms > PS > 4ms > PE > 13ms > CE|
|+31ms|║Runtime (37875 bytes) successfully initialized in 4ms (v0.3.110.20191009) (30ms)|
|+32ms|║╔Execution stage started|
|+39ms|║║Comparison (enum) on changes_to (string) on = true (1ms)|
|+40ms|║║Cancelling condition #2's schedules...|
|+41ms|║║Condition #2 evaluated true (5ms)|
|+42ms|║║Cancelling condition #1's schedules...|
|+43ms|║║Condition group #1 evaluated true (state changed) (7ms)|
|+45ms|║║Cancelling statement #3's schedules...|
|+50ms|║║Executed virtual command setVariable (2ms)|
|+55ms|║║Executed virtual command setVariable (3ms)|
|+63ms|║║Sending external web request to: docs.google.com/spreadsheets/d//edit#gid=1584300131|
|+237ms|║║Error executing external web request: groovyx.net.http.HttpResponseException: Method Not Allowed|
|+238ms|║║Executed virtual command httpRequest (176ms)|
|+240ms|║╚Execution stage complete. (208ms)|
|+241ms|╚Event processed successfully (242ms)|