Zia.

Google Workspace

Google Apps Script Developer

Custom Google Workspace add-ons and automation — Sheets, Docs, and Gmail tools built with Apps Script, clasp, and CardService, wired to your APIs and published to the Workspace Marketplace or deployed privately.

What I build

What's included

Google Workspace add-on development

Editor and Workspace add-ons with a CardService UI for Sheets, Docs, and Gmail — deployed privately or to the Google Workspace Marketplace.

Google Sheets add-on developer

Custom functions, menus, sidebars, and onEdit/onOpen triggers that turn spreadsheets into dashboards, tools, and automated reporting.

Google Docs add-on developer

Document generation, templating, and find-and-replace automation built directly inside Google Docs.

Gmail & Drive automation

Auto-labeling, draft creation, and Drive file organization driven by installable triggers.

API & external integration

UrlFetchApp calls to CRMs and REST APIs, the OAuth2 library for third-party auth, and BigQuery for larger datasets.

Problems this solves

Sound familiar?

  • A Google Sheet used as a database, kept up to date by manual copy-paste.
  • A weekly report someone rebuilds by hand every Monday.
  • A team process with no Workspace-native UI, so it lives in scattered tabs.
  • An add-on you need available across a whole Google Workspace domain.
  • Scripts buried in the editor with no version control or local development.

Example use cases

What this looks like in practice

01

Automated weekly report

A time-driven trigger builds and emails a formatted report from a Sheet every Monday — no one touches it.

02

Validate & sync on edit

An onEdit trigger checks new rows and pushes valid ones to an external API via UrlFetchApp in real time.

03

Marketplace add-on

A Workspace add-on with a CardService UI for a niche Sheets workflow, published to the Marketplace with the right OAuth scopes.

04

Versioned, testable code

Moved a client's editor-only scripts into clasp with Git, so changes are reviewed and deployable.

Tech stack

The tools I use for this

Language & tooling

  • Apps Script (V8)
  • clasp
  • Git
  • TypeScript

Add-on UI

  • CardService
  • HtmlService sidebars

Triggers

  • Time-driven
  • onEdit
  • onOpen
  • Installable

Services

  • SpreadsheetApp
  • DocumentApp
  • GmailApp
  • DriveApp
  • UrlFetchApp

Publishing

  • Workspace Marketplace
  • OAuth scopes

Process

How it works

01

Map the workflow

I map the Sheets, Docs, or Gmail process, the data sources, and where the manual work actually hurts.

02

Build the add-on

Apps Script, CardService UI, and the right triggers — developed locally with clasp and Git, not just in the editor.

03

Test & deploy

Verified across accounts and OAuth scopes, then deployed privately or submitted to the Marketplace.

04

Support & iterate

Documentation, handoff, and ongoing tweaks as the workflow grows.

Apps Script often connects to other systems — I pair it with API integration services when it needs external data, and build document automation when the output is generated Docs.

FAQ

Questions, answered

What can you build with Google Apps Script?
Custom automation and add-ons across Google Workspace — Sheets, Docs, Gmail, Drive, Calendar, and Forms — from a single custom function up to a full Marketplace add-on with its own UI.
Can you publish a Google Workspace add-on to the Marketplace?
Yes. I handle Google Workspace add-on development end to end: the CardService UI, OAuth scopes, the verification and review requirements, and either domain-wide private deployment or public Marketplace publishing.
Do you build both Google Sheets and Google Docs add-ons?
Yes — as a Google Sheets add-on developer and Google Docs add-on developer I build custom functions, sidebars, document generation, and data workflows in both.
Do you use clasp and version control?
Yes. I develop Apps Script locally with clasp and Git so code is reviewable, testable, and deployable — not trapped in the online editor.
Can Apps Script connect to external APIs and CRMs?
Yes. Using UrlFetchApp and the OAuth2 library, Apps Script can call any REST API — CRMs, payment tools, databases, or internal services — with secure authentication.
Can scripts run automatically on a schedule or on edit?
Yes, via triggers: time-driven triggers for scheduled jobs, and onEdit/onOpen or installable triggers to react to changes as they happen.

Let's build it together

Email me with what you need — I'll reply with a clear plan and next steps. Prefer chat? WhatsApp works too.