Automation
Automating the boring half of marketing and operations: crawlers, pipelines, bots and scheduled jobs, with the code and the commands to check them yourself.
- Google Sheets Email Open Tracking: What Works After Apple MPP Tracking pixels count opens in Sheets, but Apple Mail Privacy Protection blocks them. What pixels can and cannot tell you, and a tested click-logging script.
- Gmail Sending Limits for Mail Merge: 500, 100 or 1,500? Gmail allows 500 emails a day, but a Sheets mail merge through Apps Script gets 100 on a personal account and 1,500 on Workspace. Here is…
- Turn a Google Sheet Into a Website: 3 Routes and Their Limits Three ways to publish a Google Sheet as a website: a published sheet, an Apps Script web app, or a static generator. Limits for each, and…
- Track YouTube Views Daily in Google Sheets With Apps Script An Apps Script that logs YouTube view counts to a sheet every day with videos.list, what it costs in quota units, and why the Data API…
- YouTube Analytics API vs Data API: Which to Use for Sheets The Data API reads public video stats with a key. The Analytics API reads your channel reports with OAuth. Quotas, scopes, and a tested Sheets script.
- Export YouTube Comments to Google Sheets With Apps Script Each commentThreads.list call returns up to 100 comment threads for 1 quota unit. Here is the Apps Script loop, the disabled-comments error and the cost.
- Claude Code Hooks Explained: A Real 35-Hook Setup, Tested Claude Code hooks run at fixed lifecycle events and can block actions. How events, matchers and exit codes work, plus my real 35 hooks and a…
- Send the Same Email to Multiple Recipients Separately in Gmail Bcc sends one message. To send the same email to each person separately you need mail merge or a script. Daily limits for each route, and…
- YouTube Data API Quota: 10,000 Units and 100 Searches a Day The default is 10,000 units a day, and search.list has its own bucket of 100 calls. Here is what each call costs and how a Sheets…
- What Is an MCP Server? I Ran One and Logged Every Message An MCP server gives an AI app tools, data and prompts over JSON-RPC. I ran a real one over stdio on 11 October 2026 and show…