Google Sheets & Apps Script Developer
Company: Acesheets Inc.
Location: Remote (Serving clients across North America & globally)
Employment Type: Full-time / Contract
Experience: 2-3 years
About Us:
ACEsheets Inc. builds customized solutions on Google Workspace. We specialize in designing and implementing systems and MVPs within Google Sheets, Apps Script, and related tools for small to medium-sized businesses across North America and around the world.
We are seeking a talented Google Sheets & Apps Script Developer to join our growing team and help deliver innovative, efficient, and scalable solutions to our clients.
Role Overview:
As a Google Sheets & Apps Script Developer, you will be responsible for building advanced spreadsheet solutions, developing automation using Google Apps Script, and integrating Google Workspace with third-party applications. This role requires strong technical expertise in Google Sheets, Apps Script, and front-end web technologies, as well as a problem-solving mindset to meet diverse client needs.
Key Responsibilities:
- Design, build, and optimize Google Sheets solutions tailored to client requirements.
- Develop and maintain Google Apps Script projects for automation, workflows, and integration.
- Create interactive dashboards and reports using charts, conditional formatting, and data visualization.
- Work with advanced formulas including VLOOKUP, INDEX/MATCH, FILTER, QUERY, SUMIFS/COUNTIFS, and ARRAYFORMULA.
- Implement Named Ranges, data validation, and other spreadsheet best practices.
- Utilize Apps Script classes such as DriveApp, SpreadsheetApp, CalendarApp, SessionApp, GmailApp, FormApp, etc.
- Implement triggers like onFormSubmit, onEdit, onOpen for automation workflows.
- Collaborate with clients to understand business needs and translate them into functional solutions.
- Ensure solutions are scalable, user-friendly, and aligned with best practices.
Required Skills & Qualifications:
- Proven experience with Google Sheets development.
- Strong knowledge of advanced spreadsheet formulas and functions.
- Proficiency in Google Apps Script for automation and integrations.
- Hands-on experience with JavaScript, HTML, and CSS.
- Experience in creating clean, structured dashboards and spreadsheets.
- Strong analytical and problem-solving skills.
- Good spoken and written English for effective client communication.
- Eagerness to learn and adapt to new technologies.
Preferred / Nice-to-Have Skills:
- Experience in building Google Apps Script-based web apps (doGet, doPost).
- API integration between Google Sheets and third-party applications such as WordPress, Shopify, CompanyCam, Jotforms, etc.
- Ability to build webhook receivers using Apps Script.
- Knowledge of AppSheet for no-code app development.
Why Join Acesheets Inc.?
- Work on innovative Google Workspace solutions with global clients.
- Opportunity to learn and grow in a fast-paced, collaborative environment.
- Flexibility to work remotely with an international team.
- Be part of a company passionate about efficiency, automation, and business transformation.
If you are passionate about Google Workspace development and enjoy solving real-world business problems with smart, automated solutions, we’d love to hear from you
Role Description:
This is a full-time on-site role for a Google Sheets & Apps Script Developer, located in Islamabad. The Developer will be responsible for designing, implementing, and maintaining Google Sheet-based applications and automations using Google Apps Script. They will work closely with other team members to ensure that solutions are effective, scalable, and meet the needs of our clients. The Developer will also be involved in troubleshooting and debugging issues, integrating with external databases, and ensuring that all code follows best practices.
Qualifications:
- Proficiency in Software Development and Programming
- Experience with Databases and Integration
- Knowledge of Cascading Style Sheets (CSS)
- Strong problem-solving and analytical skills
- Bachelor's degree in Computer Science, Software Engineering, or related field
- Excellent communication and collaboration skills
- Ability to work on-site in Islamabad