Tag: automation
Claude for Excel cannot save a file, and the error will not tell you that
Ask the Claude add-in in Excel to roll a workbook forward into next month and you get a permissions error, which reads like a misconfiguration and is not one. The add-in has no file management at all, and that limit is missing from the unsupported list. Here is what it does do well, why it beat Claude Code on the same spreadsheet, and the settings field that fixes the complaint everybody has.
Claude Code loop is for the work you watch
Claude Code /loop reruns a prompt on an interval inside your session. It is perfect for babysitting a deploy or a test run, and wrong for anything that has to keep going while you are away. It also exposes a durable flag that, on version 2.1.185, quietly writes nothing to disk. Here is how to use it well.
How to schedule Claude Code on your own machine
You want a Claude job to run every few hours on your Mac, not in the cloud. A cloud routine cannot do it, because it never touches your machine. Here are the local options that can, why launchd beats cron for this, and a working LaunchAgent that pulls every one of my repos on a schedule.
How to run a long autonomous Claude Code job without it drifting
The hard part of a big AI job is not the work. It is making the agent run for many sessions without drifting or claiming it is done when it is not. I used an accessibility audit across four codebases as the test. The setup that kept Claude Code on track was a git ledger, atomic parallel claims, and two verification passes.
Revenue per employee is the only number that survives AI
Most operating metrics get noisy or gamed once AI absorbs the task work. Revenue per employee stays hard to fake. When Facebook bought WhatsApp for about 19 billion dollars, the company had 55 people. That ratio, output per head, is the acid test of whether AI bought you a real gain in output.
The consultant who fought to keep his client off AI
Some advisors resist letting a company connect AI to its own systems, dressed up as too risky. The Everlaw survey found 90% of legal professionals expect AI to change billing within two years. The real driver is an AI consultant protecting the gatekeeper role.
You probably do not need a transfer agent: how we self-manage our cap table with AI
Most early-stage startups are not legally required to use a stock transfer agent. Delaware law lets a company keep its own electronic stock ledger. Here is how we run our cap table at Tallyfy as a version-controlled JSON file, with AI doing the reconciliation and reports, plus what the law (DGCL 219, DGCL 224, Section 12(g)) really requires.
How Claude Code scheduled jobs actually work
Claude Code scheduled jobs come in three forms with very different guarantees: the in-session /loop, Desktop tasks, and Cloud routines. A missed run does not queue up a backlog. And despite a common belief, none of them creates a Windows Task Scheduler entry or a .bat file. Here is how each one actually behaves.
Reading Outlook attachments in Claude, three workarounds that work
Claude Desktop's Microsoft 365 connector reads email body but not attachments. Three workarounds exist. Two are blocked in most secure tenants by design. The path that lasts is registering your own Entra ID app with Mail.Read delegated. Here is the architecture, the failure modes, and the PowerShell that runs.
What is a hook in Claude Code and how to use them
Hooks in Claude Code are automated actions that fire on specific events during AI sessions. They range from simple bash scripts to agent-powered validators. The difference between exit code 1 and exit code 2 will save you hours of frustrated debugging.
Automating SOC 2 evidence collection with AI and browser automation
Evidence collection is the real bottleneck in SOC 2 Type 2 audits. At Tallyfy, an AI-assisted process with Playwright browser automation collected 99 evidence items across 4 sessions, using date-first naming conventions and typed evidence categories instead of expensive compliance platforms.
SOC 2 policies as code: markdown, version control, and automated PDF generation
Word documents fail at compliance. We manage 31 SOC 2 policies as markdown files in a Git repository with YAML frontmatter, automated version bumps, and WeasyPrint PDF generation. The auditors get professional PDFs. We get a sane workflow.
SOC 2 Type 1 vs Type 2 and why Type 2 is where AI automation matters
SOC 2 Type 1 proves your controls exist on paper. Type 2 proves they actually worked over months of real operation under AICPA standards. Most enterprise buyers demand Type 2, and the evidence collection grind is where AI-assisted automation delivers real returns.
The busywork of SOC 2 evidence collection and how to eliminate it
SOC 2 evidence collection is not intellectually hard. It is tedious, repetitive, and error-prone when done by hand. A Coalfire report found 60 percent of organizations still manage compliance with spreadsheets. The real cost is the organizational overhead of naming, tracking, and chasing sign-offs across 123 evidence items.
Using AI for semi-manual SOC 2 evidence collection
Fully automated SOC 2 evidence collection sounds great until you try it. Half the items need human judgment. Here is how a three-phase guided workflow at Tallyfy collected 99 evidence items across 4 sessions in 4 days, with AI handling orchestration and a human handling the judgment calls.
How to build a free website with Astro and Cloudflare Pages using Claude Code
Build a production-grade personal website with Astro and Cloudflare Pages at zero hosting cost. Claude Code handles all setup, configuration, and deployment without needing DevOps experience.
Claude Code test generation - the 80% coverage sweet spot
Your codebase sits at 40% test coverage, three people understand your critical systems, and hiring QA engineers costs more than your tooling budget. Claude Code test generation writes thorough tests that catch edge cases developers miss, and those tests double as living documentation for teams too small for dedicated QA.
Retail AI: from customer service to inventory
Everyone builds chatbots while inventory sits overstocked and schedules waste labor. Backend retail AI operations, from SAP to Kroger, deliver measurable ROI that customer-facing features cannot match. Inventory forecasting cuts stockouts sharply, scheduling trims labor costs, and loss prevention stops billions in shrinkage. The wins hide in operations, not conversations.
Agentic AI use cases that actually work
A large share of agentic AI projects face cancellation due to poor problem selection. Companies like Ciena and IBM show where autonomous agents deliver real value. Here are the specific use cases that work and when to skip agents.
AI and the end of busy work
Harvard research found AI helps workers complete tasks 25% faster and produce 12% more output. Yet only 5% of companies generate value from AI at scale. Here is why busy work persists and what changes when you actually eliminate it.
AI for real estate: beyond property valuation
Automated valuations consistently disappoint. The Zillow Zestimate carries a median error near 2% on-market and far higher off-market. With 88% of commercial real estate firms piloting AI yet only 5% achieving their program goals, the real ROI is in operations like tenant screening, predictive maintenance, and lease processing.
Custom GPTs for business - better as templates than tools
Built dozens of custom GPTs on OpenAI and learned they excel as templates but fail as complex tools. This is the actual strategy that works, where they help, what they cannot do, and how to avoid the maintenance trap most teams fall into.
Document processing without the OCR vendor tax
Stop paying six figures for OCR vendors. Vision models process documents for pennies with better accuracy and zero training. Here is how modern AI made traditional OCR obsolete.
Healthcare AI for small practices
Small medical practices gain more from AI proportionally than large hospitals do. Kaiser Permanente saved 15,791 hours with AI scribes, but per-physician impact is higher at small practices. Documentation automation, prior authorization AI, and patient communication tools upgrade small practice operations without enterprise budgets.
Intelligent process automation vs RPA: the real difference
RPA breaks with every UI change while intelligent automation adapts. RAND Corporation research shows more than 80 percent of AI projects fail. When maintenance eats a large share of total RPA costs, self-healing systems and long-term adaptability matter far more than quick implementation wins.
One prompt pattern, ten different jobs - why reusability matters more than perfection
Vanderbilt University research treats reusable prompt patterns like design patterns in software - build once, reuse everywhere. Three core patterns cover customer service, data analysis, documentation, and seven more business functions.
OpenAI Assistants API: the good, bad, and expensive
OpenAI Assistants API packs stateful conversations, code execution, and document search into one package. Built production systems with it and found the complexity rarely justifies the cost. With deprecation complete as of August 2026, here is when it was worth using and when simpler alternatives win for chatbots and automation.
Rule based to AI migration - hybrid beats replacement
Why gradual evolution using hybrid rule-AI systems succeeds where full replacement fails. An MIT study found 95% of generative AI pilots fail to deliver returns, yet most companies approaching rule based to AI migration still waste months ripping out working systems when the smart move is running both in parallel.
Designing agentic feedback loops - the craft nobody taught you
AI agents wreck environments in loops, as Solomon Hykes put it, while burning through thousands in tokens. But the real failure? Feedback systems that collect input then do nothing. Here is what actually works in production.
How to prompt engineer like a pro
Great prompts are discovered through iteration, not designed upfront. After testing hundreds of prompts across multiple models at Tallyfy, here is what actually works for professional prompt engineering.