add-terminated-hires-to-churn-tracking-sheetlisted
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