Not everything worth automating deserves a monthly subscription. PBJ.Tech writes small, single-purpose Google Apps Script programs that connect the tools a business already uses — and run entirely inside that business’s own Google account. No middleware platform, no per-task fees, no third party holding your data.
Two real projects, explained below.
Square Dump — every Square event, logged to your own spreadsheet
Square can send a webhook for everything that happens in your account — a payment, an invoice, a booking, a customer edit, an inventory change. Square Dump is a small web service, written in Google Apps Script, that catches every one of those events and files it into a Google Sheet you own: one tab per event type, one row per event, every field in the payload flattened into its own labelled column.
The receiver grows its own schema. When Square introduces a new event type or adds a new field, the script creates the tab or appends the column on its own — no maintenance visit required. Tabs and columns get human-readable names (“Invoice Created”, “Invoice Number”) instead of raw API identifiers, and a hidden schema tab records every mapping so names stay stable over time.
The result is a complete, ordered history of the account in a spreadsheet — a foundation for bookkeeping, reporting, or downstream automation that reacts to new rows. A small companion proxy verifies Square’s cryptographic signature on every delivery and answers Square instantly, so deliveries never time out and nothing gets lost.
Google Apps Script · Square Webhooks API · runs in your own Google account
Notion Backup — your whole workspace, mirrored nightly
Notion is a great place to run a business — and a bad place to have your only copy of anything. Notion Backup is an Apps Script program that runs every night and mirrors every database in a Notion workspace into a Google Sheet: one tab per database, one row per record, every property in its own column.
Each pass rewrites the mirror in full, so the sheet is always a faithful snapshot — and every row carries the record’s identity and last-edited time, so other programs can diff today’s mirror against yesterday’s and react to exactly what changed. A status tab shows per-database row counts and when each database was last mirrored, so backup health is visible at a glance.
It discovers new databases automatically, paces itself against API limits, and splits large workspaces across multiple runs — all on standard Google infrastructure. No third-party backup service, no export ritual, nothing leaving accounts you control.
Google Apps Script · Notion API · nightly, automatic
Need something automated?
If your business runs on Square, Notion, Google Workspace, RingCentral, or anything else with an API, odds are the busywork between those tools can be scripted away. Tell us what you keep copying and pasting — we’ll tell you if it can disappear.