Google Sheets · Apps Script

Recommended package: Automation — $1,500

Apps Script is the most powerful, most overlooked tool in Google Workspace. We build custom buttons, menus, and scheduled jobs that feel native — so anyone on your team can run them with one click.

Custom menus, buttons, and scripted workflows are the heart of the Automation package.

See what we build
Apps Script editor with a custom Sheets menu

What it is

What it is — in plain language.

Apps Script is Google's built-in scripting layer for Workspace — a real JavaScript runtime with direct, authenticated access to Sheets, Gmail, Drive, Calendar, Docs, and almost any external API. It runs on Google's servers, costs nothing extra on top of your existing Workspace plan, and never asks your team to leave the spreadsheet they already know.

What we ship isn't generic code. It's a small, focused system: a custom menu inside your Sheet with 3–8 buttons your team can press, a handful of scheduled triggers that run quietly overnight, and a documented handover so your team owns it forever. No new login, no new SaaS bill, no Zapier seat counts to negotiate at renewal.

Who it's for

Built for teams that already live in Sheets.

Apps Script is the right answer when your team already lives in Google Sheets and the bottleneck is the manual work surrounding it — formatting, sending, exporting, reminding, copying. It's also the right answer when off-the-shelf tools like Zapier or Make hit a wall: too many steps, too much custom logic, or per-task pricing that gets expensive fast.

  • Ops, finance, and revenue teams running on Sheets
  • Founders tired of paying per-task on Zapier
  • Agencies with bespoke client reporting flows
  • Teams blocked because IT won't approve new SaaS
01

Custom menus & one-click buttons

Every Sheet your team uses has 3–5 actions they perform constantly: regenerate the report, send the weekly emails, archive last quarter's rows, push to the CRM. We collapse those multi-step rituals into a single custom menu — branded with your terminology — that lives at the top of the Sheet next to File and Edit.

The magic isn't the code, it's the UX. The menu only shows actions the current user has permission to run. Long-running jobs show a progress toast. Destructive actions ask for confirmation. Failures surface a clear error your team can act on, not a stack trace. The result: a tool that feels less like a script and more like a button you've always wished was there.

  • Native Sheets UI
  • Permission-aware actions
  • Loom walkthrough included
02

Scheduled jobs & triggers

Most automation isn't about humans clicking buttons — it's about work that should happen on its own. We set up time-based triggers (every hour, every Monday at 6am, the first of the month) and event-based triggers (on edit, on form submit, on a specific cell change) so your data is clean before your team even logs in.

We instrument every scheduled job with three things: structured logs in a hidden Sheet tab, automatic alerts to Slack or email when something fails, and a kill-switch cell so any team member can pause the automation without editing code. That last part matters more than people realize — the difference between a 'cool script' and 'critical infrastructure' is whether non-engineers can stop it gracefully.

  • Time-based triggers
  • On-edit / on-form-submit
  • Failure alerts to Slack or email
03

Documented & handed over

The fastest way to lose trust in an automation is to not understand how it works. So every Apps Script project ships with three artifacts: heavily-commented source code that reads like prose, a one-page handover doc covering what runs, when, and how to debug it, and a 5–10 minute Loom walking through the menu, the script editor, and the most common edits.

You own the script. The code lives in your Workspace, under your account, with no dependency on Aurelle to keep it running. We're happy to be on retainer for evolutions — but the moment we ship, you can fire us and the system keeps working. That's the whole point.

  • Inline code comments
  • One-page handover doc
  • Loom walkthrough

Real example

What this looks like in practice.

Problem

A 12-person revenue team was spending ~6 hours every Monday rebuilding a pipeline report — pulling from HubSpot, reformatting in Sheets, attaching to an email, sending to leadership.

Solution

We built a single Apps Script menu with one button: 'Generate Monday report'. It pulls live HubSpot data, formats the Sheet, snapshots a PDF to Drive, and emails leadership with the link.

Result

Monday report time dropped from 6 hours to 8 seconds. The team reclaimed an entire morning per week and the report has never been late since.

What you get

Every package ships with this.

  • Custom Sheets menu with your branded actions
  • Scheduled triggers with failure alerts
  • Inline-commented Apps Script source
  • One-page handover documentation
  • 5–10 minute Loom walkthrough
  • 30 days post-launch support

Timeline & pricing

How the package works.

Most Apps Script builds ship in 1–2 weeks from kickoff. We work in short, visible cycles: scope and fixed quote on day one, working draft by mid-week, your team tests on a staging copy of the Sheet, and we promote to production once you sign off.

Pricing is fixed per project, not per hour. The Automation tier ($1,500) covers most multi-action menu builds with up to two integrations; bigger systems with several integrations or custom UIs sit in the Premium tier.

  • Week 1: scope + working draft
  • Week 2: testing + production launch
  • 30-day post-launch support included

Common questions

Questions teams ask before they hire us.

Formulas are stuck inside the spreadsheet — they recalculate when something changes, but they can't reach out to other tools, send emails, generate PDFs, or run on a schedule. Apps Script is real JavaScript with first-class access to Gmail, Drive, Calendar, Docs, Slides, and any external API. That means it can move data between Sheets and your CRM, send a templated email when a status changes, archive rows nightly, generate a branded PDF quote, or react to a form submission in seconds. If you've ever wished a formula could 'do' something instead of just calculating, that's Apps Script territory.

Ship custom in days

Book a free 30-minute call. We'll scope a custom Apps Script solution and ship it in 1–2 weeks.