DrawSplatTM Teacher Admin

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

Step 1: Create the Google Sheet

  1. Go to sheets.new.
  2. Name the sheet DrawSplatTM Saves.
  3. 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

  1. In the Google Sheet, click Extensions.
  2. Choose Apps Script.
  3. Delete any starter code in the editor.

Step 3: Copy Code.gs

  1. Open DrawSplat Code.gs.
  2. Select all of the code and copy it.
  3. Paste it into the Apps Script editor.
  4. Save the Apps Script project.

Step 4: Run setup()

  1. In the Apps Script toolbar, choose the function named setup.
  2. Click Run.
  3. Approve the Google permissions when prompted.
  4. 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

  1. Click Deploy, then New deployment.
  2. Choose deployment type Web app.
  3. Set Execute as to Me.
  4. Set Who has access to the access level your school allows. Many classroom deployments use Anyone so student links can reach the backend.
  5. Click Deploy.
  6. Copy the Web App URL. It should look like https://script.google.com/macros/s/.../exec.

Step 6: Save the URL in Teacher Admin

  1. Open Teacher Admin.
  2. Unlock Teacher Admin with the temporary password.
  3. Paste the Web App URL into Apps Script Web App URL.
  4. Click Save URL.
  5. 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.