A technology solutions company in the Philippines is seeking an individual with strong expertise in Google Apps Script to develop custom web applications that integrate with Google Workspace and external APIs like Zoho. The ideal candidate will have a solid background in web development, knowledge of front-end technologies, and the ability to automate workflows effectively. This role requires strong debugging and security practices, collaborating with stakeholders to ensure seamless application deployment and execution.
Qualifications
Strong experience with Google Apps Script, specifically using HTML Service.
Proficiency in front-end technologies (HTML, CSS, JavaScript).
Experience integrating third-party APIs like Zoho.
Ability to write complex back-end logic in Google Apps Script.
Strong debugging skills and troubleshooting knowledge.
Responsibilities
Build custom web applications using Google Apps Script.
Design responsive web app interfaces using front-end technologies.
Implement business logic, data processing, and integrations.
Work with external APIs to automate data synchronization.
Deploy web apps with proper access control and permissions.
Automate internal business workflows triggered by events.
Continuously test and refine web apps for performance.
Create and maintain clear documentation for stakeholders.
Collaborate with Engineering Managers and Data analysts.
Skills
Google Apps Script expertise
Web development skills (HTML, CSS, JavaScript)
API integration
Backend development
Debugging & testing
Responsive web design
Zoho integration
Advanced JavaScript
Security best practices
UI/UX design
Job description
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.