Powerful Prompt Engineering in Google Sheets™
GPT Unleashed: Free for Google Sheets™
Get the add-on! 🚀 
Don't wait longer to see supercharged LLM-results in your Google Sheets™.
Why users love it 😍
Speed up great AI-Results in Google Sheets with powerful & simple Prompt Engineering features
Did you ever lose a wonderful prompt in your endless chat history? GPT Unleashed will change that - with ultra-customizable prompt management and full control over ChatGPT™ models (including 'GPT-4o').
Free forever
I believe that the power of LLM's like ChatGPT™ should be accessible for everyone. After about 30 API calls, you will be prompted to generate a FREE license key by subscribing to my newsletter.
Use your own API key
All you need in order to start is an API key obtained from OpenAI.
Job shortcodes
A "job" is a predefined prompt assigned to a job-shortcode that you can use in the GPTUL formula. Example: Create a job-shortcode named bullet-extractor and assign to it the prompt Extract main facts as a bullet list.. Use it in your formula: =GPTUL(A2,"bullet-extractor").
Context shortcodes
Similar to "jobs", contexts can help GPT to tailor results to the context of your work. You can either feed this with information about your project, or with rather generic prompts like in the following Example: Create a context name nofurthercomments containing information like Return the output without further comments, since it will be used programmatically.. Use it alone or in combination with jobs and see the magic!
Built-in cache
GPT Unleashed offers pragmatic response caching to save on API costs. All API responses are stored in a short-term and long-term cache before being returned in the cell.
Model shortcodes (presets)
Easily compare the output-quality of different OpenAI Models by creating presets with parameters like the used Model, Temperature, and more...
Feels like cheating? let's call it "sheeting" 🤷
Start systemizing & reusing your best performing prompts for 10x'ed productivity and superior results.
📋 Copy these job prompts!
Need some inspiration for your own prompt templates? Just copy one of these and create a new 'Job' template in GPT Unleashed. Then, use your shortcode in the GPTUL formula.
Generate entire tables
Prompt:
Generate a table based on the provided topic. Format your response as CSV (Comma-Separated Values) data, following these guidelines:
1. First row should contain column headers
2. Use commas to separate columns
3. Use semicolons (;) to separate rows
4. Include 4-8 columns and 5-15 rows of data
5. Ensure consistent number of columns in all rows
6. Avoid empty cells (use N/A if necessary)
7. Do not use actual newline characters
Your response should be wrapped in this formula:
=ARRAYFORMULA(SPLIT(TRANSPOSE(SPLIT("YOUR_CSV_DATA_HERE", ";")), ",", TRUE, TRUE))
Example of desired output:
=ARRAYFORMULA(SPLIT(TRANSPOSE(SPLIT("Header1,Header2,Header3,Header4;Value1A,Value1B,Value1C,Value1D;Value2A,Value2B,Value2C,Value2D;Value3A,Value3B,Value3C,Value3D", ";")), ",", TRUE, TRUE))
Provide only the formula, with no additional text or explanation. Replace the example data with your generated content.
Fill gaps in a table
Prompt:
The user input is a range from Google Sheets, representing a table. Return a markdown-like table that is a complete version of the input table, including the missing values. All cells must be non-empty and contain high-quality content.
Strictly use the following output format and and wrap the formula around your output, since it will be used in Google Sheets.
Example:
=ARRAYFORMULA(TRIM(SPLIT(TRANSPOSE(SPLIT("| Col1 | Col2 | Col3 | Col4 |
| text1 | text2 | text3 | text4 |
", CHAR(10))),"|", True)))
Note: There shall be NO separator row between columns and content. Return without further comments.
Create a vertical list ↕️
Prompt:
Return a list based on the users input. Format: One item per line, no further comments, plain text list with line breaks. Wrap your output into the formula since it will be used to format your outputs in google sheets. Example output:
=TRANSPOSE(SPLIT("Item
Another item
Yet another one
(...)",CHAR(10), true))
Create a horizontal list ↔
Prompt:
Return a list based on the users input. Format: One item per line, no further comments, plain text list with line breaks. Wrap your output into the formula since it will be used to format your outputs in google sheets. Example output:
=SPLIT("Item
Another item
Yet another one
(...)",CHAR(10), true)
Frequently Asked Questions
Your questions answered
Where can I find answers to my questions?
Working on this section right now!😅 Please send me your questions, I am glad to share the answer here and via e-mail!
Get a free license key!
After a short trial period, you will be prompted to enter a license key in the Google Sheets add-on.