Skip to main content
Software & automation • Context: professional Status: Completed 2021–2025

Client Follow-Up Automation

A Python tool for generating client follow-up spreadsheets from previous business records.

My role

IT Administrator & Developer (Risk Alliance Direct)

I worked out the filtering workflow, built the tool and handed it over to the team at Risk Alliance Direct.

Tools

PythonExcelData processing
01Business RecordsPrevious data02Python FilteringRetained client selection03Spreadsheet OutputFollow-up lists04Team HandoverDay-to-day use
Filtering previous business records into client follow-up spreadsheets Workflow overview

Overview

Staff needed lists of retained clients who required follow-up calls. The tool used existing business data to prepare those spreadsheets.

Technical details

The workflow processed previous records, selected the relevant follow-up information and generated spreadsheet output.

Outcome

The tool replaced repeated manual filtering and spreadsheet preparation with a repeatable process.

Related skills