How to automate repetitive tasks without writing code

You don't need a developer for every automation. If your team is spending hours on tasks like copying data between tools, sending follow-up emails, or generating reports from spreadsheets, there's a good chance you can automate most of it yourself using tools you might already have.

This isn't about AI or machine learning. It's about the boring, mechanical work that follows clear rules and doesn't need human judgment. The kind of work that, if you described it to someone, they'd say "why are you still doing that manually?"

Start with what you're already paying for

Before buying any new tools, check what your existing software can do. Most modern business tools have built-in automation that goes unused.

Google Sheets / Excel: Formulas, pivot tables, and IMPORTDATA can replace hours of manual data aggregation. Google Sheets can pull data from URLs automatically. Excel's Power Query can combine and transform data from multiple sources.

Your email platform: Mailchimp, ConvertKit, and most email tools have automation workflows built in. Abandoned cart emails, welcome sequences, re-engagement campaigns. These are set-and-forget once configured.

Your CRM: HubSpot, Pipedrive, and Salesforce all have workflow automation. Auto-assign leads, send follow-ups based on deal stage, create tasks when a deal moves forward. If you're using a CRM but not its automation features, you're leaving value on the table.

Your helpdesk: Zendesk, Freshdesk, and Intercom all have routing rules, auto-responses for common questions, and SLA escalation triggers. These don't need AI; they're just rules.

Zapier: the glue between everything

Zapier connects over 6,000 apps to each other. The concept is simple: when something happens in App A, do something in App B. These are called "Zaps."

Examples:

• When a new Typeform submission arrives, create a row in Google Sheets and send a Slack notification
• When a new order comes in on Shopify, add the customer to a Mailchimp list
• When a new file is uploaded to Google Drive, send an email to your team
• When a deal closes in Pipedrive, create a project in Asana

Pricing: Free tier handles basic automations. Paid plans start around £17/month. For most small businesses, the Starter plan covers everything.

Limitations: Zapier runs on triggers, so there's a slight delay (1-15 minutes depending on your plan). Complex logic with multiple conditions can get messy. And if you need to transform data significantly, you'll hit the limits of what Zapier can do without code.

Make (formerly Integromat): better for complex logic

Make does the same thing as Zapier but with a visual workflow builder that handles branching, loops, and data transformation better. If your automation has conditional logic ("if the order is over £100, do X, otherwise do Y"), Make is usually easier than Zapier.

Pricing: Free tier is genuinely useful. Paid plans start around £8/month (cheaper than Zapier for similar volume).

When to pick Make over Zapier: When you need to process data in steps, branch based on conditions, or loop through items in a list. Make's visual interface makes complex workflows easier to build and debug.

The five automations every small business should set up

These are the quick wins. Each takes under an hour to configure and saves time immediately.

1. Lead notification

When someone fills out your contact form, get a notification in Slack/Teams/email with their details. No more checking the form submissions page manually.

2. New customer onboarding

When a new customer is added to your CRM, automatically send a welcome email, create a project/folder for their work, and notify the relevant team member.

3. Weekly report digest

Pull key numbers from your tools (sales, support tickets, website traffic) into a single Slack message or email every Monday morning. Saves the 30-minute "pulling the numbers together" task.

4. Invoice follow-up

When an invoice goes overdue in your accounting tool, automatically send a polite reminder email. Most accounting software (Xero, QuickBooks) has this built in.

5. Social to spreadsheet

When you're mentioned on social media or a review platform, log it to a spreadsheet for tracking. Useful for monitoring mentions without checking five platforms manually.

When no-code isn't enough

No-code tools have real limits. Here's when you'll need a developer:

Complex data transformation. If you need to parse PDFs, combine data from messy sources, or apply fuzzy matching logic, Zapier and Make won't cut it. You need a proper data pipeline.

High volume. If you're processing thousands of items per day, the per-operation pricing of Zapier/Make can exceed the cost of a custom script. And the execution time limits can become a problem.

Anything that needs learning. If the task requires recognising patterns, classifying things, or making predictions based on data, you need machine learning, not rules.

Security-sensitive data. If you're processing personal data, financial records, or health information, routing it through third-party automation platforms may not comply with your data handling requirements.

Hit the limit of what no-code can do?

That's the natural progression. Start with Zapier and Make, and when those aren't enough, it's time for a custom solution. If you're at that point, get in touch and I'll help you figure out what to build next.

---

Related reading:

• How I'd automate invoice reconciliation for a small business
• Automating Xero and QuickBooks: a practical guide
• My AI automation service: when no-code tools aren't enough