Google Apps Script Developer

I Turn Google Workspace Into
Autopilot Business Systems

Results-driven Technical Virtual Assistant and Google Workspace Developer with 30 years of progressive IT experience. Specializing in building and maintaining custom Applicant Tracking Systems entirely on Google Apps Script, connecting Gmail, Google Contacts, Google Drive, Google Calendar, and Google Sheets through Web Apps. Proven track record with a flagship project processing 3,406 applicants and 99 job postings with zero data loss over 7 years. Currently focused on workflow automation, Google Workspace development, n8n, OpenAI/ChatGPT API integration, and AI-assisted automation for small teams.

30+ Years in IT
7 Yrs Apps Script
3,400+ Records Processed

Services

Every engagement is a custom-built system — not a template. I architect solutions that grow with your business.

Custom Google Sheets Systems

Multi-sheet workbook architectures with complex formulas, dashboards, and payroll/reporting pipelines. I turn spreadsheets into full business operations.

  • Dashboard & reporting automation
  • Multi-sheet rollup pipelines
  • QUERY, IMPORTRANGE, cross-sheet logic

Apps Script Web Apps

Production-grade custom web applications built with Google Apps Script HTML Service — running fully inside Google Workspace with no external hosting required.

  • Custom UI on top of Google Sheets
  • Form submissions & data pipelines
  • Role-based access & admin panels

Workflow Automation

Scripted triggers, timed jobs, and event-driven workflows across Gmail, Calendar, Drive, and Contacts — eliminating manual repetition at every step.

  • Gmail auto-triggers & email pipelines
  • Calendar scheduling automation
  • Drive file management scripts

AI + Apps Script Integration

Connecting Google Workspace to OpenAI / ChatGPT and n8n workflows — adding intelligent classification, auto-responses, and AI-generated content directly into your Sheets and Gmail.

  • ChatGPT API inside Apps Script
  • n8n + Google Workspace bridges
  • AI-assisted email & data processing

Core Expertise

Google Apps Script Web Apps (HTML Service) n8n Workflow Automation OpenAI / ChatGPT API Integration Prompt Engineering Google Workspace (Sheets, Drive, Gmail, Calendar, Contacts) JavaScript REST APIs Webhooks SQL Database Administration Process & Workflow Optimization Excel Automation VBA Macros Systems Thinking Remote Collaboration Client Communication AI Tools AI Automation Microsoft Office Suite

ATLAS — Applicant Tracking System

A fully custom Applicant Tracking System built entirely on Google Apps Script for a Canadian executive search firm — running in production for 7 uninterrupted years.

One web app connects Gmail, Google Contacts, Google Drive, Google Calendar, and Google Sheets through a unified dashboard — replacing a raw spreadsheet workflow with a clean, scalable recruitment operations system.

Gmail Service — Automated candidate email notifications and outreach triggers
Contacts API — Automatic candidate record creation and synchronization
Drive API — Structured resume, CV, and job description storage system
Calendar Service — Interview and follow-up scheduling automation
Sheets as Database — Central data store, ATS backbone, and reporting engine
3,406 Applicants Processed
99 Job Postings Managed
7 Yrs Zero Downtime
0 Data Loss Events
app.atlasesr.com

More Automation Achievements

Google Sheets + Apps Script

ARIO Launching Operations System — Audit & Optimization

Conducted a deep audit of a 7-sheet Google Sheets system with a custom Apps Script backend for a TikTok ads business. Identified and fixed formula bugs across payroll, shift tracking, and dashboard rollup sheets, resolved hidden #REF! errors, corrected overtime calculation logic, and implemented performance improvements across the Apps Script backend.

n8n + ChatGPT API

AI-Driven Workflow Automations

Multi-channel n8n workflows powered by the ChatGPT API to classify incoming emails, auto-respond to operations leads, and route tasks — giving small teams the leverage of a much larger operation without added headcount.

Excel VBA

Excel Automation & Web Scraping

