← ClaudeAtlas

classify-job-titles-into-departments-in-google-sheetslisted

Build a Zap on Zapier that reads the job title in each new row of a Google Sheets list, asks ChatGPT which department it belongs to, and writes that department back into the same row. Use when a team keeps a sheet of job titles, such as applicants, headcount or contacts, and wants each one sorted into a department without doing it by hand.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Classify job titles into departments, and update Google Sheets The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/classify-job-titles-into-departments-in-google-sheets. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** a new row is added to the bottom of the sheet you set (`google-sheets`, `new_row_notify_hook`). 2. **Workflow** reads the job title from the title column. A row without a title is skipped. 3. **ChatGPT** is asked which department the title belongs to, from a fixed list: Executive, Engineering, Product, Design, Sales, Marketing, Customer Support, Finance, Human Resources, Operations, Legal, IT or Other. The reply is matched to that list; anything else becomes Other. 4. **Google Sheets** updates the same row and writes the department into the department column. Only new rows are classified. Editing a title later does not run the Zap again. ## 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 | Where | What goes there | | ---------------- | ------------------------------------------------------------------- | -----------------------------------------------------------------------------------------------