Workforce Plan Modeling in Sheets

Open a new Google Sheet and lay out the raw structure before asking Gemini to help with anything.

1. Create columns for role title, level, current headcount, current budget, and target quarter
2. Add one row per role or role family (not per individual, so this stays at the aggregate level)
3. Fill in current-state numbers from your HRIS or finance partner's most recent export

What you should see: A clean sheet with one row per role type and current headcount and budget filled in.

Look for the Gemini or sparkle icon in the Sheets toolbar to open the conversational assistant panel.

1. Click the Gemini icon in the toolbar
2. The sidebar opens alongside your sheet

What you should see: A chat-style panel on the right side of your spreadsheet where you can type questions about your data. Troubleshooting: If you don't see a Gemini icon, your Workspace admin may not have enabled it yet for your organization. Check with your IT or Workspace admin before assuming the feature is broken.

Describe your planning goal in the sidebar and ask it to build out a quarter-by-quarter view based on your base sheet.

1. State the goal in plain language ("grow this 12-person team to 16 by the end of Q4, phased evenly")
2. Ask Gemini to add columns projecting headcount by quarter
3. Ask it to calculate a projected budget for each quarter based on the role-level bands already in your sheet

What you should see: New columns appear in your sheet (or a suggested addition you can accept) showing headcount and budget by quarter.

Select a range of cells where you want commentary, such as a "risk notes" column, and use Fill with Gemini to generate short notes per row based on the rest of that row's data.

1. Add a blank "Notes" column next to your projection
2. Select the range and choose Fill with Gemini (or the equivalent generate option in your version of Sheets)
3. Prompt it to flag rows where the growth is aggressive relative to current headcount, or where budget growth outpaces headcount growth

What you should see: Short, cell-level notes populated automatically down the column, flagging the rows worth a second look.

Use the conversational sidebar to request a visual you can drop straight into a leadership deck.

1. Ask "chart the headcount and budget trend by quarter for this plan"
2. Review the suggested chart type and accept it, or ask for a different chart type if a bar chart would read better than a line chart for your data

What you should see: A chart inserted into your sheet, ready to copy into a presentation.

Before this model goes in front of a leader, check the projected budget totals against your finance partner's actual approved numbers for the unit.

1. Pull the current approved budget figure from Finance for comparison
2. Compare it against your Q1 (current state) column in the model
3. If the numbers don't match, find out why before presenting. A mismatch here undermines the whole model's credibility

What you should see: A model where your current-state numbers tie out exactly to Finance's own figures, so the projected quarters build from a trusted baseline.