This workflow automates the employee onboarding process by creating Jira accounts, generating Notion onboarding checklists, crafting AI-generated welcome messages, and sending personalized welcome emails — all automatically.
It provides a complete hands-free onboarding experience for HR and IT teams by connecting Jira, Notion, Google Sheets, Gmail, and Azure OpenAI.
Failures (like Jira account creation errors) are logged into Google Sheets to ensure full transparency and no missed onboardings.
🟢 When Clicking “Execute Workflow”
Manually triggers the entire onboarding automation. Useful for testing or initiating onboarding on demand for a new hire.
👤 Define New Hire Profile Data
Structures all essential employee information into a clean dataset including name, email, start date, buddy, and access links (Slack, GitHub, Jira, Notion).
Acts as the single source of truth for all downstream systems ensuring consistent, error-free onboarding data.
🎫 Create Jira User Account
Automatically creates a Jira account for the new employee using REST API calls.
Includes email, display name, username, and product access (Jira Software).
Removes the need for manual admin setup and ensures immediate access to project boards.
✅ Validate Jira Account Creation Success: Checks if the Jira API response contains a valid accountId.
If successful → continues onboarding.
If failed → logs error to Google Sheets.
Ensures downstream steps don’t continue if Jira setup fails.
📊 Log Jira Provisioning Failures to Error Sheet
Appends any account creation errors (duplicate emails, invalid permissions, or API issues) into an “error log sheet” in Google Sheets.
Helps HR/IT monitor issues and manually resolve them.
Guarantees no silent onboarding failures.
📋 Generate Notion Onboarding Checklist
Creates a personalized Notion page titled “{Name} - Onboarding Checklist” that includes:
Welcome message
Access links (Slack, GitHub, Jira)
Assigned buddy details
Start date and status
Optionally, embedded videos or docs
Gives each new hire a structured hub to manage onboarding tasks independently.
🤖 AI-Generated Welcome Message Creator
Uses GPT-4o (Azure OpenAI) to craft a friendly, motivational welcome message for the new employee.
Incorporates name, buddy, and access details with emojis and warm tone.
Ensures every message feels human and engaging — not robotic.
🧠 GPT-4o Language Model Configuration
Configures the AI assistant persona for personalized onboarding messages.
Ensures tone consistency, friendliness, and empathy across all communications.
🔗 Consolidate Onboarding Data Streams
Merges data from Jira, Notion, and AI message generation into a single payload.
This ensures the final email contains every onboarding element — access links, checklist URL, and the AI-generated message.
📧 Format Comprehensive Welcome Email
Jira Admin API credentials
Notion API integration
Gmail OAuth2 credentials
Azure OpenAI (GPT-4o) access
Google Sheets document for logging errors
✅ Fully automated new hire onboarding
✅ AI-generated personalized communications
✅ Real-time error logging for IT transparency
✅ Seamless integration across Jira, Notion, and Gmail
✅ Professional first-day experience with zero manual work
HR teams managing multiple onboardings
IT admins automating access provisioning
Startups scaling employee onboarding
Organizations using Jira + Notion + Gmail stack
