Skip to main content

GPT for Sheets examples

Check out these examples demonstrating the usage of all the functions in the GPT for Sheets family. They work similarly to ChatGPT, but since you are in a spreadsheet, you must carefully input the parameters.

tip

Click here to access a Google Sheets template examples.

Simple examples​

GPT​

Write a tagline:

Write a tagline for an ice-cream shop

More detailed prompt:

Use a prompt split in several cells: task, topic, country, tone, length...

GPT_LIST​

When you need more than one answer:

List 5 possible Quora questions on a given topic

Data cleaning​

GPT_FILL​

Clean up an email list:

Clean up email addresses from unwanted symbols like <> or ''

Clean up an email list line by line:

Use $ to provide a fix range for examples of correct emails: $B$2:$C$4

Clean up names:

Clean up names from unwanted characters like Dr. or Jr

GPT_FORMAT​

Format dates:

Provide an example output to format your dates: 2/14/1971

Format phone numbers:

Provide an example output to format your phone numbers: +1 212-555-1924

Format currencies:

Provide an example output to format your currencies: GBP 10,322.00

GPT_EXTRACT​

Extract email adresses:

Extract email addresses from sentences

Extract countries:

Extract countries from sentences

Data categorization​

GPT_CLASSIFY​

Categories in a cell:

Classify 'avocado' according to categories: fruit, vegetable

GPT_TAG​

Apply all relevant tags:

Apply tags 'food, positive, negative, beverage' to text 'I love chocolate'

Generate product tags:

Generate 5 product tags for a swimsuit description

Copywriting​

GPT_LIST​

Generate headlines:

Create 5 catchy headlines for a garage, 30 characters max

Generate blogpost ideas:

Generate 5 blogpost ideas for Instagram growth

Generate meta descriptions:

List 5 compelling Google Ads responsive meta descriptions for handcrafted jewels

Tabular data​

GPT_FILL​

Populate descriptions in a product catalog:

Generate descriptions for pineapple and egg based on description examples for banana and strawberry

GPT_TABLE​

Create dummy data from a cell without headers:

Generate a table of the 3 most eaten fruits and their calories

Create dummy data from a cell with user-defined headers:

Create a table containing fake info on 3 people: First name, last name, birth date, occupation

GPT_SPLIT​

Split your text into sentences:

Split into sentences and insert them into separate cells

Work with text​

GPT_SUMMARIZE​

Summarize multiple cells at once:

Summarize the content of several cells into 4 bullet points

GPT_EDIT​

Fix grammar and spelling mistakes:

Fix your text with a simple GPT_EDIT function

Tweak tone and content:

Specify how to edit your text: add a next step, tone should be more formal

GPT_TRANSLATE​

English to Spanish:

Value mapping​

GPT_MAP​

Find matching values:

Provide a list of companies to extract from text in other cells
On this page