Moderator: igrr
Thanks,
Bob
bobsorensen wrote:Thanks for the work on this. I am having trouble getting it to work on my Google Account. Do you have any more written up on how to get the correct GScriptID?
Thanks,
Bob
The next 4 weeks are very hectic so I won't be logging in much. I'll write a detailed tutorial when I return. Please try and follow the tutorial here in the meantime: https://www.topcoder.com/blog/a-simple-webapp-using-google-apps-scripts/
The basic flow is: Create a new spreadsheet in your google account, copy and paste the script using the script editor of google sheets into that sheet. Publish it to the web, with permissions set to "execute as me" and permissions for "anyone, even anonymous".
The script id will be in the "deploy as web app" popup, within the "current web app URL" box. It's the part consisting of random characters between "/macros/s/" and "/exec".