Skip to main content

Extract

Use the Extract bulk tool to extract relevant information from each cell of a given column.

For example, you can extract email addresses, company names, or specific entities.

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

  2. Click Extract entities 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 extract tool to match entity names with the text in your sheet:
    1. Enter the name of an entity to Extract.
    2. (Optional) Click the + button to add more entity names if needed.
    3. Select the column From which to extract.
    4. Select the column(s) to Put results in.

    5. The image shows steps to configure the extract tool

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


  6. Note: Using gpt-3.5-turbo models may result in less accurate results. To achieve enhanced accuracy in following instructions, select the gpt-4 model. Learn more.

  7. Select if you want to run a specific number of rows or All rows. Then, click Run rows.
The entities are extracted in the selected column(s).