I don't think you get it. If you want to automate anything in Google drive, that's the modularity of permissions in Google APIs:

https://developers.google.com/drive/api/guides/api-specific-...

I automate things all the time. If you want ChatGPT to provide feedback on a document, the above is what I've got to work with. If I want a web app to maintain a spreadsheet, again, that's what I've got.

Granular permissions = more secure.