← ClaudeAtlas

add-new-hire-rows-to-onboarding-spreadsheetlisted

Build a Zap on Zapier that adds a row to a Google Sheets onboarding tracker every time a candidate is marked hired in Ashby, with the start date, job title, new hire's name and email, and hiring manager. Use when a People Ops, HR or recruiting team runs Ashby as its ATS and wants every hire handed off to onboarding, payroll and facilities in one consistent sheet without retyping.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Add new hire rows to onboarding spreadsheet The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/add-new-hire-rows-to-onboarding-spreadsheet. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** a candidate is marked hired in Ashby (`ashby`, `candidate_hired`). The event carries the application (candidate, job, hiring team) and the most recent accepted offer. 2. The workflow picks the hiring manager: the hiring team member with the `Hiring Manager` role, or the first team member if nobody has that role. 3. **Google Sheets** adds one row to the onboarding worksheet with the offer's start date, the job title, the new hire's name and primary email, and the manager's name and email. Every hire gets a new row. The Zap only writes to the sheet. It does not change anything in Ashby. ## 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 | | ---------------- | ------------------------------------------------------------------------------------------------------------------ | | `SPREADSHEET_ID` | The onboarding tracker sheet. Ask which sheet it is, then look up its ID with the user's Google Sheets connection. | Also review the defaults with them: - `WORKSHEET_ID`: the tab, w