Get ready to elevate your Google Sheets experience with the revolutionary GPTX Functions! 𤯠Powered by OpenAI's language model, these functions empower you to perform tasks like natural language processing, text generation, sentiment analysis, and even code generation directly within your spreadsheets. đ Unleash the potential for new insights and improved decision-making, automating workflows to boost your productivity. Buckle up and explore a whole new world of possibilities as GPTX functions take your spreadsheets to the next level!
*This feature is currently supported on Google Sheets only*
GPTX function
Let GPT do the job for you by producing text and displaying the results in a single cell.
Use Instructions
| Function format (syntax) | =GPTX(prompt) |
| copy/paste example | =GPTX(âWrite a funny email subject line for job applicationâ) |
| Output | The answer to your prompt will return in a single-cell |
Parameters (Inputs)
| Parameter | Definition |
| prompt | The text (or range of cells) containing a prompt to generate text from (example: âWrite a funny email subject line for job applicationâ or A1:A7) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_LIST function
Like the GPTX function, but even more user-friendly for quickly generating results in a list format.
Use Instructions
| Function format (syntax) | =GPTX_LIST (prompt) |
| copy/paste example | =GPTX_LIST(âList 5 outrageous excuses for showing up late to a meetingâ) |
| Output | The number of responses you asked for in your prompt with one response per cell |
Parameters (Inputs)
| Parameter | Definition |
| prompt | text or cell containing prompt to generate text from (example: âList 5 outrageous excuses for showing up late to a meetingâ or A1) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_TABLE function
Instantly receive your results with our function that creates tables in a snap! đŤ°đź
Use Instructions
| Function format (syntax) | =GPTX_TABLE(prompt, [header_row]) |
| copy/paste example | =GPTX_TABLE(âTop 10 most populous countriesâ, B1:E1) |
| Output | responses |
Parameters (Inputs)
| Parameter | Definition |
| prompt | text or cell containing prompt (example: âTop 10 most populous countriesâ or A1) |
|
header_row (optional)
|
A range corresponding to a header row with the desired column headers. If not specified, GPT will create column headers for you (example: B1:E1)
|
Example of Input /Output
âšď¸ Click here for an example.
GPTX_FILL function
Fill in a range with generated results that follow the pattern of the example rows you choose!
Use Instructions
| Function format (syntax) | =GPTX_FILL(examples_rows, [incomplete_rows]) |
| copy/paste example | =GPTX_FILL(A2:B6, A7:A10) |
| Output | Based on the provided examples, the blank portion of the range will be populated |
Parameters (Inputs)
| Parameter | Definition |
| example_rows | A range containing example rows for GPT to learn from (example: A2: B6) |
|
incomplete_rows (optional)
|
A range containing incomplete rows that GPT should fill in. If not specified, one new row is generated (example: A7:A10) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_MAP function
Quickly map the values of two columns based on their similarities and avoid the headache of manual comparisons!
Use Instructions
| Function format (syntax) | =GPTX_MAP(search_keys, inputs) =GPTX_MAP(search_keys, inputs) |
| copy/paste example | =GPTX_MAP(A2:A8, B2:B10) |
| Output | Returns the most similar search key for each input value |
Parameters (Inputs)
| Parameter | Definition |
|
search_keys
|
A range containing the search keys (search term or keywords) to look for (example: A2:A8)
|
|
inputs
|
A range of input values to search (example: B2:B10)
|
Example of Input /Output
âšď¸ Click here for an example.
GPTX_EDIT function
Effortlessly tidy up and edit text input right before your eyes!
Use Instructions
| Function format (syntax) | =GPTX_EDIT(text, [task]) |
| copy/paste example | =GPTX_EDIT(âAr theyâre Ny errrs in thssi setnenceâ) |
| Output | Edited text returns in a single cell |
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of texts) to be edited (example: âAr theyâre Ny errrs in thssi setnenceâ or A1:A2) |
|
task (optional)
|
The task (or range of tasks) for how the text should be edited. If no tasks are specified, it defaults to fixing grammar and spelling (example: âMake it funnyâ or B1)
|
Example of Input /Output
âšď¸ Click here for an example.
GPTX_FORMAT function
Easily transform your input text into the desired format!
Use Instructions
| Function format (syntax) | =GPTX_FORMAT(text, language) |
| copy/paste example | =GPTX_FORMAT (â5:15PM on Feb 10, 2023â, âPSTâ) |
| Output | Formatted text returns in a single cell |
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of texts) to convert (example: â5:15PM on Feb 10, 2023â or A2:A5) |
|
format
|
The format (or range of formats) to convert to (example: "PSTâ or B2:B5) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_TAG function
Tag it up! Rapidly match and apply descriptive tags to your text for enhanced organization and easy searchability.
Use Instructions
| Function format (syntax) | =GPTX_TAG(text, tags) |
| copy/paste example | =GPTX_TAG(âappleâ, âcolorful, sweet, bitter, fruitâ) |
| Output | Returns the tags(s) for the specified text |
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of texts) to apply tags to (example: âTitanicâ or B2:B11) |
|
tags
|
List of possible tags, specified either as comma-separated text or in a range of cells (example: âcolorful, sweet, bitter, fruitâ or A2:A8) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_CLASSIFY function
Whether you're sifting through extensive data sets or just organizing a few lines of text, effortlessly categorize your content based on predefined categories or labels.
Use Instructions
| Function format (syntax) | =GPTX_CLASSIFY(text, labels) |
| copy/paste example | =GPTX_CLASSIFY("pumpkin", "fruit, vegetable, grains, proteinâ) |
| Output | Returns the most relevant label/category for the specified text |
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of texts) to classify (example: "pumpkin" or B2:B9) |
|
labels
|
List of possible labels, specified either as comma-separated text or in a range of cells (example: "fruit, vegetable, grains, proteinâ or A2:A7) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_EXTRACT function
Stop searching and start finding! This extraction function makes it easy to extract the information you need from your input text.
Use Instructions
| Function format (syntax) | =GPTX_EXTRACT(text, info_to_extract) |
| copy/paste example | =GPTX_EXTRACT(â123 Main St, Smallville, CA, USAâ, âcityâ) |
| Output | Returns the desired extracted information from the text provided |
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of text) to extract information from (example: â123 Main St, Smallville, CA, USAâ or A2:A5) |
|
info_to_extract
|
The description (or range of descriptions) of the information/entity to extract (example: âcityâ) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_SUMMARIZE function
Capture the essence of your text swiftly using our summarization function! Whether you require a brief overview or a detailed summary, this function has you covered.
Use Instructions
| Function format (syntax) | =GPTX_SUMMARIZE(text, [format]) |
| copy/paste example | =GPTX_SUMMARIZE(A2:A10, â10 words or lessâ) |
| Output | Returns a summary of the input text in the format specified. NOTE - If selecting to summarize a range of cells, the output will be a summary for each individual cell of the selected range, not a single summary of all cells included in range. |
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of texts) to summarize (example: âA very long blob of text to summarizeâ or A2:A4) |
|
format (optional)
|
The desired summary format (or range of formats). If not specified, default is to generate a summary of reasonable length (example: â10 words or lessâ or B2:B4) |
Example of Input /Output..(Sorry for the spoilers đŹ)
âšď¸ Click here for an example.
GPTX_TRANSLATE function
Simplify the process of converting your input text into any language. Just specify the target language, and this function will do the heavy lifting, enabling you to communicate effortlessly with people around the globe.
Use Instructions
| Function format (syntax) | =GPTX_TRANSLATE(text, language) |
| copy/paste example | =GPTX_TRANSLATE(âThank youâ, âJapaneseâ) |
| Output | Returns the input text in the language provided |
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of texts) to translate (example: âI donât speak pig latinâ or A2:A5) |
|
language
|
The language (or range of languages) to translate the provided text into (example: âPig Latinâ or B2:B5) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_CONVERT function
Streamline the process of converting your input text into the structured format of your choice.
Use Instructions
| Function format (syntax) | =GPTX_CONVERT(text, format) |
| copy/paste example |
=GPTX_CONVERT(â<fruits><fruit>apple</fruit><fruit>banana</fruit></fruits>â, âcsvâ)
|
| Output |
Returns the provided text in the specified format |
|---|
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of texts) to convert to a new format (example: â<div><p>apple</p><p>banana</p></div>â or A2:A4) |
|
format
|
The format (or range of formats) to convert the provided text(s) to (example: âjsonâ or B2:B4) |
Example of Input /Output
âšď¸ Click here for an example.
GPTX_CODE function
Bid farewell to manual coding and embrace efficient automation! Effortlessly generate code that accomplishes your specified tasks with ease.
Use Instructions
| Function format (syntax) | =GPTX_CODE(task, language) |
| copy/paste example |
=GPTX_CODE(âExtract domain from email addressâ, âJavaScriptâ)
|
| Output |
Returns the code block that executes the specified task in a single cell |
|---|
Parameters (Inputs)
| Parameter | Definition |
| text |
The text (or range of texts) defining what the generated code should do (example: âExtract domain from email addressâ or A2:A4)
|
|
language
|
Programming language the code needs to be written in (example: âJavaScriptâ or B2:B4) |
Example of Input /Output
âšď¸ Click here for an example.
FAQs for GPTX_ Functions
Is there a token (or character) limit for GPTX functions?
Yes, to ensure that ChatGPT can provide a sufficient response, we have set a character limit of 2k tokens. This is about 8k characters for the prompt.
Do I need to have Coefficient open for GPTX functions to work?
For GPTX Functions to calculate, you will need to open the Coefficient sidebar at least once.
Why do I get the same response each time I run the GPTX function?
We use caching on every spreadsheet, which allows us to quickly retrieve answers to frequently asked questions without having to reprocess them with GPT. This results in faster response times, improved performance, and a more efficient user experience.
If you would like to clear your spreadsheet's cache, follow these steps:
- Launch the Coefficient sidebar
- Click on GPT Copilot
- Select Use GPT from the sheet
- Click on the 3-vertical dots on the page header
- Select "Clear Cache" and confirm.
Who can use the GPTX functions in my spreadsheet?
Anyone with Editor (Google Sheets Permissions) can use the GPTX functions, however - all the usage will incur on the owner of the spreadsheet who first launched Coefficient.
Will GPTX functions recalculate when I reload my sheet?
The GPTX functions, similar to Google Sheet formulas, recalculate when you reload the sheet. To avoid these recalculations affecting your usage limits, we've implemented caching. This means you'll receive consistent responses in that sheet. However, if you're aiming for fresh calculations, you'll need to reset your cache.