← ClaudeAtlas

assign-expert-requests-to-next-specialist-in-rotationlisted

Build a Zap on Zapier that routes each new expert request email to the next specialist in a rotation table, labels the message, replies to the thread with the specialist's address, and advances the rotation. Use when a team takes requests by email and wants them handed out in turn, with each handoff logged in a Zapier Table.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Assign expert requests to next specialist in rotation The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/assign-expert-requests-to-next-specialist-in-rotation. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** a new Gmail message matching the search `subject:"expert request" in:inbox` arrives (`gmail`, `search`). 2. **Filter (in code):** skips replies (subject starts with `Re:`), automated or billing notices (sender or subject contains `noreply`, `billing`, `invoice` or `receipt`), and messages already routed (body contains the hidden marker). 3. **Zapier Tables** finds the record marked Next in the rotation table. 4. **Gmail** adds that record's label to the message. 5. **Gmail** replies in the same thread, addressed to the record's email, with the original message text and a hidden marker so the same request is not routed twice. 6. **Zapier Tables** updates the assignee: Next is cleared and the assigned count goes up by one. It then finds the record with the next rotation order (or the first one, when the assignee is last) and sets it to Next. If no record is marked Next, the reply goes to the fallback address and the table is left alone. The rotation advances only after the reply is sent. ## 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