My company has several shared Google Drives and each of those are shared among different teams. I want to upload data to one of those drives using a Python script. More precisely, I want to upload to a specific folder in a drive and not to any other location. So the Python script should only have minimal permissions because I don't want my Python script to wreak havoc on the drive.
Is it possible to grant an application permissions on a folder level? If not, what would be the best strategy to tackle the file upload (e.g. a new shared drive, mounting a bucket in google drive)?
I already looked for information here, here, here and other places, but could not find any useful information.