← ClaudeAtlas

add-processed-employee-leave-records-to-master-spreadsheetlisted

Build a Zap on Zapier that adds each processed employee leave record posted to a webhook as a new row in the HR master spreadsheet. Use when an HR system or form posts processed leave records to a webhook and payroll or HR coordinators keep an audit-ready list of leave in a Microsoft Excel workbook on OneDrive.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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