Automate HR Celebrations with Google Gemini, Sheets & Chat for Team Milestones
Go to Workflow
Dhruv Mali
Description
Description
This workflow acts as your automated HR assistant, scanning for employee milestones and posting AI-generated celebration messages to Google Chat.
How it works
Daily Scan:** Checks your Google Sheet every morning to identify birthdays and work anniversaries.
AI Drafting:* Uses *Google Gemini** to write unique, warm messages for each employee, ensuring wishes never sound robotic or repetitive.
Delivery:* Automatically posts the message to your team's *Google Chat** space and logs the activity.
Set up steps
Connect Accounts: Set up credentials for Google Sheets and Google PaLM/Gemini.
Configure Settings: Open the SET-BIRTHDAY and SET - ANNIVERSARY nodes to enter your Agency Name and Google Chat API details (Space ID, Key, Token).
Prepare Data: Ensure your Google Sheet contains columns for employee names, dates of birth, and joining dates.