Getting permission error with setvalue with google apps script on my google spreadsheet
<p>I am calling my google apps script function from my google spreadsheet from cell M1. The idea is to set values in many different rows in column L with the setValue call based on a set of custom rules. This spreadsheet is owned by me where I obviously have the edit rights. But I am getting the error "You do not have permission to call setValue". Why is that? Why am I not able to use the setValue to update my own spreadsheet? What is the purpose of setValue then if it cannot be used this way? How can I achieve what I am trying to do other than using setValue? Thanks.</p>