GPT for Sheets examples
These are some examples of usage of all the functions from the GPT for Sheets family of functions. They work similarly to ChatGPT, but since you are in a spreadsheet, you need to carefully type in the parameters.
Simple examples
GPT FUNCTION
Write a tagline:
More detailed prompt:
GPT_LIST FUNCTION
When you need more than one answer:
Data cleaning
GPT_FILL FUNCTION
Clean up an email list:
Clean up an email list line by line:
Clean up names:
GPT_FORMAT FUNCTION
Format dates:
Format phone numbers:
Format currencies:
GPT_EXTRACT FUNCTION
Extract email adresses:
Extract countries:
Data categorization
GPT_CLASSIFY FUNCTION
Categories in a cell:
GPT_TAG FUNCTION
Apply all relevant tags:
Generate product tags:
Copywriting
GPT_LIST FUNCTION
Generate headlines:
Generate blogpost ideas:
Generate meta descriptions:
Tabular data
GPT_FILL FUNCTION
Populate descriptions in a product catalog:
GPT_TABLE FUNCTION
Create dummy data from a cell without headers:
Create dummy data from a cell with user-defined headers:
Work with text
GPT_SUMMARIZE
Summarize multiple cells at once:
GPT_EDIT
Fix grammar and spelling mistakes:
Tweak tone and content:
GPT_TRANSLATE
English to Spanish:
Value mapping
GPT_MAP FUNCTION
Find matching values:
