The Scenario
Five interviewers finished their sessions Wednesday. All 30 candidates have been scored — the feedback sheet is complete, with candidate IDs, position IDs, overall scores (1–5), and written notes in columns A through D. Someone in the debrief meeting just asked when the scorecards will be in Breezy HR.
The answer is: not yet. Because submitting 30 scorecards one at a time takes the better part of an hour, and nobody's sat down to do it.
The bad version:
- Open Breezy HR, find the first candidate, navigate to the scorecard tab, enter the overall score, paste in the notes, save.
- Do it 29 more times. Lose your place twice because Breezy HR's interface resets to a different view after saving.
- By candidate 22, realize two interviewers submitted their notes in a different column order than the others. Now you have to figure out which score maps to which candidate before you can continue.
The interview panel did their job. The scores exist. The fact that they're sitting in a Google Sheet instead of Breezy HR is a data-entry problem, not a judgment problem — and it's burning time that should be going into the actual hiring decision.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the feedback rows and submits each scorecard to Breezy HR directly.
For every row in the "Interview Feedback" tab — column A is candidate ID, column B is position ID, column C is overall score (1–5), column D is the notes — submit a Breezy HR scorecard update. Write the result into column E.
What You Get
- 30 Breezy HR scorecard records created, one per candidate, with the overall score and interviewer notes populated.
- Column E shows "submitted" or an error message (e.g., "candidate not found in position") for each row.
- The debrief team can open Breezy HR immediately and see the full panel feedback without waiting for manual entry.
- No score gets entered twice, no candidate gets skipped.
What If the Data Is Not Quite Ready
Different interviewers submitted scores in different column layouts
The "Interview Feedback" tab has inconsistent column order — some rows have score in column C and notes in column D, others have them swapped. Check each row: if column C is a number between 1 and 5, treat it as the score; otherwise treat column D as the score. Submit the Breezy HR scorecard accordingly and write results into column E.
Some rows have notes from multiple interviewers that need to be concatenated
The "Interview Feedback" tab has separate note columns for each interviewer (columns D, E, F). Combine all three into a single notes string, separated by " | ", and submit that as the Breezy HR scorecard notes field. Use column C for the overall score.
You want to exclude candidates who only have a score of 1
Process all rows in the "Interview Feedback" tab where column C is 2 or higher. For rows where column C is 1, write "skipped — below threshold" into column E and do not submit a scorecard. Submit the rest normally.
Normalize scores, merge multi-tab feedback, and submit in one shot
The "Panel A" and "Panel B" tabs both have feedback in the same format (A: candidate ID, B: position ID, C: score, D: notes). Combine both tabs into a single candidate list, averaging the score if a candidate appears in both. Then submit a Breezy HR scorecard for each unique candidate using the averaged score and combined notes. Write results into column E of the "Panel A" tab.
When the debrief is already done, the scorecard submission should be an afterthought — not another hour of work.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where your interview panel drops their scores and notes, then ask it to push all the scorecards to Breezy HR at once. You can also look at bulk advancing pipeline stages or adding recruiter notes.