# GPT formula examples for Sheets

See GPT functions in action with real-world examples using some of the functions included in [GPT for Sheets – Autosheet](https://autosheet.com/docs/gpt-for-sheets).

> **Tip**
>
> To try out the examples, use our [Autosheet examples template](https://docs.google.com/spreadsheets/d/1asxOjjG5Sfg9OwWczGUhPVfDKX_d_gMErxj3mFr3Up4/template/preview).

## Rewrite and generate

Use GPT functions to rewrite or create content adapted to your goals:

- Rephrase existing text by adjusting length, style, grammar or tone.
- Create content that matches your audience needs using the perfect [level of creativity](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/configure-behavior#set-the-creativity-level).

### Rewrite or rephrase content

Shorten product names:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-shorten.png)

Clean up text:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-fix.png)

Change tone:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-tone.png)

Learn more on [GPT](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt-function).

### Create content

Generate button labels (CTAs):

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-button-labels.png)

Make your content more or less creative:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-temperature.png)

Generate sales marketing emails:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-sales-marketing-emails.png)

Learn more on [GPT](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt-function).

### Generate multiple outputs (vertical vs. horizontal)

Generate SEO keywords:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-seo-keywords.png)

Generate content ideas side by side:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-multiple-outputs-horizontal.png)

Learn more on [GPT_LIST and GPT_HLIST](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt_list--gpt_hlist-function).

## Translate

Leverage large language models for your machine translation tasks and benefit from:

- **High performance**: AI models from leading providers (such as OpenAI) support translation across a wide range of language pairs. [See all supported models](https://autosheet.com/docs/resources/models/ai-providers-and-models).
- **Support for many languages**: The full list of supported language pairs isn’t public, but ChatGPT is [known to work in 80+ languages](https://botpress.com/blog/list-of-languages-supported-by-chatgpt), with varying accuracy depending on language and context.
- [**Integration of your corporate terminology**](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/create-gpt-formulas/examples#translate-with-specific-instructions): For on-brand, consistent translations.

### Translate with GPT_TRANSLATE

Translate descriptions:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-translate-desc.png)

### Translate with specific instructions

Translate with a custom dictionary:

1. Write a prompt and custom dictionary.

   ![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-translate-step1.png)

2. Create the prompt instructions.

   ![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-translate-step2.png)

3. Translate your texts.

   ![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-translate-step3.png)

Your texts are translated in the target language, and the translations comply with the terminology you provided.

Learn more on [GPT_TRANSLATE](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt_translate-function).

## Prepare data

Free up your teams from tedious data preparation so they can concentrate on high-value data analysis:

- Basic data cleaning tasks include formatting data according to known standards or by following examples you set.
- More advanced tasks like named entity extraction, which traditionally demanded a specific pattern-based approach, are also an option.

### Format data with GPT_FORMAT

Standardize dates:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-format-date.png)

Standardize cases:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-format-case.png)

Standardize phone numbers:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-format-phone.png)

Standardize currencies:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-format-currency.png)

Learn more on [GPT_FORMAT](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt_format-function).

### Extract data with GPT_EXTRACT

Extract postal addresses:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-extract-postal-address.png)

Extract email addresses:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-extract-email.png)

Extract emails and URLs:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-extract-emails-urls.png)

Learn more on [GPT_EXTRACT](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt_extract-function).

## Analyze

Get instant insights from large volumes of content through automated summarizing, categorization, tagging, and sentiment analysis.

### Summarize data with GPT

Summarize customer tickets across languages:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-summarize.png)

Summarize long descriptions:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-summarize-long.png)

Learn more on [GPT](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt-function).

### Categorize or classify data with GPT_CLASSIFY

Categorize customer feedback:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-categorize.png)

Analyze sentiment:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-sentiment.png)

Categorize customer feedback with examples:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-categorize2.png)

Learn more on [GPT_CLASSIFY](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt_classify-function).

### Assign tags with GPT_TAG

Tag products:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-tag.png)

Learn more on [GPT_TAG](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt_tag-function).

## Analyze images with GPT_VISION

Applies a prompt to an image. GPT_VISION is the only function that can process images. For example, you can ask a question about the image, generate a description or generate alt text for images.

> **Info**
>
> To use GPT_VISION, you need to select a [model that supports images (Vision)](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/use-images-in-prompts#supported-vision-models).

### Create content from an image

Write product descriptions:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-vision-product.png)

### Extract information from an image

Extract amounts from invoices:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-vision-extract-invoice.png)

Extract info from an ID:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-vision-extract-id.png)

### Explain elements in an image

Identify elements of an image:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-vision-identify.png)

Understand an image:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-vision-understand.png)

Explain formulas:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-vision-explain.png)

Learn more on [GPT_VISION](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt_vision-function).

## Search the web

### Get answers from the web with GPT

> **Info**
>
> To search the web with a GPT function, select [a model with web search capabilities](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/search-web#choose-the-right-web-search-model).

Get average hotel prices:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-web-hotel-prices.png)

Get most-spoken languages:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-web-languages.png)

Fetch top newspaper website URLs:

![](https://autosheet.com/docs/article-images/gpt-for-sheets/examples-web-newspaper-urls.png)