
Automated Operations
Building a semi-automated marketplace listing system that turned scattered inventory notes, photos, and form entry into a faster, more delegable workflow.
Project Context: Founder-led internal business | Lonely White Iris LLC
Project Overview
For this project, I built a semi-automated marketplace listing workflow for a resale business that needed to increase listing output without making the process harder to manage, train, or delegate.
The original listing process worked, but it was slow and overly dependent on one person manually moving information between photos, notes, research tools, AI tools, spreadsheets, and a cross-listing platform. Each item required product photos, storage tracking, item research, SEO title creation, description writing, thumbnail editing, category mapping, marketplace-specific subform details, and final form entry.
Even with helpful tools like Canva templates, AI-assisted writing, and cross-listing software, the process still took approximately 18 to 25 minutes per item. Hiring a VA who specializes in cross-listing research and form creation would have cost around $1 per listing. The automation I built reduced the direct per-item automation cost to roughly $0.03 to $0.05 per item, excluding fixed software subscription costs, while also reducing hands-on listing preparation time to approximately 2 to 5 minutes per item.
The goal was not to remove human judgment entirely. The goal was to create a system where humans were spending their time on the parts that actually needed human attention, while the repetitive administrative, formatting, folder creation, transcription, data structuring, and form-entry steps were handled automatically.
The Problem
Marketplace listing sounds simple from the outside: take photos, write a description, add a price, and publish. In practice, especially for resale inventory, the process has many small steps that depend on accuracy.
Before the automation, the workflow looked something like this:
The process was functional, but it created several operational issues.
First, it was time-consuming. Each item took around 18 to 25 minutes to prepare properly, and that time added up quickly across batches of 20, 30, or more items.
Second, the process was difficult to hand off. Important information lived in different places: photo folders, phone notes, human memory, AI chats, spreadsheet rows, storage labels, and cross-listing form fields.
Third, the business needed a workflow that could grow. If the only person who understood the full process was the owner or the person sourcing inventory, the business would stay limited by that person's available time.
The question became:
How can this process be rebuilt so that the work is faster, easier to delegate, and still accurate enough for marketplace listings?
My Approach
I started by mapping the actual human process before building the automation.
That was important because the goal was not just to automate random steps. I needed to understand what order the work happened in, where the bottlenecks were, what information was being repeated, and which parts of the process actually required human judgment.
Once I looked at the workflow from beginning to end, I separated it into four categories:
Sourcing inventory, inspecting items, and making judgment calls about whether an item was worth listing.
Taking photos, noticing defects, confirming item details, and reviewing the final listing before publishing.
Transcribing spoken inventory notes, parsing item details, creating spreadsheet rows, generating item folders, creating listing titles and descriptions, generating category suggestions, formatting internal notes, and filling in the main listing form.
Some copy-and-paste steps, list reversals, spreadsheet cleanup, and final subform handling were left with a human because the time required was minimal and full automation would have increased token usage or created unnecessary complexity.
This became the core philosophy of the project: automate the repetitive structure, preserve human review where quality matters, and document the system so another person could operate it without needing to understand every technical layer underneath.
The Solution
The final workflow became a semi-automated listing system built around audio capture, Google Drive organization, spreadsheet data, AI-assisted listing generation, Telegram bot triggers, and browser automation.
Instead of manually writing notes after photographing each item, the person photographing inventory wears a wireless microphone and verbally describes each item while they are already handling it. They use a consistent spoken structure and code words to separate one item from the next.
For each item, they state information such as:
This means the item documentation and the photo process happen at the same time instead of being treated as separate tasks.
After the inventory batch is photographed, the audio is uploaded to a specific Google Drive folder. The user then sends a Telegram command to trigger the automation.
From there, the automation transcribes the audio, separates the transcript into individual items, parses the spoken information into structured fields, creates spreadsheet rows, and generates Google Drive folders for each item. The person then uploads each item's photos into the matching folder.
A separate photo-editing tool handles the thumbnail process, including background removal and creating edited images. Those edited photos are added to the item folders as well.
Once the photos are organized, another automation step creates public image links and file paths. This allows AI agents to reference the item photos for listing generation and allows the browser automation tool to later retrieve the correct photos from the synced Google Drive desktop folder.
The structured item data and photo links are then used to generate the listing content. This includes SEO-friendly titles, product descriptions, keywords, category suggestions, tags, internal notes, storage labels, and default values like pre-owned condition and standard disclaimer text.
Finally, Axiom.ai inputs the generated information into the cross-listing software. The human reviewer then checks the final output, handles marketplace-specific subform details, cleans up any occasional formatting issues, and publishes or saves the listing.
Workflow Breakdown
The system can be understood in five main phases.
The person photographing inventory describes each item out loud using a consistent structure. This turns the photo session into both a visual documentation process and a data collection process.
This was one of the most important changes because it removed the need to separately write notes, remember item details, or go back later to reconstruct what each item was.
After the audio is uploaded to Google Drive, the automation is triggered through Telegram.
The audio is transcribed, then the transcript is scanned for the code words that separate one item from the next. Each item is turned into a structured data bundle with fields like item number, description, price, label, and internal notes.
Those bundles are then added to a spreadsheet, with each item receiving its own row.
Once the spreadsheet rows are created, the automation generates matching Google Drive folders for each item.
The user then uploads each item's photos into the correct folder. This is still a human step because photo accuracy matters. If the wrong photos are uploaded or photos are missing, that can affect the quality of the research and listing generation later.
This step keeps human involvement where it is most useful: making sure the visual information is correct.
Once the item data and photos are organized, the system uses the information to generate the listing content.
This includes:
The goal was to give the final reviewer everything they needed in one place so they were not doing the research and writing from scratch.
Axiom.ai handles the form-entry portion by taking information from the spreadsheet and placing it into the correct fields in the cross-listing software.
At this point, the human reviewer mainly checks the output, handles subform details, and catches occasional errors. For example, sometimes AI-generated text may leave behind formatting artifacts or JSON-like text. I created a simple cleanup tool for this so the reviewer could paste in the issue and quickly clean the text without needing to manually rewrite the whole description.
This final review step is also where more nuanced requests can be handled, such as checking comps on eBay or Poshmark if pricing needs a second look.
Proof of Concept
One part of the automation that shows the logic of the system especially clearly is the audio-to-folder workflow.
This is the step where a spoken inventory recording becomes a structured spreadsheet and a set of item-specific Google Drive folders.
The logic works like this:
This step is a good example of how I approached the larger project. I was not just connecting tools together. I was creating a repeatable operating logic: a human performs the part that needs physical interaction, then the automation converts that human input into structured data that the rest of the system can use.
Click to expand
Results
The final system significantly reduced both time and cost.
For a batch of 25 listings, this changed the work from a process that could take 6–7 hours to one that could take a little under 2 hours on the sourcing and photo-preparation side.
This matters because the business no longer has to choose between spending a large amount of human time on each listing or outsourcing every research and form-creation step at a higher per-listing cost.
The workflow can now be split between multiple people depending on the business's needs. One person can source inventory, another can photograph and describe the items, and another can review and publish the final listings. Or, if the team is smaller, one person can handle multiple stages without needing to understand the full technical architecture.
I documented the workflow by who does what and when. This means a new person does not need advanced technical knowledge to participate in the system. They mainly need fashion familiarity, attention to detail, and the ability to follow a step-by-step process.
The automation reduced repetitive work, but it did not remove quality control. A person still reviews the final listing, checks photos, handles unusual item notes, confirms subform details, and performs extra pricing research when needed.
Tools Used
This project used a combination of automation, AI, storage, communication, and browser tools.
The tools mattered, but the more important part was the system design: each tool had a specific role, and the workflow was built so that the human user did not have to manually manage every transition between them.
What This Project Demonstrates
This project reflects how I approach operations and automation work.
I do not start by asking, "What can I automate?" I start by asking, "What is the actual process, where is the friction, and what parts of this work should a human still be responsible for?"
In this case, the answer was not to fully remove the person from the workflow. The better answer was to redesign the workflow so that the person's time was spent on sourcing, photographing, reviewing, and making judgment calls, while the automation handled transcription, structuring, organizing, generating, formatting, and form entry.
The result was a marketplace listing automation system that reduced time, lowered per-item processing cost, improved delegation, and created a more scalable operations workflow for the business.