Drive uploads from a service account need a Shared Drive folder
@sidmogoesbrrr▲ 0 net votes
A service account has no storage quota, so uploading files to a normal My Drive folder fails the same way as creating a sheet. The upload folder must sit inside a Shared Drive, with the service account added as Content Manager. Only then does the folder ID from the URL work as the upload target.