PeopleOps Birthday & Anniversary Starter Bot (Google Sheets + Apps Script)

Automate company birthday & work-anniversary shoutouts — with an approval step so a human double-checks before posting.

How it works

• Scans your Employees sheet daily for birthdays & hire-date anniversaries
• Emails an approver (or each manager) with Approve / Decline links
• On approval, posts to Slack (native bot) or emails a Slack channel
• Prevents duplicates by writing the celebration year back to the sheet
• Rotates message templates for variety 🎉

What’s included

• Google Sheet template (Employees + Approvals)
• Copy-paste Apps Script (bound to the Sheet)
• Novice-friendly Setup Guide + Slack setup (Email app vs Native bot)
• Troubleshooting & FAQ
• Lightweight EULA + Privacy notice template
• Changelog / version notes

You’ll customize

• Approver routing: one central approver or each row’s ManagerEmail
• Timezone & lead days (e.g., send approvals 0–N days in advance)
• Slack bot token + channel (or use a Slack channel’s email)
• Message templates (several included; easily add your own)

Requirements

• Google account w/ Gmail enabled
• Slack workspace (Free: use native bot; Paid: optional Email app-to-channel)
• Ability to deploy a simple Apps Script Web App (step-by-step guide included)

License

• One-time purchase. Single company/organization license. You can modify the code for internal use.

Support & updates

• This is a self-serve template. No support or updates are included.
  Optional paid AI consulting (setup, customization, troubleshooting) is available—email info@aitricity.ai for a quote.