Skip to main content
Back to Blog
automation

Claude Code for Business Automation: Tips from the Trenches

Sean Matthews
10 min read

Claude Code isn't just for developers. How we use it to build internal tools, automate processes, and prototype workflows. Practical tips included.

Left Hook

Claude Code isn't just for building software products. We've been using it to build internal tools, automate business processes, generate reports, and prototype workflows. Not with a traditional development team. Not with a six-figure consulting engagement. Just a person who knows what they need, talking to an AI that can write and run code.

That probably sounds like hype. We get it. But we've been doing this for real work, on real projects, and the results have been surprisingly practical. Not perfect (we'll get to the rough edges), but practical enough that it's changed how we think about the gap between "I wish we had a tool for this" and "we actually have a tool for this."

Here's what we've learned, and how you can use the same approach even if you don't consider yourself a developer.

What Claude Code Actually Is

Quick explainer for the non-developers in the room: Claude Code is a coding assistant that runs in your terminal. It can read your files, write code, run commands, and iterate on the results. Think of it as a developer you can talk to in plain English. You describe what you want, it writes the code, you tell it what to fix, and it fixes it. No IDE required, no syntax to memorize.

What makes it different from just chatting with Claude in a browser is that it operates on your actual files. It can see your project structure, read your data, execute scripts, and test its own work. It's not generating code snippets for you to copy-paste somewhere else. It's working in your environment, on your stuff.

If you've ever thought "I need a developer for this but it's too small to justify hiring one," Claude Code is built for exactly that gap.

Use Case 1: Building Internal Tools

Every company has internal processes held together by spreadsheets and manual effort. Reports that someone compiles by hand every Friday. Onboarding checklists that live in someone's head. Data that needs to move from one system to another but nobody's built the bridge.

We built a client reporting tool in an afternoon. A script that pulls data from our API, formats it into a clean summary, and emails it to the right people. No app to deploy, no UI to maintain. Just a script and a cron job. Claude Code wrote the first draft, we tested it, told it what to change, and had a working tool before lunch. That's the kind of thing that used to be a two-week project with a developer.

Here's another one: we needed a script to pull deal data from HubSpot, cross-reference it with project hours from our tracking system, and flag accounts where the hours-to-revenue ratio was off. In the old world, that's either a custom integration project or an afternoon of spreadsheet gymnastics every month. With Claude Code, we described the data sources, the logic, and the output format. It wrote the script. We ran it. We iterated on the output format twice. Done.

The key insight isn't that Claude Code is magic. It's that a huge number of internal tools are fundamentally simple. They're scripts that read data, transform it, and put it somewhere. The barrier was never the complexity of the logic. It was the cost of getting a developer to write it. When that cost drops to an afternoon of your own time, the calculus changes completely.

Use Case 2: Data Cleanup and Migration

If you've ever moved from one CRM to another, or inherited a database full of duplicates, or tried to reconcile data between two systems that should have been talking to each other all along, you know the pain. It's not technically hard work. It's tedious, error-prone, and nobody wants to do it.

Claude Code is exceptionally good at these one-off tasks. Describe the source format, describe the target format, give it a sample of the data, and let it write the transformation script. We've used this for CRM migrations, CSV cleanups, deduplication jobs, and reconciling data between systems.

📋Real example: Migrating 4,000 records from a legacy PM tool

A client was migrating from a legacy project management tool to a modern one. They had three years of project data in a proprietary export format (a weird nested CSV that broke every standard parser). A developer quoted them two days of work. We fed a sample to Claude Code, described the target format, and had a working conversion script in about 40 minutes. It wasn't pretty code. But it processed all 4,000 records correctly, and that's what mattered.

Here's the thing about data cleanup work: it's almost always a one-time job. You don't need elegant, maintainable code. You need code that works once, correctly, on your specific data. Claude Code is perfect for that because you're not building something you'll maintain for years. You're building something you'll run once and throw away. That's a liberating constraint, and it's one that plays to AI's strengths.

Use Case 3: Prototyping Automations

Before we build something in Zapier or Make, we often prototype the logic with Claude Code. It helps us think through edge cases and data transformations before we commit to a platform.

Why? Because debugging logic in a no-code workflow builder is slow. You change a step, run the test, wait for it to process, check the output, realize you missed an edge case, go back, change the step again. In code, that iteration cycle is seconds instead of minutes.

Here's what this looks like in practice. Say we're building an automation that takes a new deal from the CRM, creates a project in the project management tool, and populates it with tasks based on the deal type. Before we build that in Zapier, we write a quick script with Claude Code that simulates the logic. What happens when a field is empty? What if the date format is inconsistent between the two systems? What if the deal type is "Other" and doesn't map to any of our project templates?

