Skip to main content

Classify

Use the Classify / Categorize bulk tool to classify each cell of a column into one of several predefined categories.

For example, you can classify apparel products for lifecycle inventory management.

Prerequisites
  1. Select Extensions > GPT for Sheets and Docs > Open.

  2. Click Classify / Categorize from the Bulk tools tab.


  3. If you open the Bulk tools for the first time, you are prompted to grant additional permissions. These permissions are required for GPT for Sheets to write in your spreadsheets.
    1. Click Sign-in with Google. A Sign in with Google window opens.
    2. Select the Google account with which you have installed GPT for Sheets.
    3. Click Allow to grant GPT for Sheets the required permissions.

  4. Configure the classification tool to match the categories with the text in your sheet:
    1. Select the column to Classify.
    2. Enter the categories you want to classify your content into.
    3. Select the column to Put results in.

    4. The image highlights three main steps: selecting a column to classify, entering desired categories separated by commas, and choosing a column to put the results in.

  5. (Optional) Add classification instructions to provide context or guidance for more accurate results.

    The image shows the 'Add extraction instructions' dropdown.
    Note: To achieve enhanced accuracy in following instructions, select the gpt-4o model. Learn more.

  6. Select if you want to run a specific number of rows or All rows. Then, click Run rows.

The closest category to the content of each cell is identified and written in the selected column.