How to Automate Your First Business Workflow with AI (Step-by-Step)

Everyone talks about AI automation like it's magic. "Just automate it." Right. With what? How?

The gap between "AI can automate that" and actually having a working automation is where most people get stuck. Not because it's impossibly hard. Because nobody walks them through the actual steps.

So here's the walkthrough. How to take a manual process in your business — something you do repeatedly, something that eats your time — and turn it into an automation that runs itself.

I'll use a real example: customer follow-up after a service call. But the framework works for any workflow.

---

Step 1: Pick Your Biggest Time-Waster

Don't start with the most complex process in your business. Start with the one that wastes the most time relative to how simple it actually is.

Good candidates:

• Follow-up emails after calls, meetings, or service visits
• Invoice reminders for overdue payments
• Appointment confirmations and reminders
• Weekly reporting that you compile manually from multiple sources
• Data entry — copying information from one system to another
• Social media posting — the scheduling part, not the creative part

Bad first candidates:

• Anything involving complex decision-making
• Processes that change every time
• Things that need human judgment on every instance

The sweet spot is: repetitive, predictable, and boring. If you groan every time you have to do it, that's your automation.

For this guide, let's automate customer follow-up after a service call. You finish a job, drive home, and need to send a thank-you email with next steps. Most businesses either skip this entirely or do it inconsistently.

---

Step 2: Map the Manual Steps

Before you automate anything, write down exactly what you do manually. Every step. Be annoyingly specific.

Here's the manual version of post-service follow-up:

• Finish the job
• Remember to send a follow-up (this is where it usually fails)
• Open email
• Find the customer's email address
• Write a thank-you message
• Include any relevant next steps (maintenance tips, warranty info, when to rebook)
• Attach any photos or documents from the job
• Hit send
• Maybe remember to follow up again in 30 days to check in

Nine steps. Most humans reliably complete steps 1-2 and then drop off. By the time you're home and fed, the follow-up doesn't happen. Not because you don't care — because you're human and tired.

---

Step 3: Choose Your Tools

For a follow-up automation, you need three things:

• A trigger — something that tells the system "a job just finished"
• A template — the email content, personalised per customer
• A sender — something that actually sends the email

Here's what I'd use:

• Trigger: Mark a job as "Complete" in Airtable (free tier). This could also be a form submission, a calendar event ending, or a status change in whatever system you use.
• Template: Written once with AI (Claude free tier), with placeholder fields for customer name, job type, and specific next steps.
• Sender: Resend (free tier, 3,000 emails/month) or your existing email provider's API.
• Glue: Airtable automations (built into the free tier) or n8n (free, self-hosted) to connect the trigger to the sender.

Total cost: $0.

---

Step 4: Build It

Here's the actual build process for the customer follow-up automation. This takes about an hour if you're starting from scratch.

4a. Set Up Your Job Tracker

In Airtable, create a table called "Jobs" with these fields:

• Customer Name (text)
• Customer Email (email)
• Job Type (single select — e.g., Installation, Repair, Maintenance, Inspection)
• Job Date (date)
• Status (single select — Quoted, Scheduled, In Progress, Complete)
• Notes (long text — anything specific about this job)
• Follow-Up Sent (checkbox)

If you already track jobs somewhere, you can adapt this to your existing system. The key field is Status — when it changes to "Complete," that's your trigger.

4b. Write Your Email Templates

Use Claude (free tier) to draft your follow-up templates. One per job type. Here's a prompt that works:

"Write a follow-up email for a [plumbing/electrical/building] business to send after completing a [repair/installation/maintenance] job. Tone: friendly, professional, not corporate. Include a thank-you, any maintenance tips relevant to the job type, and an invitation to get in touch if they need anything. Keep it under 150 words."

Review and edit. Make it sound like you, not like a robot. Save each template.

4c. Create the Automation

In Airtable, go to Automations and create:

Trigger: When a record matches conditions → Status = "Complete" AND Follow-Up Sent is unchecked.

Action: Send an email (Airtable has a built-in "Send email" action) or use a "Run script" action to call the Resend API for better formatting and deliverability.

The email pulls the customer name, job type, and notes from the record. It selects the right template based on job type. It sends.

A second action checks the "Follow-Up Sent" box so it doesn't send twice.

4d. Add the 30-Day Check-In (Optional)

Create a second automation:

Trigger: When a record matches conditions → Status = "Complete" AND Job Date is exactly 30 days ago.

Action: Send a check-in email: "Hey [name], just checking in — how's everything going since we [did the thing]? If anything needs attention, give us a call."

This is the follow-up that almost no small business does, and it's the one that generates the most repeat work. One plumber I helped got three rebookings in the first month just from this automated check-in.

---

Step 5: Test It

Before you let this run on real customers, test it:

• Create a test record with your own email address
• Change the status to Complete
• Check your inbox — did the email arrive? Does it look right? Is the personalisation correct?
• Check the record — is the "Follow-Up Sent" box checked?
• Read the email on mobile — most people open email on their phone. Does it look good?

Fix anything that's off. Test again. It takes five minutes and saves you from sending a broken email to an actual customer.

---

Step 6: Monitor and Improve

The automation is running. Now what?

Week 1: Check that emails are sending correctly. Look at your Resend dashboard (or Airtable automation logs) for any failures.

Week 2-4: Start tracking responses. Are customers replying? Rebooking? If nobody replies to your 30-day check-in, the email copy might need work.

Month 2: Look at the numbers. How many follow-ups sent? How many led to repeat business? How much time did you save? This data tells you whether to expand the automation or adjust it.

Ongoing: Once it's stable, forget about it. That's the whole point. The system does the consistent, boring work. You do the creative, human work.

---

The Framework for Any Workflow

The steps above work for any business process you want to automate:

• Pick the most repetitive, predictable time-waster
• Map every manual step — you can't automate what you haven't defined
• Choose the simplest tools that cover trigger → process → action
• Build it — start ugly, make it work, then make it pretty
• Test with your own data before going live
• Monitor for the first month, then let it run

Most people stall at step 1 because they're trying to pick the "best" workflow. There is no best. Pick one. Build it. Learn from it. The second automation takes half the time because you already understand the pattern. If you're stuck on which workflow to start with, the AI Time-Savings Calculator ranks your biggest time-wasters for you.

---

What to Automate Next

Once your first workflow is running, here's what I'd tackle next:

• Quote follow-ups: Sent a quote three days ago? Automatic follow-up asking if they have questions.
• Review requests: 7 days after job completion, ask for a Google review.
• Weekly summary: Every Friday, pull your job data and email yourself a summary.
• Lead capture: Website form submission → record in Airtable → confirmation email → task for you to call them.

Each of these follows the same pattern. Trigger → process → action. Once you see it, you see it everywhere.

---

Need Help?

If you want to build this but the technical setup feels like a lot, I've got three options:

• Take the free AI Time-Savings Calculator — see exactly which workflows are eating your hours and how much time automation could save. Try it here →

• The AI Automation page has detailed guides for common business workflows, including the tools and templates you need. Check it out →

• A discovery call where I map out your specific workflows and tell you exactly what to automate first. 30 minutes, free. Book here →

The barrier isn't the technology. The tools are free and the setup is straightforward. The barrier is starting. So start.

---

Stay human,

Billy