Is it possible to have part of an editor Apps Script run if the user isn't signed into Google?

[Michael Leggett]

Is there any way to have an editor Apps Script run for someone NOT signed into a Google Account?
The spreadsheet is set to anyone with the link can edit.

A little context: we built an Apps Script on a spreadsheet that we duplicate and share as part of a larger app. In testing, parts of the script it worked without the new user giving permission (like onEdit that just depends on the event) while other parts required they give the script permission to run.

But when some users used the spreadsheet without being signed into Google, we realized none of the Apps Script is running. We've tried publishing it as a web app and setting the access to ANYONE_ANONYMOUS but that didn't solve it:

"webapp": {

  "access": "ANYONE_ANONYMOUS",

  "executeAs": "USER_DEPLOYING"

},

We tried publishing it as an Add-on but if the user isn't signed into their Google Account, the Add-on doesn't run. 

Thanks for any advice or help,
Michael Leggett
Director of Product, Nori

[Alex]

Hi Michael!

All of this is a part of security. You can do nothing without a source allocation. For the allocation you have to sign-in to the system.

Best, Alex.

[Michael Leggett]

Thanks Alex -- that's what I was afraid of. 

I guess I got my hopes up because of the "access": "ANYONE_ANONYMOUS". 

[Kim Nilsson]

Michael,

you could of course change the executeAs to be the owner of the script.

But, that would then be the case for anyone who runs the file.

[Michael Leggett]

Can a moderator please delete the above message? 

I sent it from a previous work account and it has my personal phone number in it which is searchable on the web. 

[Kim Nilsson]

Done!