Make.com + Slack + Google Sheet
Slack Round-Robin Assignment Bot
Project Overview
The client wanted to ensure fair task distribution within a team by automating a round-robin order assignment system in Slack.
I built a custom Slack bot that tracks user turns, handles skips, and manages availability; all powered by Make (Integromat) and Google Sheets.
Goals & Objectives
Automate order/task assignment so only one active user is responsible at a time.
Ensure fairness by always rotating to the next available team member.
Allow users to:
Say “got one” → accept the task.
Say “skip me” → pass their turn.
Mark themselves “not available” for the day.
Track how many times each member has taken an order.
Process & Implementation
This project was completed in these main steps:
1
Data Management with Google Sheets
Tools Used: Google Sheet
Created a structured Google Sheet with columns:
Name | Slack ID | Status | Last Assigned Timestamp | Assignment CountThe sheet ensures only one active user at a time.
Added tracking for how many turns each user has completed.
2
Slack Event Handling
Tools Used: Make.com, Slack
Used a Make Webhook to listen for Slack messages tagging the bot.
Triggered on specific commands:
@Bot got one@Bot skip me@Bot not available/@Bot available
3
Rotation & Logic in Make
Tools Used: Make.com, Google Sheet, Slack
Validates if the command came from the active user.
Updates the Google Sheet:
Clears current active status.
Selects the next eligible user (based on timestamp / order).
Updates their status to active.
Logs timestamp & increments assignment counter.
4
Slack Notifications
Sends a confirmation message (e.g. “Thanks @John, noted!”).
Announces the next active user in the channel.
Results
Eliminated confusion about “whose turn it is” in Slack.
Reduced missed or duplicate task handling.
Enabled easy flexibility — users can skip or mark themselves unavailable.
Added transparency by tracking how many turns each team member has taken.
Screenshots
Client Review
“Everything is working perfectly, the bot handles our workflow just as we needed. Great communication and delivery.”
Conclusion
This project shows how simple automation tools like Slack + Make + Google Sheets can create a powerful workflow that saves time, enforces fairness, and provides team visibility — all without needing a custom-built app.
Project Information
Project Title: Slack Round-Robin Assignment Bot
Category: Automation
Services: Internal Team Workflow Automation
Technologies Used: Make.com, Slack, Google Sheets
Duration: <4 Weeks
Related Projects
Apify + Make + Excel + Zapier + Email + callendly
