Back/Operations/Claude/Airtable
IntermediateOperationsClaudeAirtable

How to Create a Custom Product Classification System with AI and Airtable

This workflow shows you how to design a custom categorization system, like a Dewey Decimal System for any collection, and use AI to automatically classify hundreds of items in an Airtable database, saving countless hours of manual work.

From How I AI

How I AI: Building a Real-World Business with Andrew Mason & Nabil Hyatt

with Claire Vo

How to Create a Custom Product Classification System with AI and Airtable

Tools Used

Claude

Anthropic AI assistant

Airtable

Cloud-based database and spreadsheet tool

Step-by-Step Guide

1

Design the Classification Framework with an AI

Use a conversational AI like Claude to design the entire hierarchy for your custom system. Brainstorm broad categories and assign them number ranges (e.g., 400s for Cooperative Games). You can also add a decimal system for sub-attributes like complexity (e.g., .1 for lightest to .5 for heaviest), resulting in a code like 420.5.

2

Set Up Your Airtable Database

Create an Airtable base and import your entire collection or inventory into it. You'll need a field for the item's name and an empty field where the AI will place the classification code.

3

Automate Categorization with an AI Model

Connect an AI model to your Airtable database. For each item, provide the AI with the item's name and the complete set of rules for your classification system. The AI will then automatically analyze each item and assign the correct code, populating your database without manual research.

4

Curate Collections with AI-Powered Fields

Leverage Airtable's built-in AI features to create curated collections. Define a new category with a simple, plain-English description like 'Games about cats' or 'Silent Strategists.' The AI will then automatically scan your inventory and populate that category with the relevant items.

Become a 10x PM.
For just $5 / month.

We've made ChatPRD affordable so everyone from engineers to founders to Chief Product Officers can benefit from an AI PM.