Skip to main content

Get started with GPT for Sheets

Get started by discovering two example use cases: translating text and extracting email addresses directly in your Google spreadsheet. You can follow along by copying our example template.

Prerequisites
You have installed GPT for Sheets and Docs on your account.
  1. Get ready to use the example template:

    1. Open the example template.

    2. Click USE TEMPLATE.

      The spreadsheet is copied to your Google Drive and opens in your browser. You can now edit it.

    3. Select Extensions > GPT for Sheets and Docs > Enable GPT functions.

      You can now execute any GPT function from the spreadsheet.

  2. Quickly translate data:

    1. 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 cell A13 (Apples) into Spanish (Manzanas).

    2. 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.

  3. Quickly extract data:

    1. Select cell B36. The formula indicates that this cell is the outcome of the extraction of an email address from cell A36.

    2. 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.

What's next