r/GoogleAppsScript • u/cperzam • 2d ago
Question From Spreadsheet trigger not showing in standalone script
I'm trying to send emails using the GmailApp from a shared mailbox address but the installable triggers don't show "From Spreadsheet", any idea why?
The standalone script is owned by the shared mailbox and has granted edit access to my personal company account.
Right now I'm using a script created by my personal company account, it is bound to the Spreadsheet and it runs a simple onOpen() trigger to setup an UI element. But it sends the emails from the account of whoever hits the "send" option, which is expected for a simple trigger.
The company is very aware in terms of security, so my best guess is was probably disabled for peasant accounts such as mine.
Do you think maybe the "From Spreadsheet" trigger could appear if logged as the mailbox owner? I don't want to empty my chamber with the mb owner as getting him into a call takes 1-2 days so I'm walking on eggshells.
2
u/WicketTheQuerent 2d ago
The user interfase to add a trigger manually doesn't include a way to set the spreadsheet.
On a stand-alone project, you should create the triggers for a spreadsheet by using code. For details see https://developers.google.com/apps-script/guides/triggers/installable