A railing business receives customer quote requests in their Slack sales channel, but needed a fair, automated way to assign those leads to sales representatives without manual intervention. The solution is a round-robin automation built with Zapier and Google Sheets that ensures every sales rep gets an equal share of leads in rotation — no cherry-picking, no missed leads, no manual assignment.

The automation is triggered every time a new message is posted in the Slack sales channel. Zapier picks up the message, filters it to ensure it's a genuine quote request, then queries Google Sheets to determine which sales rep is next in the rotation. The system replies directly in the Slack thread, tagging the assigned rep so they're instantly notified.

The automation consists of a clean, linear Zapier workflow with the following steps: Slack trigger (new message posted to channel) → Filter by Zapier (filter conditions to validate the message) → Storage by Zapier (increment counter value for rotation tracking) → Formatter by Zapier (calculate the correct rep index using modulo math) → Google Sheets (lookup the assigned rep from the spreadsheet row) → Slack (send a threaded channel message tagging the rep). Each step is purpose-built with no unnecessary complexity.

A Google Sheet acts as the database storing the list of sales representatives and tracking whose turn it is next in the rotation. The automation reads the sheet to determine the next assigned rep and updates the pointer after each assignment. This makes it easy for the sales manager to add or remove reps from the rotation — just edit the spreadsheet, no need to touch the automation. The sheet stores rep names, Slack user IDs for tagging, and the current rotation index.

When the quote request is posted in the sales channel, the automation replies directly in the thread — not as a new message. This keeps the channel clean and organized. The threaded reply tags the assigned sales rep, notifying them to follow up and consult with the customer. The rep can then continue the conversation right in the thread, keeping all context in one place.

The round-robin automation eliminated the manual process of assigning leads and removed any perception of unfairness in lead distribution. Sales reps now receive leads instantly via Slack notifications, reducing response time from minutes to seconds. The sales manager no longer needs to monitor the channel and manually assign — the system handles it 24/7. The Google Sheets integration also provides a clear audit trail of all assignments for performance tracking.