PowerSchool + Google Onboarding

Step 1: Set up your Google environment (5 minutes)

• Create a new User in Google, who will be the "calendar owner" and creator of the events that get created. Name the User "SchoolCal Admin" or something related, and set the email as ("schoolcal@yourdomain"). We'll need to log in to SchoolCal with this User later in onboarding.

• Create a "Custom Admin Role" in Google Admin Console. Name it something like, "Calendar Administrator". This role needs the following permissions:

  • USERS -> "READ" access to

  • CALENDAR -> "ALL SETTINGS"

  • The role should have 11 privileges assigned

• Assign your new SchoolCal user to the new custom role

  • Press the "assign members" button 

  • Assign your SchoolCal user (created in the previous step) to this role

• Create a Domain Wide Delegated service account to access the required scopes

  • Login to Google Admin Console and navigate to Manage Domain Wide Delegation (Security > API Controls > Manage Domain Wide Delegation)

  • Click “Add new”

  • Input the Client ID from your SchoolCal account

    • Login to SchoolCal (app.schoolcal.com)

    • Click “Connections” on the left-hand menu

    • Copy your Client ID and paste in Google

  • Enter the required OAuth scopes (⚠️ Note: The list of OAuth scopes may be updated in the Admin Console. Always verify the required scopes there before proceeding.)

• https://www.googleapis.com/auth/calendar.events

• https://www.googleapis.com/auth/calendar

• https://www.googleapis.com/auth/admin.directory.user.readonly

• https://www.googleapis.com/auth/admin.directory.resource.calendar.readonly

Step 2: Set up your PowerSchool environment (5 min)

• Download and install the SchoolCal PowerSchool plugin

Step 3: Connect Powerschool to SchoolCal (5 min)

• Sign in to SchoolCal with your Google email

• Click “Connections” from the left-hand menu

• Find “PowerSchool” and click “Manage Connection”

• Fill in your school's short name, API username, and secret key (found on the Plugin Management Dashboard by clicking the SchoolCal plugin)

• Click “Update Connection”

• Click “Data” from the left-hand menu

• Click “Load SIS Data”

Step 4: Connect Google to SchoolCal (3 min)

• Click “Connections” from the left-hand menu

• Find “Google” and click “Manage Connection”

• Click “Edit”

• Enter the email address for your SchoolCal Google user

• Click “Update Connection”

Step 5: Run a Test Sync (10 min)

• Navigate to “Flows” in the left-hand menu

• Click “Add New Flow”

• Select Flow Type: “Class Schedules to User Calendars”

• Input Flow Name, e.g. “Schedules Test Sync”

• Find your new Flow under all Flows, and click View Details

• Click Filters and apply desired filters for this Flow

• Click Template and customize how the events are displayed

  • Select an event type from the “Available Fields” panel on the right

  • This will display all metadata available to add to the template

  • To input metadata, wrap metadata names in brackets {{ }}, and use periods to indicate nested or “child” schema

  • Example: to include a Class Schedule’s course name, you’d write: {{Section.Course.Name}}

• Enable the Pilot Mode toggle at the top of the Flow page

• Click the Pilot Users link below the toggle, and input the users you want to run a test sync with

• Click Sync Flow Now to initiate a sync