6DuckLearn Skills

hiring metrics sheets

Build hiring metrics formulas in Gemini in Sheets and analyse hire data by department and month — a two-step Sheets workflow.

collaboration Tags: curated, google-workspace, hr, recruiting, hiring

Attribution: Prepared by 6DuckLearn. Inspired by Google Workspace with Gemini Prompting Guide 101 (2025).

When to use this

You're an HR manager or recruiter who needs to analyse your hiring data in Google Sheets — whether setting up formulas to count hires by department, identifying which month saw the most hiring activity, or building a metrics dashboard.

What you'll get

Ready-to-use Sheets formulas and follow-up analysis for your hiring data: COUNTIFS formulas broken down by department, month-over-month hiring trend analysis, and plain-language answers to data questions — all generated within your spreadsheet.

Prompt template

Use this in Gemini in Sheets (with your hiring data sheet open):

Step 1 — Formula: Help me create a formula to calculate the total number of hires by department. My data has columns: [list your column headers, e.g. "Name, Department, Start Date, Role, Status"].

Step 2 — Analysis: In what month did we hire the most people? Show me the month-by-month breakdown.

Fill in the variables:

  • [list your column headers] — paste your actual column headers so Gemini generates the correct column references (e.g. A, B, C)
  • Run Step 1 first to get the formula; then run Step 2 as a follow-up in the same session for the analysis

Customisation tips

  • Add time filters: "Show totals by department for Q1 2025 only"
  • Request a summary table: "Create a new sheet with a pivot-style summary: Department | Total Hires | % of Total"
  • Track time-to-hire: "Add a formula to calculate the average days between [Application Date] and [Start Date] by department"
  • Visualise the data: "Create a bar chart showing monthly hires over the past 12 months"

Iteration suggestions

After Gemini builds your metrics:

  1. Report to leadership → export key numbers and present them in the context of survey-results-leadership-summary format
  2. Identify process gaps → bring findings back to recruiting-process-improvement to address any departments with low hire rates or long time-to-fill

Related skills in this workflow

Step Skill What it does
1 recruiting-process-improvement Brainstorm process improvements
2 job-description-writer Write the job description
3 interview-screening-questions Generate screening questions
4 offer-letter-template Draft the offer letter
5 rejection-letter-empathetic Write rejection letters
6 → You are here hiring-metrics-sheets Build and analyse hiring metrics in Sheets

Related skills

  • interview screening questions — Generate 20 open-ended interview screening questions from an uploaded job description file using the Gemini app.
  • job description writer — Write a compelling, tailored job description for a specific role and team in Gemini in Docs.
  • offer letter template — Draft a professional offer letter template for a selected candidate with a call-to-action to discuss details, in Gemini in Docs.
  • recruiting process improvement — Generate a strategic list of improvements to the recruiting process and candidate identification methods in Gemini in Docs.
  • rejection letter empathetic — Write an empathetic, respectful rejection letter for unsuccessful job candidates in Gemini in Docs.
  • gemini hr recruiting hiring — Write job descriptions, generate interview questions, draft offer and rejection letters, and manage the recruiting pipeline with Gemini