attach-time-tracking-i-ds-to-employee-records-for-payrolllisted
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