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.
This workflow was created by Dhruv Mali and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.