LEO TOOLKIT Google Cloud Setup

Google Cloud walkthrough#

1. Create or select a Google Cloud project owned by the customer organization.
2. Open the API library and enable the Google Sheets API.
3. Create a service account for the LEO TOOLKIT backend.
4. Generate or configure service-account credentials only in the companion backend’s protected environment.
5. Copy the service-account email address.
6. Open every department spreadsheet and share it with that email.
7. Grant Editor access when the bot must modify roster information.

Why a service account is used#

The service account gives the backend a dedicated non-human identity. Google only exposes spreadsheets explicitly shared with that identity. The private key belongs on the backend and must never be placed in Discord bot configuration, frontend code, browser storage, or a public repository.