Automate HR celebrations with Google Gemini, Sheets & Chat for team milestones

by Dhruv Mali ✓ · 179 views · created 2025-12-11 · HR, Multimodal AI

What this workflow does

This AI workflow has 21 nodes and runs on a schedule (every day at 09:00) (plus 1 other trigger). Along the way it connects Google Gemini Chat Model and Google Sheets.

How it runs

Trigger: On a schedule (every day at 09:00) (plus 1 other trigger).

1. SET-BIRTHDAY (Edit Fields (Set)): sets 4 fields: Agency Name, google chat api key, google chat space id…
2. SET - ANNIVERSARY (Edit Fields (Set)): sets 4 fields: Agency Name, google chat api key, google chat space id…
3. Get dates-BDAY (Google Sheets): uses Google Sheets
4. Get dates-ANNI (Google Sheets): uses Google Sheets
5. Parse birthday (Code): runs custom JavaScript code
6. Today (Edit Fields (Set)): sets 1 field: todayIso
7. If: checks a condition and branches into true / false
8. parse ANNIVESARY (Code): runs custom JavaScript code
9. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
10. If: checks a condition and branches into true / false

…plus 7 more steps. See the full node list below.

Services it uses

Google Gemini Chat ModelGoogle Sheets

Before you upgrade to n8n 3.0

Nodes used (9)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Ifn8n-nodes-base.if
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets

From the author

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…

View the original on n8n.io → Check your own copy