🤔️ Need to execute tasks in bulk?

GIF Demo

👍️️️️️️ Try GPT for Sheets!

  • 📄 Create product descriptions at once
  • 💼 Generate leads and enrich data
  • 🔗️️️️️️ Scrapping sites
  • 🌎 Google Search
  • 🔍 Programmatic SEO & bulk page generation
  • 📣 AI-powered social media post generator
  • 📈 Extract top-ranked competitor keywords
  • 🤖 Support Perplexity, Claude, Mistral, Gemini, OpenRoute

How to Install GPT for Sheets

  • Install the GPT for Sheets, Docs, Slides, Forms add-on
  • Upgrade to Premium
  • How to set up your API KEY
  • RECOMMENDATION: It is preferable to use a personal Google account. If you use a company Workspace account, you may need to request your company’s admin to allow the execution of the add-on in the Workspace configuration.
  • 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.
  • RECOMMENDATION: If you use multiple Google accounts, it is recommended that you create a Chrome profile for each account.

How to install

  1. Go to the GPT for Sheets.

  2. Click Install. Install-GPT-for-Sheets

  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.
  8. Open your Google Sheet.
  9. Click on Extensions > GPT for Docs, Sheets, Slides, and Forms > Launch Launch-GPT-for-Sheets
  10. A sidebar will be opened on the right side of the page.

Launch-GPT-for-Sheets

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

refresh-account.png

!!! After getting a final result, please click on ‘Replace All GPTs’ or ‘Replace Selected’

IMPORTANT-GPT-for-Sheets

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.

Branching

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.

Branching