Process HR requests and summarize them with AI
Workflow Description
An automation pipeline that receives HR request forms, extracts data from attachments, summarizes content using OpenAI, and stores organized records in Google Sheets and Drive for easy tracking and compliance.
How it works
- 1.Receive form submission from employee or applicant
- 2.Extract key data and text from uploaded documents
- 3.Summarize request content using OpenAI language model
- 4.Merge and standardize data into unified format
- 5.Save record to Google Sheets for review and auditing
- 6.Archive original files in Google Drive for documentation
Use cases
- Accelerate processing of leave and benefits requests
- Organize new candidate files and analyze resumes automatically
- Document HR reports and employee records systematically
Requirements
- Active Google Workspace account with Sheets and Drive access
- OpenAI API key with sufficient quota
- Pre-configured Google Forms for submissions
- Proper folder structure in Google Drive
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (18)
On form submission
Form Trigger
Extract from File
Extract From File
Qualifications
Information Extractor
Summarization Chain
Chain Summarization
Merge
Merge
Profile Wanted
Set
Google Sheets
Google Sheets
Structured Output Parser
Output Parser Structured
HR Expert
LLM Chain
Personal Data
Information Extractor
Upload CV
Google Drive
OpenAI
OpenAI
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note