Delivered automation and VBA macro solutions for international clients on Upwork — data transformation, CSV processing, formatted report generation, and web scraping workflows that replaced hours of manual work.

SQL Server

Financial Systems & Database Administration

Architected mission-critical financial systems at a Makati investment bank — Treasury Bills, Repo Agreements, FX swaps — and administered SQL Server across dev/test/production instances for 9 years.

Work Experience

ATLAS Executive Search & Rescue

Software Programmer / Google Apps Script Developer / Technical VA
November 2018 - December 2025
  • Boosted company operations through automation.
  • Served as sole developer and maintainer of a production-grade custom Applicant Tracking System (ATS) built entirely on Google Apps Script.
  • Architected a Google Apps Script Web App using HTML Service to manage the full recruitment pipeline.
  • Replaced a raw spreadsheet workflow with a cleaner, user-friendly system for operating recruitment work at scale.
  • Integrated Google Contacts, Google Calendar, Google Drive, Gmail, and Google Sheets into one unified ATS.
  • Automated candidate record creation and synchronization through Google Contacts.
  • Enabled interview and follow-up scheduling through Google Calendar.
  • Structured storage of resumes, CVs, and job descriptions through Google Drive.
  • Automated email notifications through Gmail.
  • Used Google Sheets as the central data store, reporting backbone, and ATS database.
  • Processed 3,406 applicants and 99 job postings with zero data loss over 7 years.
  • Continuously evolved the system's features and architecture as business requirements changed.

Upwork (Self-Employed)

Freelance Excel and Automation Specialist
2014 - 2018
  • Delivered Excel automation and VBA macro solutions for international clients.
  • Built data transformation, CSV processing, formatted report generation, and web data extraction tools.
  • Developed VBA programs to automate web scraping workflows and reduce manual data collection.
  • Managed end-to-end client engagements independently, including requirements gathering, delivery, and post-project support.

CanadaNutrition.com

Freelance Web Developer
April 2010 - February 2014
  • Developed and customized an e-commerce website for CanadaNutrition.com using nopCommerce technology.
  • Worked with ASP.NET 4.0 and MS SQL Server 2008.
  • Customized the Chase Paymentech payment method, which nopCommerce did not natively support.
  • Performed maintenance on an as-needed basis.

Multinational Investment Bancorporation

Database Administrator
May 2004 - March 2010
  • Administered three SQL Server instances: Development, Testing, and Production.
  • Managed backup and restore operations, capacity planning, performance monitoring, user management, and change management.
  • Supported database administration for mission-critical financial systems.

Multinational Investment Bancorporation

Systems Software Engineer / Systems Developer
January 2001 - March 2010
  • Specialized in developing in-house applications.
  • Led the Developer Group by managing programmer schedules, monitoring deliverables, and helping ensure timely project delivery.
  • Mediated between programmers and systems analysts on system specifications and database design before development.
  • Built mission-critical financial systems using Visual Basic 6.0 / VB.NET and SQL Server.
  • Built or contributed to systems for Treasury Bills, Fixed Rate Treasury Notes, Repo Agreements, Interbank Loans, forward and swap transactions, non-life insurance products, and biometric time and attendance.
  • Career was featured in the Microsoft Philippines Planner 2007.

Multinational Investment Bancorporation

IT Assistant / Junior Programmer
June 1996 - December 2000
  • Administered Windows NT and Microsoft Exchange 5.5.
  • Supported network administration and structured cabling maintenance.
  • Provided help desk support for user software and hardware inquiries.
  • Developed customized applications using MS Access, Excel, and Outlook.
  • Built electronic Leave, Overtime, and Official Business forms with automatic SQL Server database updates.
  • Led migration of 100 users from Lotus Notes to Microsoft Exchange with full data accuracy.
  • Conducted train-the-trainer sessions.

Multinational Investment Bancorporation

Data Encoder
December 1994 - May 1996
  • Converted handwritten data to electronic form using Microsoft Word, Excel, and PowerPoint.