{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/6ed6f1a1c5194751a94bf3cb74bdaa1c\" frameborder=\"0\" width=\"2560\" height=\"1920\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1920,"width":2560,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1920,"thumbnail_width":2560,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/6ed6f1a1c5194751a94bf3cb74bdaa1c-7d9e13851306fc4a.gif","duration":208.768,"title":"Automating HR Workflow With Google Apps Script","description":"This Loom explains Arjun’s HR Lifecycle and Workflow Automation system, which automates HR and operations from candidate application through probation and beyond. He initially built it with Google Forms, Google Sheets, and Google Apps Script to validate workflow logic, including domain-based assignments, referral validation, and tracking submissions in Drive and Sheets. He describes debugging challenges such as maintaining consistency between the form and sheet structure when column indices change, and handling optional referral logic for interns without references. He is expanding the system into web-based applications using Django and Postgres, learning mainly through implementation with AI tools while emphasizing that human understanding of workflow priorities is still necessary."}