Trying to update a google sheet with a boolean array.
When running the query I get this "requested writing within range" error below.
The destination Google Sheet column is in Boolean format but I get this error regardless of the column I choose.
This query does work if I use another non-boolean array instead - the google sheet updates fine - so I guess the issue is particular to this value?
This array has come from a check box by the way.
If a solution involves transforming the array from true/false into 1/0 this would be great too. I tried and failed to achieve this through a transformer.