- Create a new excel sheet
- Inside the sheet, in
Tools
menu, click onscript editor
, and copy and paste the script from below - Select function
Setup
, run it. - From
Publish
menu, click onDeploy as web app
- enter Project Version name and click 'Save New Version'
- set security level and enable service (most likely execute as 'me' and access 'anyone, even anonymously)*
- Copy that deploy url, Example:
https://script.google.com/macros/s/AKfycbzlsdMgcBasdum7c14OU01mQ99nxV7p7ge6QmEuvS5w/exec