AI Fetch CBC – Transcript Preview, AI Fetch & Data Source Issues

[sneha-s-chaudhari]

Describe the bug
Multiple issues were observed:

1. Transcript Preview Not Visible
   Transcript PDF is available and loaded, but the transcript preview panel appears blank/black.
   Browser console shows multiple 400 (Bad Request) API errors related to transcript data retrieval.
2. AI Suggested Data Not Fetching
   Clicking "Fetch Data Using AI" opens the AI Suggested CBC Data popup.
   No university, college, major, or credential data is fetched.
   Popup displays "No data found" despite transcript being available.
3. Incorrect Data Source
   Current implementation is fetching data from CSV files.
   As per requirement, AI Fetch CBC should retrieve data from Google Sheets instead of CSV.

Environment

• Moderator panel
• User Panel

To Reproduce
Steps to reproduce the behavior:

1. Login to EvalBridge.
2. Navigate to Type of Evaluation → Course by Course.
3. Upload/open a transcript.
4. Observe transcript preview section.
5. Click Fetch Data Using AI.
6. Verify AI Suggested Data popup.
7. Check browser network/console logs.

Expected behavior
AI should fetch and display University, College, Major, Credential, and related CBC data.
No API errors should occur.
Data should be fetched from the configured Google Sheet source instead of CSV files.

Screenshots