For HR teams and people managers
Turn your HR spreadsheet into a staff directory everyone can actually use.
Your employee data already lives in Google Sheets. FlexTable publishes it on your website or intranet as a searchable staff directory, a performance leaderboard and private employee records, and keeps every table in sync when the Sheet changes.
| Employee | Department | Location | Q3 score | Status |
|---|---|---|---|---|
| ACAva Chen | Design | Austin | 96 | Top performer |
| LPLeo Park | Sales | Remote | 93 | Top performer |
| MRMia Ross | Engineering | Berlin | 88 | On track |
| SDSam Diaz | Support | Lisbon | 84 | On track |
| NPNora Patel | Marketing | London | 79 | On track |
Sound familiar?
HR data is easy to keep. It's hard to share.
Every time someone joins or leaves, I update the team page by hand. It's always a little out of date.
Our performance numbers live in a spreadsheet nobody outside HR ever sees.
I can't publish salaries or leave balances where every employee can open them.
How it works
From employee Sheet to live directory in three steps
No HR software rollout, no developer. Keep working in the Sheet your team already uses.
Keep your people data in Google Sheets
One row per employee: name, role, department, location, email, photo URL and any scores or KPIs you track.
Connect the Sheet in FlexTable
Paste the Sheet URL, pick a theme, hide private columns and choose who sees what.
Publish it on your site or intranet
Embed with a block, Elementor widget or shortcode. New hires, exits and score updates appear as soon as the Sheet changes.
A staff directory people can actually search
Turn a long employee list into a directory that's quick to scan on any device. Visitors search by name, filter by department or location, and see photos and contact links pulled straight from the Sheet.
- Search, sorting and pagination on the free plan
- Department and location filters (single, multi-select or text)
- Employee photos and mailto links from the Sheet
- Hide columns on mobile so it stays readable
| Name | Role | Department | |
|---|---|---|---|
| ACAva Chen | Product Designer | Design | ava@company.com |
| LPLeo Park | Account Executive | Sales | leo@company.com |
| MRMia Ross | Backend Engineer | Engineering | mia@company.com |
| SDSam Diaz | Support Lead | Support | sam@company.com |
Each employee sees only their own record
Publish one table, and FlexTable shows every logged-in employee only the rows that match their account. It's ideal for payslips, leave balances, attendance and appraisals. Visitors who aren't logged in get a login prompt or nothing at all.
- Match rows by username, email address or employee name
- The search box is removed, so nobody can browse other records
- Custom login prompt with your own button and URL
- Several matching rows? All of them are shown
| Month | Days taken | Leave left | Payslip |
|---|---|---|---|
| September | 2 | 14 | View |
| October | 1 | 13 | View |
| November | 0 | 13 | View |
Ask the table who's leading this quarter
Add an AI summary above your performance table and an Ask AI box below it. Managers get the headline in a sentence and can ask follow-up questions in plain language.
- Instant summary, saved or generated on click
- Visitors ask questions like averages, top values and filters
- Uses your own OpenAI or Google Gemini API key
Average Q3 score is 86, up 4 points on Q2. Design and Sales lead the board; two Support team members improved by more than 10 points.
Runs on your own OpenAI or Google Gemini API key.
Features that matter here
Everything an HR table needs
Always current
Edit the Sheet and the directory updates. No re-uploads when people join, move or leave.
Hide sensitive columns Pro
Keep internal fields like salary or notes out of the published table, or hide them on specific devices.
Protected and private views Pro
Use User-Specific Display or Protected View for data that shouldn't be public.
One tab per team or quarter Pro
Show several Sheet tabs as one tabbed table: Q1, Q2, Q3 or one tab per office.
Export for reviews Pro
Let managers export to CSV, Excel or PDF, or print the table for review meetings.
Works on every device
Responsive layouts (collapsible or scrollable) keep wide HR tables readable on phones.
Also used for
FlexTable Pro: MCP server
Or just ask your AI assistant to build it.
Connect Claude, ChatGPT (Codex), Cursor or VS Code to FlexTable through its MCP server. Describe the table you need, and your assistant syncs the Google Sheet, styles the table, manages its columns and publishes the page for you.
Illustrative example of a FlexTable MCP session.
FAQ
Frequently asked questions
More ways teams use FlexTable
Give your team a directory that keeps itself up to date.
Connect your employee Sheet and publish a searchable directory in minutes. Free to start.