I have a script which uses OAuth.
When I run the function in the Script Editor, I get the authorize popup and it works fine. But when I run it in the Spreadsheet, nothing happens.
I'm guessing it's something to do with the callback URL? It's set to script.google.com in the service's (Xero) API settings, but Spreadsheets is at docs.google.com. I tried setting it to docs.google.com as well, but still nothing happens.
How do I ask for authorization in the Spreadsheet itself without having to do it in the Script Editor?