DocGPT.ai Docs

GPT for Sheets

GPT for Sheets is an AI writer and assistant tailored for Google Sheets. It allows seamless integration of ChatGPT directly into Google Sheets. This system is developed on the foundation of OpenAI ChatGPT and leverages both GPT-3 and GPT-4 models.

Key Features

Functionality Description
Working with text Perform various tasks involving text manipulation.
Writing text Generate textual content for various purposes.
Cleaning data Clean and organize data within Google Sheets.
Fixing grammar and spelling Correct grammatical errors and spelling mistakes.
Extracting entities Identify and extract specific entities from text.
Tagging and categorizing Assign tags and categories to content.
Translating Translate text content to different languages.
Creating taglines, headlines Generate catchy taglines and headlines for content.
Generating ad copy Create persuasive and engaging advertising copy.
Crafting product descriptions Generate detailed and compelling product descriptions.
Formulating subject lines and emails Generate subject lines for emails and other content.
Developing outlines and blog posts Create outlines and draft content for blog posts.

Important!

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)

GPT Functions

The add-on provides a variety of GPT functions tailored for different use cases. You can explore them by typing =GPT_ in a cell.

Particularly useful GPT functions for Google Sheets include:

  • GPT
  • GPT_LIST
  • GPT_SPLIT
  • GPT_FILL
  • GPT_TABLE
  • GPT_FORMAT
  • GPT_EDIT
  • GPT_TAG
  • GPT_CLASSIFY
  • GPT_EXTRACT
  • GPT_SUMMARIZE
  • GPT_TRANSLATE

Table of contents