Google Apps Script Setup
Create the Web App URL for DrawSplatTM.
Use these steps to copy the DrawSplatTM backend code into Google Apps Script, deploy it as a Web App, and paste the Web App URL into Teacher Admin.
What You Need
- A Google account that can create Google Sheets and Apps Script projects.
- The temporary Teacher Admin password, available by request through the Contact / Information Request form.
- The DrawSplatTM backend file: apps-script/Code.gs.
Step 1: Create the Google Sheet
- Go to sheets.new.
- Name the sheet DrawSplatTM Saves.
- Keep the sheet open. Apps Script will use it for board metadata, rooms, templates, turn-ins, audit records, and compliance records.
Step 2: Open Apps Script
- In the Google Sheet, click Extensions.
- Choose Apps Script.
- Delete any starter code in the editor.
Step 3: Copy Code.gs
- Open DrawSplat Code.gs.
- Select all of the code and copy it.
- Paste it into the Apps Script editor.
- Save the Apps Script project.
Step 4: Run setup()
- In the Apps Script toolbar, choose the function named setup.
- Click Run.
- Approve the Google permissions when prompted.
- If Google shows an unverified-app warning, continue only if you trust this DrawSplat deployment and the Google account you are using.
Step 5: Deploy as a Web App
- Click Deploy, then New deployment.
- Choose deployment type Web app.
- Set Execute as to Me.
- Set Who has access to the access level your school allows. Many classroom deployments use Anyone so student links can reach the backend.
- Click Deploy.
- Copy the Web App URL. It should look like
https://script.google.com/macros/s/.../exec.
Step 6: Save the URL in Teacher Admin
- Open Teacher Admin.
- Unlock Teacher Admin with the temporary password.
- Paste the Web App URL into Apps Script Web App URL.
- Click Save URL.
- Click Test Connection. A successful test means the whiteboard can use this backend from this browser.
Step 7: Return to the Whiteboard
After the URL is saved, return to the whiteboard. Save to Google, Cloud Sync, templates, turn-ins, and classroom links will use the Apps Script URL saved in that browser.