Employee Recognition Slack Bot

Employee Recognition Automation Agent Setup Guide

What This Agent Does

This powerful automation agent transforms your employee recognition process by automatically detecting new recognition entries, crafting personalized congratulatory messages, and delivering them across multiple channels—all without manual intervention. The workflow monitors a Google Sheet for new employee recognitions, generates thoughtful AI-powered messages, posts celebrations to Slack, sends personalized thank-you emails, and keeps your HR team informed every step of the way.

Key benefits include:

• Saves 5-10 hours weekly by eliminating manual message writing and multi-channel posting
• Ensures consistency with AI-generated messages that maintain your company's tone and values
• Increases recognition velocity by delivering messages within minutes of submission
• Reduces human error through automated data validation and status tracking
• Creates a culture of celebration by making recognition visible and timely across your organization

Ideal for: HR departments, people operations teams, and organizations with 50+ employees who want to strengthen company culture through consistent, timely recognition.

Who Is It For

This workflow is designed for:

• HR Managers and Coordinators who spend significant time processing recognition submissions and crafting congratulatory messages
• People Operations Teams managing employee engagement and culture initiatives
• Mid to Large Organizations (50+ employees) with active recognition programs
• Companies using Google Workspace for data management and Slack for team communication
• Any organization wanting to automate repetitive recognition tasks while maintaining a personal touch

Required Integrations

Google Sheets

Why it's needed: Google Sheets serves as your recognition database, storing all employee recognition submissions and tracking their processing status. This integration allows the workflow to read new entries and update their status as they're processed.

Setup steps:

1. Create a Google Sheet with the following columns:

   • Column A: Employee Name
   • Column B: Employee Email
   • Column C: Recognition Reason/Details
   • Column D: Submitted By (recognizer name)
   • Column E: Date Submitted
   • Column F: Processing Status (leave blank initially)

2. Share the sheet with your TaskAGI service account:

   • Go to your TaskAGI workspace settings
   • Navigate to Integrations → Google Sheets
   • Copy the service account email provided

3. Grant permissions in your Google Sheet:

   • Click Share in the top-right corner
   • Paste the service account email
   • Select Editor permissions
   • Uncheck "Notify people" and click Share

