GPT for Sheets

GPT for Sheets is an AI-powered tool that integrates OpenAI's GPT models directly into Google Sheets, enabling users to leverage generative AI capabilities within their spreadsheets.

Key features:
- GPT Function: Generates responses to prompts directly in a cell
- GPT_LIST / GPT_HLIST: Outputs results in a column or row
- GPT_TABLE: Creates tables based on prompts
- GPT_SPLIT / GPT_HSPLIT: Splits text into multiple cells vertically or horizontally
- GPT_FILL: Fills a range of cells based on a pattern or example
- GPT_MATCH: Matches patterns or categories within text
- GPT_FORMAT: Formats text according to specified rules
- GPT_EDIT: Edits text based on instructions
- GPT_TAG: Tags text with specified labels
- GPT_CLASSIFY: Classifies text into categories
- GPT_EXTRACT: Extracts specific information from text
- GPT_SUMMARIZE: Summarizes text
- GPT_TRANSLATE: Translates text into another language
- GPT_CREATE_PROMPT: Helps create prompts for other GPT functions
- GPT_VISION: Analyzes images and generates descriptions or extracts information
- GPT_WEB: Fetches and processes web content

How it works:
Users interact with GPT for Sheets through Google Sheets by enabling the GPT functions via the Extensions menu. Once enabled, users can input various GPT functions directly into their spreadsheet cells, providing prompts and optional parameters to generate desired outputs.

Integrations:
GPT for Sheets integrates seamlessly with Google Sheets, leveraging the familiar spreadsheet interface to provide advanced AI capabilities.

Use of AI:
GPT for Sheets utilizes OpenAI's GPT-3.5 and GPT-4 models, which are known for their advanced natural language processing capabilities. These models are fine-tuned to handle various tasks such as text generation, summarization, translation, and more.

AI foundation model:
Without an API Key:
- OpenAI GPT-3.5-turbo
- OpenAI GPT-4-turbo

With an API Key:
- OpenAI GPT-3.5-turbo
- OpenAI GPT-4-turbo
- GPT-4o
- Anthropic Claude
- Mistral
- Gemini

How to access:
GPT for Sheets is available as a web app integrated into Google Sheets. It requires an active subscription to access its full range of features.