Connect your Google account
1
Go to Settings → Data → Google Sheets
Navigate to the Google Sheets section in your Settings.[Screenshot: Settings navigation with the Google Sheets section highlighted]
2
Connect Google
Click Connect Google Account. You’ll be redirected to Google’s authorization page.[Screenshot: Connect Google Account button]
3
Authorize access
Sign in to the Google account you want to use and grant Credentials Portal permission to access Google Drive and Sheets.[Screenshot: Google OAuth consent screen]
4
Return to Settings
After authorizing, you’ll be redirected back to Credentials Portal with your Google account connected.
Create a spreadsheet
1
Create Sheet
After connecting, click Create Sheet. Credentials Portal will automatically create a new Google Spreadsheet in your Google Drive named after your district (e.g., “My District — Credentials Data”).[Screenshot: Create Sheet button]
2
Confirm
The spreadsheet name appears in your settings once created.
Sync data
Once a spreadsheet is selected, click Sync Now to push your current district data to Google Sheets. [Screenshot: Sync Now button with a last synced timestamp] The sync updates (or creates) five tabs in your spreadsheet:Sync is one-way: data flows from Credentials Portal to Google Sheets. Changes made in Google Sheets are not synced back.