Automation

Why automation is the unsung hero in many data projects: it frees up time and reduces errors, but only if you know where to look and when it truly makes sense.

When Is It Needed?

Automation is often thought of as a process that requires systems to "talk" to each other. While built-in integrations can facilitate automation, it is by no means a requirement. But before focussing on the technological problem, a good first step is to consider whether automation makes sense.

Automation works best for processes that are repetitive, time consuming, or open to human error. Usually, these are tasks that take place on a regular schedule or that are triggered by a prescribed action (such as a form submission or incoming email). Or they can be multi-step tasks that must occur in a particular sequence.

Because automated routines cannot accommodate unexpected variation, implementation usually requires some form of process improvement. Process improvements can have a standardizing influence and may include small things such as optimizing the order in which steps occur, harmonizing practices between staff, and occasionally removing extraneous steps altogether.

Questions that you can ask:
  • Are you struggling to complete scheduled or follow-up tasks on a consistent basis?
  • Are there tasks that you would do more regularly if they took less time?
  • Are staff spending excessive time duplicating electronic information in multiple systems?

How We Can Help

A typical automation project starts with a process map that outlines the flow of information between systems. These maps can be illuminating: sometimes they reveal inconsistent practices and they can help with identifying weak areas where processes can breakdown. The process map will become a blueprint for the automation, so we use this opportunity to pinpoint potential process improvements. Since change works best when others are included, this is also a great time to involve staff.

Once the process map has been refined, we begin to assemble the technological requirements. Where systems do not exchange information by design, we make use of intermediary technologies that do the translating between two or more systems. Increasingly, many of these tools are built into productivity suites that you may already use (e.g. Microsoft 365 or Google Workspace). We have also built our own tool, called Baton, which allows us to interface with systems that do not provide connectors to other software or access to APIs.

Automations we have previously built include:

  • transcribing information from intake forms into client management systems
  • sending appointment reminders by email or text message
  • inviting participants to complete rolling evaluation surveys
  • refreshing reports on a scheduled basis
  • transforming payroll records into an import format for bookkeeping software.

Ready to Automate?

If you’re spending hours on repetitive tasks, let's explore how automation can help.

Book a consult