← ClaudeAtlas

attach-time-tracking-i-ds-to-employee-records-for-payrolllisted

Build a Zap on Zapier that adds an incoming time-tracking ID to the matching employee's linking field in Airtable, so payroll and HR can reconcile timesheets. Use when a time-tracking tool sends a list of entries (record ID, email, full name) and each one should be attached to the employee in your HR table, without overwriting existing links.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Attach time tracking IDs to employee records for payroll The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/attach-time-tracking-i-ds-to-employee-records-for-payroll. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** a list of time-tracking entries arrives at a Webhooks by Zapier catch hook (`webhook`, `hook_v2`), each with a record ID, an email and a full name. 2. **Airtable** finds the employee whose email matches. If none matches, it looks for an exact full-name match. 3. If no employee matches, that entry is skipped and nothing is written. 4. If the employee's linking field already contains the record ID, the entry is skipped. Otherwise the ID is appended to the existing links, and **Airtable** updates the employee record. The Zap never creates employees and never overwrites existing links. ## 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_AIRTABLE_BASE_ID` | The Airtable base that holds employee records | | `REPLACE_EMPLOYEE_TABLE` | The table in that base that holds em