Skip to article
DrawSplat Wiki
Read in your language

Google machine translation · Opens a new tab.

Translation help
For technology admins
Source

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.

Open Code.gs View Code.gs on GitHub

For district-hosted classrooms, follow MySQL / MariaDB setup instead. This page configures the separate Drive/Sheets backend.

What You Need

  • A Google account that can create Google Sheets and Apps Script projects.
  • Access to the installation’s Teacher Admin settings, if its local settings gate is enabled. District teachers using Google sign-in and MariaDB/MySQL do not need this Apps Script setup or a special unlock password.
  • The DrawSplatTM backend file: apps-script/Code.gs.

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.