classify-job-titles-into-departments-in-google-sheetslisted
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 |
| ---------------- | ------------------------------------------------------------------- | -----------------------------------------------------------------------------------------------