I have been able to upload files to a Google Drive account from within a Google Spreadsheet. The problem is that as far as I am able, I can only upload files to the currently logged in account.
Is it possible to be logged in with account A and viewing a spreadsheet, but upload files to account B from a menu option? Is this even allowed/possible?
Use Case: I have a spreadsheet with a couple of sheets. A user login will only have access to edit one sheet on the spreadsheet, but as part of that sheet the user should be able to upload photos to the spreadsheet owners google drive. So the main "admin" account holds the spreadsheet and photos and then there are a couple of edit accounts with edit rights to a specific sheet.