We work out those edge cases in the script. Once the logic is solid, we translate it to the no-code platform. The translation is easy because we've already answered all the hard questions. It saves hours of debugging in the workflow builder, and it means our Zaps are right the first time instead of the third time.

This isn't a knock on no-code platforms. They're great at what they do (orchestration, scheduling, monitoring, error handling). But they're not great at exploratory logic work, and Claude Code is.

Use Case 4: Custom API Scripts

Sometimes a pre-built connector doesn't exist. Or it exists but doesn't support the specific action you need. Or it supports the action but limits you to fields that don't include the one you actually care about.

When that happens, you have three options: live without the integration, hire a developer, or write the API script yourself. Claude Code makes option three viable for people who wouldn't normally write code.

We've written webhook receivers, custom data transforms, and scheduled jobs that pull from one system and push to another. Scripts that would have required hiring a freelance developer, and we had them working in under an hour.

One example: we needed to pull specific data from an API that had a Zapier connector, but the connector didn't expose the endpoint we needed. The data was available through the REST API, but writing the authentication flow, pagination handling, and data transformation would typically require a developer. We described the API docs to Claude Code, told it what data we needed and where to put it, and had a working script that we could run on a schedule. Total time: about 45 minutes, including testing.

⚠️

We want to be honest about the limitation here, though. These scripts work, but they're not production-grade software. They don't have comprehensive error handling, they're not optimized for performance, and they're not going to win any code review awards. For a script that runs once a day and processes a few hundred records, that's fine. For something mission-critical that handles thousands of transactions, you probably want a real developer to harden it. Know the difference.

Tips for Non-Developers

If you've never written code before and you're reading this thinking "this sounds great but I wouldn't know where to start," here's practical advice from watching non-technical people use Claude Code successfully.

Start with small, self-contained tasks. "Write a script that converts this CSV to JSON" is better than "help me with my data." The more specific and bounded your request, the better the output. You're not trying to build an enterprise system. You're trying to solve one small problem.

Be specific about what you want. Describe the input (what format is the data in, where does it live), the transformation (what should happen to it), and the output (what should the result look like, where should it go). If you can explain it to a coworker, you can explain it to Claude Code.

Ask it to explain what it's doing. This is free education. Say "explain each step of this script in plain English" and you'll start to understand the patterns. Over time, you'll get faster at describing what you want because you'll understand the building blocks.

Keep your files organized. Claude Code works best when it can find what it needs. Put your input files in a clear location. Name things descriptively. If it has to hunt for your data, you'll waste time on back-and-forth that isn't about the actual work.

Don't be afraid to say "that's not what I meant." Iteration is the whole point. The first output might be 70% right. Tell it what's wrong, and it'll fix it. That's not a failure. That's the workflow. The people who get the most out of Claude Code are the ones who are comfortable saying "close, but change this" five times in a row.

Save your working scripts. When Claude Code writes something that works well, save it somewhere you can find it later. Next time you need something similar, you can start by saying "I have a script that does X, can you modify it to do Y?" Building on previous work is faster than starting from scratch every time.

When to Use Claude Code vs. an Automation Platform

This is a question we get a lot, and the answer is simpler than people expect. Claude Code is great for building the tool. Automation platforms are great for running the workflow.

Claude Code helps you write a script. Zapier or Make helps you run that script on a schedule, trigger it from events, and monitor it over time. They're complementary, not competing.

Think of it this way: Claude Code is the workshop where you build the custom part. The automation platform is the factory where the part gets installed and runs reliably, day after day, with monitoring and alerting and error handling built in.

Use Claude Code when:

  • You need a custom data transformation that no pre-built step handles
  • You're prototyping logic before building it in a no-code platform
  • You need a one-time script (migration, cleanup, data export)
  • The pre-built connector doesn't support the specific API endpoints you need

Use an automation platform when:

  • The workflow needs to run on a schedule or trigger from events
  • You need monitoring, error handling, and alerting
  • Multiple people need to understand and maintain the workflow
  • The pre-built connectors do what you need (most of the time, they do)

The sweet spot is using both. Build the custom pieces with Claude Code, plug them into Zapier or n8n as code steps or webhook endpoints, and let the platform handle the orchestration. That combination gives you the flexibility of custom code with the reliability of managed infrastructure.

And if you're curious about where AI tools like Claude Code fit in the broader automation picture, we explored that question from a different angle in Does AI Replace Zapier?. Short answer: no. But it changes what you can build without a developer, and that matters a lot for small and mid-size businesses where "hire a developer" isn't always on the menu.


This post is part of The SMB Automation Playbook, a series on practical automation for small and mid-size businesses.

Need Integration Expertise?

From Zapier apps to custom integrations, we've been doing this since 2012.

Book Discovery Call