Stop relying on manual CSV exports. In this technical Skills Lab, we move beyond the "why" and dive straight into the "how" of building a live data connection between Blackbaud and Google Workspace. This session is designed for school technologists who want to turn static Advanced Lists into programmatic, accessible data.

Using a provided Google Apps Script starter template, we will work through a sample implementation of the SKY API. We will begin by configuring a new application in the Blackbaud Developer Portal and navigating the OAuth2 "Authentication Dance" to connect with the Script. Once connected, we will walk through the logic to programmatically fetch an existing Advanced List from your environment and populate it into a Google Sheet.

You will learn the mechanics of API scopes, redirect URIs, and the UrlFetchApp service. By the end of this session, you will have a working script that bridges the gap between Blackbaud’s data and Google’s flexibility, providing a foundational engine for your school’s custom reporting and integrations.

Prerequisites for Participation: A Blackbaud SKY Developer account. Marketplace or Org Admin credentials for their environment. One "Advanced List" already created in Blackbaud (under 1,000 rows) to use as a data source. A Google account with access to Google Apps Script.