4. Copy your sheet URL from the browser address bar (format: https://docs.google.com/spreadsheets/d/SHEET_ID/edit)

5. In TaskAGI, configure the Google Sheets integration:

   • Go to Integrations → Google Sheets
   • Click Connect and authorize with your Google account
   • Paste your sheet URL in the configuration

OpenAI

Why it's needed: OpenAI's GPT-4o-mini model generates personalized, warm recognition messages that feel authentic and tailored to each employee's achievement.

Setup steps:

1. Create an OpenAI account at https://platform.openai.com if you don't have one

2. Navigate to API Keys:

   • Go to Account → API Keys (or https://platform.openai.com/api/keys)
   • Click Create new secret key
   • Copy the key immediately (you won't see it again)

3. Set up billing:

   • Go to Billing → Overview
   • Add a payment method
   • Set usage limits under Billing → Usage Limits (recommended: $10-20/month for this workflow)

4. In TaskAGI, configure OpenAI:

   • Go to Integrations → OpenAI
   • Click Connect
   • Paste your API key
   • Select gpt-4o-mini as your model (cost-effective and fast)

Slack

Why it's needed: Slack provides real-time visibility into recognitions, celebrating achievements with your team and keeping HR informed of completion status.

Setup steps:

1. Create a Slack workspace (if you don't have one) or use your existing workspace

2. Create dedicated channels:

   • #employee-recognitions (for posting celebrations)
   • #hr-notifications (for HR team alerts)

3. Obtain your Slack Bot Token:

   • Go to https://api.slack.com/apps
   • Click Create New App → From scratch
   • Name it "TaskAGI Recognition Bot"
   • Select your workspace
   • Go to OAuth & Permissions in the left sidebar
   • Under Scopes, add: chat:write, chat:write.public
   • Scroll to OAuth Tokens for Your Workspace
   • Click Install to Workspace
   • Copy the Bot User OAuth Token (starts with xoxb-)

4. In TaskAGI, configure Slack:

   • Go to Integrations → Slack
   • Click Connect
   • Paste your Bot User OAuth Token
   • Select your workspace

Gmail

Why it's needed: Gmail delivers personalized thank-you emails directly to recognized employees, creating a lasting record of their achievement and making recognition feel more personal.

Setup steps:

1. Use your organizational Gmail account (recommended) or create a dedicated recognition email account

2. Enable 2-Step Verification (required for app passwords):

   • Go to https://myaccount.google.com/security
   • Click 2-Step Verification
   • Follow the setup process

3. Generate an App Password:

   • Go to https://myaccount.google.com/apppasswords
   • Select Mail and Windows Computer (or your device)
   • Google will generate a 16-character password
   • Copy this password

4. In TaskAGI, configure Gmail:

   • Go to Integrations → Gmail
   • Click Connect
   • Enter your Gmail address
   • Paste the 16-character app password
   • Click Verify

Configuration Steps

Step 1: Configure the Schedule Trigger

The workflow checks for new recognitions at regular intervals.

1. Open the "Check for New Recognitions" node
2. Set the interval:
   • Select Every 1 hour (or adjust based on your recognition volume)
   • This ensures timely processing without excessive API calls
3. Save and continue

Step 2: Configure Google Sheets Data Retrieval

1. Open the "Get Recognition Entries" node
2. Paste your sheet URL in the sheet_url field
3. Specify the range: A2:F100 (starts from row 2 to skip headers, covers up to 100 entries)
4. Test the connection by clicking Test Node
5. Expected output: A list of recognition entries with employee names, emails, and reasons

Step 3: Configure Employee Data Processing

1. Open the "Process Employee Data" node
2. This node extracts and formats data from the sheet
3. Verify the output mapping:
   • name → Column A
   • email → Column B
   • reason → Column C
   • submitted_by → Column D
4. No configuration needed if using the standard sheet structure above

Step 4: Configure the New Entry Check

1. Open the "Check for New Entry" node
2. Set the condition: Processing Status is empty or null
3. This ensures only unprocessed recognitions are handled
4. True path → continues to message generation
5. False path → skips to "No New Entries" (no-op)

Step 5: Configure AI Message Generation

1. Open the "Generate Personalized Message" node
2. Review the prompt template:

   Write a short, friendly recognition message for [Employee Name] 
   who was recognized for: [Recognition Reason]. 
   Keep it to 2-3 sentences, warm and genuine.
   

3. Customize the prompt if desired (e.g., add company values, tone guidelines)
4. Model: Confirm gpt-4o-mini is selected
5. Temperature: Set to 0.7 for balanced creativity and consistency

Step 6: Configure Slack Celebration Post

1. Open the "Post to Slack Channel" node
2. Select channel: #employee-recognitions
3. Configure the message format:

   🎉 Congratulations [Employee Name]! 🎉
   
   [AI-Generated Message]
   
   Recognized by: [Submitted By]
   

4. Enable thread replies to keep conversations organized

Step 7: Configure Sheet Status Update

1. Open the "Update Sheet Status" node
2. Set the cell reference: Column F (Processing Status)
3. Set the value: Processed - [Timestamp]
4. This marks the entry as handled and prevents duplicate processing

Step 8: Configure Thank You Email

1. Open the "Send Thank You Email" node
2. Recipient: [[nodes.6.email]] (automatically populated from sheet)
3. Subject: Thank you for your amazing work, [Employee Name]!
4. Body template:

   Hi [Employee Name],
   
   Congratulations on being recognized for your outstanding contributions!
   
   [AI-Generated Message]
   
   Your hard work and dedication don't go unnoticed. Keep up the excellent work!
   
   Best regards,
   [Your Company] HR Team
   

5. From address: Your Gmail account configured in integrations

Step 9: Configure HR Notification

1. Open the "Notify HR of Completion" node
2. Select channel: #hr-notifications
3. Message format:

   ✅ Recognition processed for [Employee Name]
   Email sent: [Timestamp]
   

Step 10: Configure Email Success Check

1. Open the "Check Email Success" node
2. Condition: Email delivery status is "success"
3. True path → Updates email status in sheet
4. False path → Alerts HR of failure

Step 11: Configure Failure Alerts

1. Open the "Alert HR of Email Failure" node
2. Select channel: #hr-notifications
3. Message: Include employee name and error details for manual follow-up

Testing Your Agent

Pre-Launch Testing

Step 1: Verify All Integrations

1. Go to Integrations dashboard
2. Confirm all four integrations show Connected status
3. Click Test on each integration to verify credentials

Step 2: Create Test Data

1. Add a test entry to your Google Sheet:
   • Name: "Test Employee"
   • Email: Your personal email
   • Reason: "Testing the recognition workflow"
   • Submitted By: "Workflow Tester"
   • Status: Leave blank

Step 3: Run a Test Execution

1. Open your workflow in TaskAGI
2. Click Test Run (or Run Now if available)
3. Monitor the execution in real-time

Step 4: Verify Each Step

Step 5: Verify Success Indicators

• ✅ Slack message posted with celebration
• ✅ Thank-you email received with personalized message
• ✅ Sheet status updated to "Processed"
• ✅ HR notification sent
• ✅ No error messages in execution log

Troubleshooting Common Issues

Issue: "Sheet URL not found"

• Verify the sheet is shared with the TaskAGI service account
• Confirm the URL is correct and accessible

Issue: "Email not sending"

• Check Gmail app password is correct (16 characters)
• Verify 2-Step Verification is enabled
• Confirm sender email matches configured Gmail account

Issue: "Slack message not posting"

• Verify bot has access to the specified channels
• Check channel names are correct (use #channel-name format)
• Confirm OAuth token hasn't expired

Issue: "AI message generation fails"

• Check OpenAI API key is valid
• Verify billing is set up and account has credits
• Confirm model is set to gpt-4o-mini

Congratulations! Your Employee Recognition Agent is now live and ready to celebrate your team's achievements automatically. Monitor the first few executions to ensure everything runs smoothly, then sit back and watch your recognition culture flourish.