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
- You have installed GPT for Sheets.
- You have opened a spreadsheet containing a single column with text.
- Select Extensions > GPT for Sheets and Docs > Open.
- Click Extract entities from the Bulk tools tab.
- 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.
- Click Sign-in with Google. A Sign in with Google window opens.
- Select the Google account with which you have installed GPT for Sheets.
- Click Allow to grant GPT for Sheets the required permissions.
- Configure the extract tool to match entity names with the text in your sheet:
- Enter the name of an entity to Extract.
- (Optional) Click the + button to add more entity names if needed.
- Select the column From which to extract.
- Select the column(s) to Put results in.
- (Optional) Add extraction instructions to provide context or guidance for more accurate results.
- Select if you want to run a specific number of rows or All rows. Then, click Run rows.
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.
What's next