add-processed-employee-leave-records-to-master-spreadsheetlisted
Install: claude install-skill zapier/awesome-zaps
# Add processed employee leave records to master spreadsheet
The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/add-processed-employee-leave-records-to-master-spreadsheet. Read the files there if this skill was installed on its own.
## What it does
1. **Trigger:** a processed leave record arrives at a Webhooks by Zapier catch hook (`webhook`, `hook_v2`). An HR system or form posts to it.
2. **Plain code** trims and collapses whitespace in the text fields and turns `YYYY-MM-DD` dates into `DD/MM/YYYY`. Other date formats pass through unchanged.
3. **Microsoft Excel** appends one row to the end of the configured worksheet in the HR workbook.
The Zap only appends rows. It never updates earlier rows and does not check for duplicates.
## 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 |
| -------------- | ----------------------------------------------------------------------------- |
| `WORKBOOK_ID` | The Microsoft Excel workbook that is the master sheet, on the user's OneDrive |
| `WORKSHEET_ID` | The worksheet (tab) inside that workbook that holds the master sheet's rows |
Also review the defaults with them:
- `FOLDER_ID`: the OneDrive folder holding the workbook. `"root"` is the top of the drive.
- `STORAGE_SOURCE`: `"one_drive"`, or `"sh