Three guards that keep an AI bot inside a sheet's dropdown lists, a read-only check of 2,000 live rows, and the 17 words the bot still cannot pick.
Badges
Badges come from GitHub once the author claims this feed.
Recent posts
every link opens the author’s post-
Dropdowns Are the Schema: Letting an AI Write Rows Into Google Sheets
-
claude -p in Production: Flags, Failures and Numbers From 3 Bots
A field guide to Claude Code headless mode: the five flags our bots pass, what they save per call, the JSON envelope, and four failures reproduced.
-
CLAUDE.md in Practice: 7 Lines, 35 Lines and 490 Lines, Measured
Three real CLAUDE.md files, measured: what each adds to every Claude Code call, a rule broken four times, and a file that became a diary.
-
"Send Me the Invoice" or "The Invoice Is Wrong"? A Request Detector
How our support bot spots customers asking for a document or a number, why keywords alone were wrong a quarter of the time, and the nine rules that fixed it.
-
Slack's 50-Block Limit: Paging 25 Approval Cards Into a Thread
A Slack message holds 50 Block Kit blocks.
-
Migrating Bots to a New Mac: launchd, State Files and the Wrong Mac
The checklist we used to move 17 always-on bots to a shared Mac mini as a LaunchDaemon, the timeline of the day, and the laptop we installed on by mistake.
-
Photo Matching for a Support Bot: Pick From the Order, Never Guess
How our claims bot reads customer photos: pick from the order lines or return null, screen out ID cards and screenshots, catch reused photos with a 64-bit hash.
-
Summarising Support Calls with Speech-to-Text and Claude: What Broke
Half our support chats are phone calls.
-
Polling vs Webhooks for a Chat-Support API: Why We Chose Polling
Our support bot polls the chat API every minute, not via webhooks: the reasons, the rate-limit sum, and a live probe of chats the list API never returns.
-
Writing to Google Sheets From a Bot: 5 Service-Account Walls I Hit
A bot writes to our claims sheet through a service account.
-
Haiku, Sonnet or Opus for a Production Bot? What We Switched and Why
Which Claude model each of our 17 bots runs, the one switch we made (Haiku to Sonnet after a misread call), the 136-second cost, and when Opus is worth it.
-
Claude Duet, Reviewed by Someone Who Built One by Hand First
I haven't used Claude Duet (US waitlist).
-
Why Every Bot Alert Goes to One Person's DM, Not the Channel
We tried an alerts channel.
-
What 17 Claude Code Bots Cost Per Month: US$100 (Real Numbers)
The real monthly bill for 17 Claude Code bots in a B2B company: a US$100 Claude Max plan, zero API spend, and the one hidden cost nobody lists.
-
Turning Closed Support Chats Into a Claims Log, Automatically
A Claude Code bot reads every closed support chat, extracts the complaint and writes a claims-sheet row.
-
Volatile Formulas Killed Our Google Sheet: The Audit Found 20,000
Our claims sheet had 20,320 volatile formulas and sat at 85.5% of the cell limit.
-
September 2026 Bot Report: What Ran, What Broke, What It Cost
A monthly log for 17 Claude Code bots in a real company: the US$100 bill, the hours, and four things that broke in September 2026, with what we changed.
-
An AI Bot That Watches Our Slack Channel and Diagnoses Its Own Errors
A bot that reads our bots' failures and proposes patches it may not apply, plus the morning a DNS flood and a launchd PATH trap silenced three bots.
-
Slack Approval Buttons for AI Bots: Nothing Ships Without a Click
A one-card Slack approval flow that lets a non-developer team run AI bots that send emails and statements: the Block Kit shape and three mistakes it caught.
-
onEdit Triggers That Keep Two Columns in Sync (and the Undo Bug)
Two column pairs in our claims sheet must always match.
-
Monthly Statement Emails From Slack: Dashboard → Spreadsheet → Gmail
A Slack command builds a customer's monthly statement from our dashboards and emails it after a human approves.
-
"Database Is Locked": The Night Our Support Bot Gave Up 7 Times
One uncommitted SQLite write and a Friday deploy: 304 "database is locked" errors, 7 chats abandoned.
-
launchd vs Docker for Always-On Claude Code Bots on a Mac
Seventeen bots run as one Python process under launchd on a Mac.
-
Google Sheets as a Bot Database: What Broke at 85% of the Cell Limit
Our bots wrote to one Google Sheet for a year.
-
Claude Code Scheduled Tasks: How I Replaced Cron for a Non-Dev Team
Two daily tasks and a pattern of one-time night jobs run my bot maintenance with no cron, no server, no developer.
-
20 Rules an AI Support Logger Needs That No Tutorial Mentions
A year of turning support chats into claim records produced these 20 rules.