AI Automation
AI automations that hold up in production: n8n workflows, automation tools, API automation, reliability, testing and monitoring.
Categories in AI Automation
Learning series
Articles in AI Automation (page 1 of 12)
- Regex Text Preprocessing and ReDoS Safety for AI Automation — Cheap deterministic preprocessing improves accuracy and cuts token cost, but one careless regex can freeze a worker on hostile input. This guide covers practical patterns, redaction limits, ReDoS causes and defences, and how to test them.
- Hiring an AI Automation Engineer: Job Description and Interview Guide — The title means different things at different companies, and keyword-matched resumes hide the real skills. This guide helps you define the role, write an honest job description, run a paid work sample and structured interviews, and onboard well.
- How to Price AI Automation Projects: A Guide for Freelancers and Agencies — Underpricing is the most common way automation builders lose money. This guide compares hourly, fixed, phased and value-informed pricing, shows how to estimate honestly, handle model usage costs and scope changes, and structure the contract.
- Google Sheets as a Database for AI Automation: Limits and How to Migrate — A spreadsheet is the perfect prototype database and a poor production one. This guide shows where Google Sheets breaks under automation, how to make it safer while you stay, the signals to move, and a staged migration plan.
- A Postgres Job Queue for AI Workflows with SKIP LOCKED — Model calls are slow, costly and rate-limited, so they belong in a queue. If you already run Postgres you may not need a broker. This guide covers the table, SKIP LOCKED claims, leases, retries, idempotency, monitoring and when to outgrow it.
- Normalizing Phone Numbers, Addresses and Names Before AI Automation — Messy contact data makes automations create duplicates, mis-greet customers and route wrongly. This guide covers safe normalisation of emails, phones, names and addresses, conservative matching, and where a language model helps or gets in the way.
- Dates, Times and Time Zones in AI Automation: Bugs and Fixes — Reports that are off by a day, reminders at the wrong hour and duplicates at daylight-saving changes all come from the same handful of mistakes. This guide shows how to store, convert, parse and test dates and time zones correctly.
- SQL for Automation Builders: Joins, Aggregates and Safe Writes — Automation builders hit databases constantly, often with just enough SQL to be dangerous. This guide covers the queries you actually need: joins, aggregates, upserts, transactions and the habits that stop a bad write from becoming an incident.
- JSON, JSONPath and jq for Automation Builders — Nearly everything an automation touches is JSON, and most silent failures are a missing key, a null or an array of the wrong length. This guide teaches the reading, reshaping and validating skills with jq and JSONPath recipes.
- Maintenance Retainers and SLA Design for AI Automation (Part 12 of 20) — Part 12 of the AI Automation Business series. Automations decay quietly. Define what maintenance includes, offer clear tiers, promise only service levels you can meet, price for risk and availability, and keep boundaries with fair-use rules.
- Monitoring Client Automations: Alerts and Incident Response (Part 13 of 20) — Part 13 of the AI Automation Business series. Watch three layers: is it running, is it right, does it pay. Design alerts that get action, keep runbooks and kill switches ready, and handle incidents calmly with clear communication.
- Testing and Client Acceptance for AI Automation Projects (Part 11 of 20) — Part 11 of the AI Automation Business series. Test at every level, evaluate AI steps on held-out data, run UAT, triage feedback into defects and changes, launch in shadow mode and close with a signed acceptance that starts the warranty.
- Documenting and Handing Over AI Automation Projects (Part 10 of 20) — Part 10 of the AI Automation Business series. Documentation is part of the deliverable. Learn the documentation set, how to document AI behaviour, write runbooks, run training and complete a handover that leaves the client in control.
- Building a Repeatable AI Automation Delivery Process (Part 9 of 20) — Part 9 of the AI Automation Business series. Stages, artefacts and checklists that make good work the default: design before build, error handling and logging by default, versioned prompts, quality gates and a reusable toolkit.
- AI Automation Contracts: Liability, IP and Data Clauses (Part 7 of 20) — Part 7 of the AI Automation Business series. What each clause is for: scope and acceptance, IP with carve-outs, data protection and sub-processors, responsibility for AI outputs, liability caps and exit. General information, not legal advice.
- Writing AI Automation Proposals and Statements of Work (Part 6 of 20) — Part 6 of the AI Automation Business series. A proposal must show you listened, explain the solution plainly, fix scope and price, reduce perceived risk and make the decision easy. Includes structure, pricing presentation and follow-up.
- Managing Client API Keys, Costs and Usage Billing (Part 14 of 20) — Part 14 of the AI Automation Business series. Client-owned accounts, one key per purpose, budget alerts and workflow caps, measured cost forecasts and honest billing options, plus rotation and offboarding so nothing lingers.
- Scoping AI Automation Projects and Preventing Scope Creep (Part 5 of 20) — Part 5 of the AI Automation Business series. What a scope contains, how to define done for probabilistic AI behaviour, how to estimate honestly, phase the work, and run change control so extra requests never quietly eat your margin.
- Process Mapping and Automation Opportunity Scoring (Part 4 of 20) — Part 4 of the AI Automation Business series. Turn a vague description into a validated process map, capture exceptions and volumes, spot waste to fix first, and score opportunities so you automate what is worth automating.
- Discovery Calls for AI Automation Projects: Questions to Ask (Part 3 of 20) — Part 3 of the AI Automation Business series. A discovery call is mostly listening. Get the agenda, the questions for problem, process, systems, data, people and budget, the red flags to watch for, and how to close with a dated next step.
- Choosing an AI Automation Niche and Ideal Client (Part 2 of 20) — Part 2 of the AI Automation Business series. A niche is who, what problem, what outcome and what mechanism. Learn to score candidates, validate demand before committing, write an ideal client profile and decide whom to decline.
- OAuth for Automation Builders: Scopes, Refresh Tokens and Why Connections Break — Workflows that worked for weeks suddenly fail with 401 errors, and the cause is usually an OAuth detail nobody explained. This guide covers flows, scopes, refresh tokens, expiry and revocation, plus how to build automations that survive them.
- API Pagination Patterns for Automation Builders: Offset, Cursor and Beyond — Most APIs return data in pages, and most automation bugs here are silent: missed rows, duplicates, or a loop that never ends. This guide covers each pagination style, safe loop design, rate limits, checkpoints and how to test.
- Starting an AI Automation Business: A Realistic First 90 Days (Part 1 of 20) — Part 1 of the AI Automation Business series. What clients actually buy, what you need before you start, a realistic 90-day plan, the numbers to track and the mistakes that stall newcomers. No income promises, just a working map.