How to Install GPT for Sheets

Links:

• Install the GPT for Sheets, Docs, Slides, Forms add-on
• Upgrade to Premium
• Optional -> RECOMMENDATION: The best way to ensure optimal performance with Google Add-Ons is by using the Google Chrome browser. This helps bypass any potential issues that may arise from compatibility with other browsers.

!!! After subscribing or changing your plan, please click on the ‘Refresh Account’ button located on the sidebar

To leverage the capabilities of language models using GPT functions within your Google spreadsheets, install the GPT for Sheets, Docs, Slides, Forms add-on. Once installed, this add-on also extends the capabilities of AI to Google Sheets, Docs, Forms, Slides.

If you use multiple Google accounts, it is recommended that you create a Chrome profile for each account.

1. Go to the Workspace Installation Page.

2. Click Install.

3. Select Continue within the confirmation dialog.

4. A new window labeled Sign in with Google will appear.

5. Choose the Google account you wish to use for installing GPT for Docs, Sheets, Slides, and Forms.

6. Grant the necessary permissions by clicking on Allow.

7. A notification in a pop-up window will confirm the successful installation of GPT for Docs, Sheets, Slides, and Forms.

How to Launch GPT for Sheets

1. Open your Google Sheet.
2. Click on Extensions > GPT for Docs, Sheets, Slides, and Forms > Launch
3. A sidebar will be opened on the right side of the page.

Important!

After getting a final result, please click on ‘Replace All GPTs’ or ‘Replace Selected’ button to replace the formula with the result. If to don’t do this - Google Sheets re-execution all formulas on refreshing page and every 1–2 minutes. (could affect your credits on Open AI or Internal credits, depends on plan)

Template with Examples

Here you can find a Google Sheet Template with examples Google Sheet Template. The file is accessible in read-only mode. To make modifications, please create a copy using File > Make a copy, or you can simply copy functions/examples into your own sheet.

How to use GPT functions

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.

Translation using GPT for Sheets - GPT_TRANSLATE

1. Open a sheet, and select a cell.
2. Enter the formular for translation text: =GPT_TRANSLATE(A30, "norwegian","english")
3. The first parameter represents the text to be translated, the second parameter is the target language—possibly derived from a column value, and the third parameter is an option for the source language.
4. Drag the formula down to apply it to the values below.

Data Extraction using GPT for Sheets - GPT_EXTRACT

1. Open a sheet, and select a cell.
2. Enter the formular for extraction text: =GPT_EXTRACT(A57,"country")
3. The first parameter signifies the original text from which you intend to extract information. The second parameter is a human-readable descriptor indicating what you want to extract—such as Email, First Name, Last Name, Address, Phone, Country, City, or any other relevant information.
4. Drag the formula down to apply it to the values below.