Why new permissions are needed?

[ewoks]

First of all thanks for sharing this, it is very appreciated.

Could you please add permission explanation to the readme, which permissions are necessary and why exactly? Is there an alternative to give permission? Could we limit the scope and how we could make users feel safer? Thanks a lot

[demmings]

Hey Ewoks,

All I know about the GAS permissions is that Sheets will prompt you to Grant Authorization for the script to run the first first time only. It has been so long ago since the first time I ran CacheFinance, I can't remember if there was any specific access that it needed (even as the creator for the fuction, I was also prompted to allow it authorization to run). It is not anything that the custom function requests, but Google may be looking at the types of external access that the function makes. I think that the only thing that could be done (like you say) would be to give some indication in the CacheFinance documentation that Google Sheets will be asking for your authorization before it will allow you to run it the first time.