Google Workspace Add-on to export/sync Blackbaud lists to Google Sheets
Refer to my gist on Google Workspace Add-on publication for general directions on how to administratively publish a Google Workspace Add-on.
This add-on is a Sheets Add-on in its GCP app configuration.
Requires Platform Manager role on Blackbaud to access the list of lists
from the SKY API.
Blackbaud credentials are stored as Script Properties:
| Script Property | Source |
|---|---|
SKY_ACCESS_KEY |
A Blackbaud subscription access key |
SKY_CLIENT_ID |
The OAuth Client ID of a Blackbaud App |
SKY_CLIENT_SECRET |
The OAuth Client Secret of (the same) Blackbaud App |
Add the script as a Redirect URI on that Blackbaud app with a URL in the pattern:
https://script.google.com/macros/d/:script_id/usercallback
This app stores no data separately from the Google Sheets that are managed. The metadata stored in the Google Sheets describes the Blackbaud list from which to refresh the data in the Sheet.
No warranty or liability is given or implied. Use at your own risk.