SheetHRIS – Automated HR system in Google Sheets for Growing Teams
What’s included
What’s included
What’s included
- The full SheetHRIS Google Sheet template
- Step-by-step video tutorials for setup and adding your own data
- A no-nonsense Quick Start Guide
- Smart automations and built-in forms with instructions how to authorise these
Who it’s for
What’s included
What’s included
- Startups who aren’t ready for a full-blown HR system, but still need to manage employee data properly
- Founders and ops leads setting up HR from scratch
- People folks who want a system that works without a subscription
- Teams who care about accuracy, visibility and simplicity
Currency and localisation
Currency and localisation
Currency and localisation
SheetHRIS is currently set up for UK-based teams, with salaries in GBP and UK-style terminology. It supports one currency at the moment and isn’t designed for multi-currency setups. This is on the roadmap, or I can custom build it by arrangement.
If you're based elsewhere, you might be able to adjust the currency formatting and terms yourself, but those changes aren’t currently included in the instructions.
About the scripts
Currency and localisation
Currency and localisation
SheetHRIS uses built-in Google Apps Scripts to power features like forms and scheduled updates.
When you first set it up, Google will prompt you to authorise the scripts. This is expected and required for the automations to work. The scripts only run within your copy of the sheet and don’t access or share any external data.
You’ll get clear written and video instructions to guide you through the authorisation step. It takes just a few clicks.
Watch the 3-part demo walkthrough
Part 1: Core HR made easy
✔ Employee Directory
- Keep all employee data in one place, easy to filter and sort
- Designed for clarity, not clutter
✔ Compliance tracker
- Monitor contracts, right to work checks, visa statuses and more
- See at a glance what’s complete and what needs chasing
✔ Update Employee info (without losing history)
- Log role, manager, or salary changes with effective dates
- Past data is never lost - updates to key fields are tracked and easy to review later.
Part 2: People moves, handled smoothly
✔ Add New Joiners
- Simple form-based input that feeds directly into the system
- Reduces manual copy-paste and keeps everything clean
✔ Manage leave
- Place people on leave, e.g parental, sabbatical, etc.
- Automatically reactivates them or archives based on your input
✔ Terminate employees
- Tracks final working day and employment end date (e.g. Garden leave)
- Keeps leaver data in your system for reporting and handover
Stay on top of what’s happening
✔ Audit log of key changes
- Tracks what changed, when, and who submitted it
- Keeps a history of fields like salary, title, manager and level
✔ Upcoming changes view
- Schedule future updates to salary, manager, or department
- Changes apply automatically when the time comes
✔ Lightweight dashboard
- Quick overview of headcount, joiners/leavers, and key dates
- Compliance and GDPR overview
Need help getting started?
If you’d like support tailoring the template to your team, drop a note and we’ll talk through next steps and what that could look like.
This website uses cookies.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.