n8n Workflow to categorize items from a table

Important: I WILL NOT negotiate the price nor Milestones. One unique payment after the workflow is delivered.

I need an n8n workflow that decide the best category for an item in a request.

Tables to use
request
request_item
category

Fields references will be shown this way: (field)

The trigger will activate when a request has the (status) field = "Offering"

The workflow must take the (request_number) and filter the table request_item to get all the items related to the request

Then take each item, select the (description) and search in the same table for "Similar" items (here is important to use a low power IA model language because there are many ways to call a, for example, ball roller: Rol, Bolillero, Ballinera, Cojinete, Rulemán)

After finding all the similar items in the previous records we categorized manually in the past, the workflow must determine the best category for the new one. In the request_item is a field (category_id) that points to the category table and the IA must compare all the previous categories assigned in the past to choose the best for the current record.

Then must insert the (category_id) selected in the table for this item and continue with the next item until all the items has a category.

After that, must update the (status) field in the request table to "Offering" and send an email (the module for sending mails is already made in php) telling:

Subject: "Request Number XXX"
Body:
"The following items has been categorized
Item 1: Category assigned
Item 2: Category assigned
Item 3: Category assigned"