Google Apps Script Engineer + Sheets Systems Builder

SALARY: PHP 50,000–90,000/month (~$900–$1,600 USD)
HOURS: Project-based to start, with a path to an ongoing seat


I'm hiring one person to automate and connect a multi-tab Google Sheets system that runs a live operation. The architecture is already well-built — tracking tasks, launches, shifts, payroll, and testing across a large structure.


I don't need it rebuilt. I need it automated, connected, and rolled up — surgically, without breaking what works.

If you stop at VLOOKUP, this isn't your seat. If you build scripted automation AND clean multi-sheet data systems that feed dashboards and run themselves — keep reading.

---

The work — two sides, both matter:

1) Apps Script automation (`.gs`)
- Write and maintain Apps Script across a multi-tab system
- Build **triggers** — onEdit, time-based, onChange — for live workflow automation
- Diagnose and fix broken logic (a contained payroll-calculation bug is the first real task)
- Add validation, flagging, alerting, scheduled summary emails
- Connect Sheets to **external APIs** with auth + error handling where needed

2) Advanced formulas + sheet-to-dashboard data systems
- Build **multi-sheet data connections** — worker sheets rolling up into a **master dashboard**
- Fluent with **QUERY, IMPORTRANGE, INDEX/MATCH, ARRAYFORMULA, FILTER, pivot logic** — the formula stack that moves and aggregates data cleanly across tabs
- Design **data-collection flows**: individual input sheets ? consolidated master view, live and accurate
- Build dashboard views that summarize operational data (performance, labor, output) in real time

Always: build on a copy, test, then deploy. Non-negotiable.** Document everything so it stays maintainable.

---

**Non-negotiables —**

- **Real Apps Script experience** — actual `.gs` code, not just formulas
- **Advanced formula fluency** — QUERY, IMPORTRANGE, ARRAYFORMULA, INDEX/MATCH at a systems level, not single-cell
- Can build **sheet-to-sheet and sheet-to-dashboard data pipelines** that stay accurate at scale
- Can read an existing system and **extend it without breaking it** — surgical, not destructive
- Clean, documented, maintainable work
- Sharp communication, reliable availability, stable setup

**You stand out if —**

- You use **clasp** for local Apps Script development
- You've done **Apps Script + external API** integration (REST, OAuth)
- You've built **master-dashboard rollups** from multiple input sheets
- You've automated **real operational systems** — payroll, tracking, reporting — not toy demos

---

**How to apply (follow exactly — skip a step and you're deleted) —**

The instructions are the first test. I read every application that follows them. I ignore every one that doesn't.

1. Put **SCRIPT** at the very top, so I know you read this in full.
2. Share **2–3 projects you personally built** — must show **both** real `.gs` work **and** a multi-sheet/dashboard data system. Link code (GitHub/Gist), a Loom walkthrough, or a working sheet copy.
3. In 2–3 sentences: **describe one thing you automated with Apps Script that a formula couldn't do** — name the trigger and the logic.
4. In 2–3 sentences: **describe a time you connected multiple sheets into one master dashboard** — what formulas/method you used and how you kept the data accurate.
5. In one line: **how do you test before touching a live system?**

Nail this and you move to a paid test task — a small, real automation or data-connection job on a copy of my sheet. Nail that and we scope the full build.

I'm hiring one person. Show me you can both script and build clean data systems.