Back to projects
Case Study

Onion Trading Business Automation System

A centralized automation system for order management, inventory, purchasing, receivables, and reporting.

Tools used

n8nGoogle SheetsTally.soSlack

Problem

Business operations were spread across manual updates, forms, sheets, and message threads.

Solution

Created connected n8n workflows that route form submissions, update Google Sheets, trigger Slack notifications, and support operational dashboards.

Result

Reduced manual data entry and reporting time by consolidating business operations into a single automated system.

Workflow breakdown

How the system works

The workflow is organized around clean inputs, clear decisions, and predictable handoffs so the result is useful for the team.

1

Capture order and purchasing inputs through Tally.so forms.

2

Route submissions through n8n workflows with validation steps.

3

Update Google Sheets for inventory, receivables, and reporting.

4

Notify the team in Slack when action is needed.

Screenshots

Project screenshots

Real workflow maps, app screens, and dashboard views from the system build.

A&B Trading stock inventory dashboard with onion stock totals, storage usage, and physical location cards
Inventory dashboard
A&B Trading farm scouting form with supplier, phone, location, yield, decision, and downpayment fields
Farm scouting form
A&B Trading purchasing and processing form with onion purchase inputs and live tally
Purchasing and processing form
A&B Trading warehouse sorting screen with size categories and storage destination selection
Warehouse sorting screen
A&B Trading sales tracker screen with outbound sale fields, payment terms, and receivable balance
Sales tracker screen
n8n A&B Trading workflow that fetches purchases, sales, and inventory data from Google Sheets
n8n database fetch workflows
n8n A&B Trading sorting-to-inventory workflow with webhook, sheet append, and size-based inventory branches
n8n sorting-to-inventory workflow

Ready to map a workflow like this?

Let's build a practical automation system for your business.