• Google Apps Script Expertise: Strong experience with Google Apps Script (GAS), specifically using the HTML Service to create web apps, working with Google Sheets, Google Drive, Gmail, Google Calendar, and other Google Workspace apps.
• Web Development Skills: Proficiency in front-end web technologies like HTML, CSS, and JavaScript to build interactive, user-friendly interfaces within Google Apps Script web apps.
• API Integration: Experience integrating third-party APIs (such as Zoho) with Google Apps Script to fetch, process, and store data.
• Backend Development: Ability to write complex back-end logic in Google Apps Script to automate processes, handle business logic, and interface with external databases or services.
• Debugging & Testing: Strong debugging skills, including knowledge of logging, error handling, and troubleshooting in Apps Script.
• Responsive Web Design: Experience with designing responsive web apps that work well across different screen sizes and devices.
• Preferred Skills:
• Zoho Integration: Experience working with Zoho’s API (CRM, Zoho Creator, Zoho Qntrl, etc.) to integrate Zoho data and services into Google Apps Script applications.
• Advanced JavaScript: Experience with modern JavaScript frameworks and advanced JavaScript concepts for creating dynamic, client-side interactions in web apps.
• Security Best Practices: Understanding of secure coding practices and ensuring that web apps meet security requirements, including user authentication and data protection.
• UI/UX Design: Basic experience with creating clean, intuitive user interfaces and working with UI/UX designers.

Descriptions

• Develop Google Apps Script Web Apps: Build custom, user-friendly web applications using Google Apps Script that integrate with Google Workspace (Google Sheets, Gmail, Google Calendar, Google Drive) and external platforms like Zoho.
• Web Application Front-End Development: Design and implement responsive, interactive web app interfaces using HTML, CSS, and JavaScript in combination with Google Apps Script’s UI services (HTML Service).
• Back-End Logic and Integrations: Implement business logic, data processing, and integration with Google services (like creating calendar events, managing data in Sheets, sending emails via Gmail, etc.) using Google Apps Script.
• Custom API Integrations: Work with external APIs, including Zoho, to pull or push data, automating data synchronization between Google Workspace apps and third-party services.
• Deploy Web Apps: Configure and deploy web apps with proper access control and permissions. Use Google Apps Script's web app deployment features to ensure the apps are easily accessible for end-users.
• Automation & Workflow Design: Use Google Apps Script to automate internal business workflows, such as data collection, reporting, and email notifications, triggered by events in Google Workspace or Zoho.
• Testing and Debugging: Continuously test, debug, and refine the web apps to ensure they function correctly and efficiently. Handle issues related to data integrity, API response times, and user interface glitches.
• Maintain Documentation: Create and maintain clear documentation for both technical and non-technical stakeholders, outlining how to use the web apps and integrate them into existing business processes.
• Collaboration: Work with Engineering Managers and Data analysts to define new features, refine app requirements, and implement user-friendly solutions.