Google Sheets Sync & Management

1. Export Universities to Sheet

Export all university data from the app to a specified tab in your Google Sheet. This is ideal for getting a master copy with all external_ids.

Spreadsheet ID *

Export To Tab Name *

2. Sync Universities from Sheet

Import university data from a Google Sheet. Use upsert mode for updates or wipe & create for a complete refresh.

Spreadsheet ID *

Tab Name *

Wipe existing data and create fresh (⚠️ Use with caution)

Setup Instructions

Set up GOOGLE_SHEETS_SERVICE_ACCOUNT_KEY in Dashboard → Settings → Environment Variables
Share your Google Sheet with the service account email (found in the service account JSON)
Grant "Editor" permissions to the service account

Export first to get the correct data format and column headers
Use upsert mode for regular updates (matches by external_id)
Use wipe & create mode only for complete data replacement
Spreadsheet ID is found in the URL: docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit