How to Product Categorization with AI & Google Sheets?

Hi everyone! :wave:
I’m working on an automation to categorize products based on their names. Each product should be assigned to one or more parent categories and exactly one subcategory.

  • product names will be google sheet .

  • OpenAI (ChatGPT) to suggest categories based on product names.
    now i have acategorie & subcategories
    and the challenge am facing * There are 6 parent categories and 303 subcategories. How should I store and pass the category structure (Parent > Subcategories) in a way that AI can understand?