We are seeking a skilled MIS Executive / Google Apps Script Developer to design, develop, and maintain automation solutions within Google Workspace. The ideal candidate will be responsible for streamlining business processes, building custom interfaces, integrating third-party APIs, and enhancing productivity across teams using advanced scripting and automation. Key Responsibilities: Automation & Scripting: Develop and maintain scalable solutions using Google Apps Script to automate workflows across Google Sheets, Forms, Docs, Gmail, and Drive. Design time-based, event-driven, and trigger-based scripts to optimize operational processes. Build reliable error handling, logging, and alerting mechanisms for script execution. UI/UX Development: Create custom web applications, dashboards, and user interfaces using HTML, CSS, and JavaScript within the Apps Script ecosystem. Design and implement custom forms, sidebars, modals, and interactive menus to improve user experience. API Integration: Integrate third-party APIs and external services (e.g., CRMs, ERPs, messaging platforms) to enhance data flow and system connectivity. Enable data syncing, automated communications, and cross-platform reporting. Workflow & Process Automation: Translate manual processes into automated, scalable solutions. Design and deploy approval workflows, task trackers, and status dashboards. Ensure data accuracy, integrity, and consistency across automated systems and spreadsheets. Collaboration & Documentation: Work closely with business stakeholders to gather requirements, identify process gaps, and propose effective automation strategies. Maintain detailed technical documentation, version control, and system diagrams for all scripts and solutions. Performance Optimization: Continuously test, monitor, and optimize script performance for reliability and scalability. Apply modular code structures and adhere to coding best practices. Preferred Qualifications: Proficiency in JavaScript and experience with Google Apps Script. Strong understanding of Google Workspace tools (Sheets, Forms, Docs, Gmail, Drive). Experience with HTML, CSS, and front-end development. Familiarity with RESTful APIs and webhooks. Ability to work independently and manage multiple tasks/projects. Excellent problem-solving, debugging, and communication skills.
