← ClaudeAtlas

add-terminated-hires-to-churn-tracking-sheetlisted

Build a Zap on Zapier that adds a row to a central Google Sheets churn tracker whenever an employment is terminated in Personio, with the employee's name, termination and hire dates as DD/MM/YYYY, department and weekly hours. Use when an HR, People Ops or payroll team runs Personio and wants offboarding and employee turnover logged for specific departments without copying data by hand.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Add terminated hires to churn tracking sheet The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/add-terminated-hires-to-churn-tracking-sheet. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** an employment is terminated in Personio (`personio`, `employment_terminated_instant`). 2. **Filter:** the run continues only when the employee's department contains one of the names in `TRACKED_DEPARTMENTS`, ignoring case. Any other department stops the run and writes nothing. 3. **Format:** the termination and hire dates become `DD/MM/YYYY` text, read from the date part only so a time zone never moves the day. 4. **Google Sheets** (`google-sheets`) adds one new row to the churn sheet: full name, termination date, hire date, department and weekly working hours. It only adds rows and never changes an existing one; week and month columns are left to the sheet's own formulas. ## Ask the user Each `REPLACE_…` value is set per person. Resolve names to IDs with the user's own connections; don't ask them to paste an ID you can look up. | Setting | What goes there | | ------------------------ | ------------------------------------------------------------------------------------------------------------------------------------- | | `REPLACE_SPREADSHEET_ID` | The central churn sheet: ask w