Off Prompt

AI Tools for Small Business

Operations

Create a Weighted Interview Scorecard for Google Sheets

Run this as a follow-up prompt in the same conversation after generating your interview questions. It produces a complete scoring sheet with behavioral anchors and weighted competencies ready to paste into Google Sheets.

The Prompt

Now create a scoring sheet for these interviews. For each competency, include: a 1–5 rating scale with behavioral anchors (describe what a '1' answer looks like and what a '5' answer looks like), a notes field, and a weighted score. Assign weights to each competency based on what matters most for this role — explain your weighting rationale briefly. At the bottom, include fields for: candidate name, date, interviewer name, total weighted score, and a hire / no-hire recommendation. Format this so I can copy it into a Google Sheet.

From the guide

Using AI to create a simple interview question set and scoring sheet for hiring your first or next employee →

Related Prompts