How to Build a Google Sheets Employee Schedule Template (Free Weekly Planner)

Paper schedules get lost. Whiteboard rosters need to be re-drawn every week. Group texts become chaos the moment someone calls out sick. For small teams — five employees or fifty — a Google Sheets employee schedule template solves all three problems: it lives in the cloud, anyone can view it, and the math does itself.

In this guide you'll build a complete weekly schedule template from scratch: a Schedule tab with color-coded roles, an Hours Summary tab with overtime detection and labor cost formulas, dropdown shift templates, and an availability tracker so you schedule people when they can actually work.

---

Section 1: The Schedule Tab

Create a new Google Sheet and rename the first tab Schedule. Set up the following columns in row 1:

| Col | Header | |---|---| | A | Employee Name | | B | Role | | C | Monday | | D | Tuesday | | E | Wednesday | | F | Thursday | | G | Friday | | H | Saturday | | I | Sunday | | J | Total Hours | | K | Notes |

Each cell in columns C–I will hold a shift value like "9–5", "12–8", or "OFF". The Total Hours column will sum the shift lengths automatically once you add the Hours Summary formulas in Section 2.

Freeze row 1. Go to View → Freeze → 1 row. This keeps your column headers visible no matter how many employees you scroll through.

Color-code by role with conditional formatting. Select column B, then Format → Conditional formatting. Add one rule per role:

• "Manager" → light blue fill
• "Part-Time" → light yellow fill
• "Full-Time" → light green fill

This makes it instantly obvious at a glance whether a shift has the right coverage mix — no counting rows required.

---

Section 2: Hours Summary Tab

Add a second tab named Hours Summary. This tab auto-calculates each employee's weekly hours, flags overtime, estimates labor cost, and tracks a running monthly total.

Set up these columns:

| Col | Header | |---|---| | A | Employee Name | | B | Weekly Hours | | C | Overtime Flag | | D | Hourly Rate | | E | Weekly Labor Cost | | F | Month-to-Date Hours |

Weekly Hours — use SUMIF to pull from the Schedule tab. If your employee names are in column A of the Schedule tab and shift hours are calculated there, reference them directly:

=SUMIF(Schedule!A:A, A2, Schedule!J:J)

Overtime Flag — flag anyone over 40 hours per week:

=IF(B2>40, "OT ⚠️", "")

Weekly Labor Cost — multiply hours by hourly rate:

=B2*D2

Enter each employee's hourly rate manually in column D. For part-time or variable-rate employees, update D as needed each week.

Month-to-Date Hours — create one Summary tab per week (Week 1, Week 2, etc.) and add a running total column that sums the Weekly Hours across all sheets for the current month:

=Week1!B2 + Week2!B2 + Week3!B2 + Week4!B2

This gives you a month-end labor cost total that's ready for payroll review without any manual addition.

---

If you're tracking labor costs week over week, you're probably also managing a broader business budget. The Personal Finance Tracker (Google Sheets) ($19) keeps income, expenses, and net worth in one spreadsheet — so labor costs fit into the full financial picture. Buy for $19 →

---

Section 3: Shift Templates With Dropdown Validation

Instead of typing shift times manually (and introducing typos), use data validation dropdowns so every cell accepts only a predefined shift value.

1. Create a hidden tab called Lists (or just put it off to the side of your Schedule tab).

2. In that tab, enter your standard shifts in a column:

   • 9–5
   • 10–6
   • 12–8
   • 6–2
   • 2–10
   • OFF

3. Back in your Schedule tab, select all the shift cells (C2:I50 or however far your employee list goes).

4. Go to Data → Data validation → Dropdown (from a range), then reference your Lists column.

Now every shift cell shows a dropdown. Schedulers click once to assign a shift — no typos, no ambiguous entries.

Copy-down pattern for repeating shifts. If an employee works the same shift every week, select their entire row, copy it, and paste it to the next week's sheet. Dropdown values paste cleanly and the Total Hours formula recalculates automatically.

---

Section 4: Availability Tracker

Scheduling someone when they're unavailable wastes everyone's time. Build a small availability reference table so you can check constraints before assigning shifts.

Add a tab called Availability. For each employee, create a mini-table:

| Day | Status | |---|---| | Monday | Available | | Tuesday | Available | | Wednesday | Prefer Not | | Thursday | Available | | Friday | Available | | Saturday | Unavailable | | Sunday | Unavailable |

Use dropdown validation for the Status column with three options: Available, Unavailable, Prefer Not.

To make this reference visible while scheduling, open the Schedule tab and the Availability tab side-by-side using View → Split. Or add a VLOOKUP in each shift cell's adjacent "Notes" column that pulls the employee's availability for that day:

=VLOOKUP(A2&C1, Availability!A:C, 3, FALSE)

This surfaces conflicts before they become no-shows.

---

Section 5: Practical Tips for a Cleaner Schedule

Freeze columns A and B. In addition to freezing row 1, freeze the first two columns so Employee Name and Role stay visible when you scroll right through the days of the week. View → Freeze → 2 columns.

Protect the Hours Summary tab. Right-click the tab → Protect sheet. Allow only the schedule manager to edit it. This prevents staff from accidentally overwriting labor cost formulas.

Share with a view-only link for employees. Go to File → Share → Share with others. Change the access to "Anyone with the link" and set permission to Viewer. Paste the link in your team chat. Employees can see their shifts from any device without needing a Google account or edit access.

Color-code the shift cells by type. Apply conditional formatting to the shift range (C2:I50): "OFF" cells → light gray, early shifts (6–2, 9–5) → light orange, evening shifts (12–8, 2–10) → light purple. The week's coverage pattern becomes readable at a glance — holes in the evening shift stand out immediately.

Add a Week Notes row at the top. In row 2, above your employee list, add a merged cell labeled "Week Notes." Use it for context: holidays, special events, expected busy periods. Whoever builds next week's schedule has the context they need without a separate message.

---

A well-built schedule template doesn't just tell your team when to work — it gives you the data to manage labor costs, spot coverage gaps early, and respect your staff's actual availability. All of that is achievable in Google Sheets without a single paid subscription.

Once your schedule is running smoothly, the next step is tying those labor costs into your broader financial plan. The Monthly Budget Planner (Google Sheets) ($19) connects payroll, expenses, and revenue into a monthly snapshot — so you're managing the business, not just the schedule.