Get started with GPT for Sheets
Get started by discovering two example use cases: translating text and extracting email addresses directly in your Google Sheet. You can follow along by copying our example template.
Prerequisites
- You have installed GPT for Sheets and Docs on your account.
- You have created an OpenAI API key and set it up on GPT for Sheets and Docs.
Get ready to use the example template:
Open the example template.
Click USE TEMPLATE.
The spreadsheet is copied to your Google Drive and opens in your browser. You can now edit it.
Select Extensions > GPT for Sheets and Docs > Enable GPT functions.
You can now execute any GPT function from the spreadsheet.
Quickly translate data:
Open the Get started sheet, and select cell B13. The formula indicates that the value in this cell is the outcome of the
translation
of cellA13
(Apples) intoSpanish
(Manzanas).Drag the formula down to apply it to the values below.
All the fruit and vegetable names from column A are translated into Spanish, and displayed in column B.
Quickly extract data:
Select cell B36. The formula indicates that this cell is the outcome of the
extraction
of anemail
address from cellA36
.Drag the formula down to apply it to the values below.
All the email addresses are extracted from the input cells in column A, and displayed in column B.
You have successfully executed two GPT functions in Google Sheets: GPT_TRANSLATE and GPT_EXTRACT.
- Discover more examples from the template.
- Learn how to use the GPT function.