Release notes

Check out our latest GPT for Sheets and Docs updates:

March 11th, 2023 - Lots of improvements

  • GPT_TABLE and GPT_EXTRACT now work better with table headers
  • GPT_CLASSIFY can now use the text-embedding-ada-002 model for classification, which will prevent GPT from inventing unwanted categories. To use it, simply specify the model in the function parameter
  • GPT_TAG has a new top_k parameter which allows you to control the maximum number of tags to be returned
  • Quotation marks are better handled so that they are not trimmed when they’re wanted
  • Errors of authorization linked to multiple account should be better handled

March 6th, 2023 - Small improvements

We’ve made improvements to GPT_FILL, GPT_TABLE and GPT_EXTRACT

March 2nd, 2023 - ChatGPT turbo, baby!

OpenAI released the new chatgpt gpt-3.5-turbo model last night, and it is now the default model in in all functions of GPT for Sheets and Docs. Enjoy 10x cheaper costs, faster and better quality responses.

We turbo released this, so if it breaks anything, (1) we’re sorry and (2) please let us know here

Other improvements:

  • Specifying tags in GPT_TAG is now optional: GPT_TAG will come up with tags on its own
  • GPT_TAG and GPT_CLASSIFY output in lowercase if categories are lowercase
  • We now automatically detect fine-tuned model most frequent separators
  • A few other details that make the overall experience better

February 24th, 2023 - Map values with GPT_MAP

New functions:

  • GPT_MAP which enables you to map the values of two columns to find the best matches. You can use it to map different spellings or even categories that are semantically related. This function uses the text-ada-002-embeddings model which is extremely fast and very cheap
  • GPT_TREE which is more of an experimental function to generate trees of content in your spreadsheet.

We’ve also added a GTP function for those who find the letter T faster than the letter P! 😊

Fine-tuned models:

You can now use your fine-tuned models in GPT for Sheets! Simply specify your model in the model parameter of your GPT function.

We will automatically recognize or add the stop sequence of your prompt.

Improvements:

  • Datetimes are now better handled. (the devil really is in the details)
  • We now better handle incorrect values in all parameters
  • GPT_CONVERT now works better
  • The default max_tokens parameter has been increased to 500 in order to avoid to many cut responses

February 20th, 2023 - Real numbers and dates

The devil is in the details!

ChatGPT outputs pure text by default. When this text contains numbers or dates, we want them as numbers or date objects in our spreadsheets in order to be able to operate on them.

GPT for Sheets now correctly recognises numbers and dates before writing them to your spreadsheet. This makes it much more usable to work with tables of data.

February 14th, 2023 - Improved parsing

We have improved parsing of input in the prompts sent to OpenAI which will result in better quality output.

We have also improved our preset prompts in GPT for Docs for better output quality.

February 8th, 2023 - Added examples

We’ve added an examples template spreadsheet directly accessible from the add-on menu.

Replacing formulas now works on all GPT functions.

February 6th, 2023 - Improved error messages

We’ve made error messages easier to understand which should help you understand what to do when you input a parameter incorrectly, hit a rate limit, expire your free trial or when OpenAI servers are unavailable.

January 31th, 2023 - New preset functions!

GPT for Sheets

  • Woohoo! We just released a bunch of new functions that will make it much easier to make some frequent operations without writing any prompt:
    • GPT_TAG to apply tags. Simple and easy
    • GPT_CODE to generate code in your spreadsheet. Yes some people want to do this!
    • GPT_EDIT to edit text. By default it fixes spelling and grammar
    • GPT_EXTRACT to extract things like email addresses or companies from a paragraph. Works remarkably well
    • GPT_CONVERT to convert cells and ranges from one format to another: html, json, json-ld, nl-json, tables, csv, markdown. Incredibly powerful
    • GPT_SUMMARIZE to quickly summarize some text
    • GPT_TRANSLATE to quickly translate some text
    • GPT_CLASSIFY to classify into a single category (different from GPT_TAG where multiple tags can apply)
    • and finally GPT_CREATE_PROMPT which will help you create a prompt from many different cells and ranges in your spreadsheet by just listing them one by one as arguments
  • Fix a bug when the value parameter of GPT_LIST was empty
  • Improvements to prompt and response parsing that make our functions more robust
  • Changed the default cache setting to disabled for new users, and automatically enable it after 100 executions

January 26th, 2023

GPT for Sheets

  • GPT_LIST now supports a range as a prompt. This makes it much easier to give write a good, specific, and detailed prompt.
  • Replace formula with values now works on GPT_FILL
  • We now check if you’re the owner of the spreadsheet before you can set an API key
  • We have switched the order of parameters in all functions: max_tokens now comes before model, since:
    • tweaking the max_tokens parameter is actually useful and needs to be done frequently for longer-form content
    • there is very little reason to use another model than the default which is text-davinci-003.

GPT for Docs

  • OpenAI responses are correctly split in paragraphs when relevant
  • New tooltips have been added to the interface

January 24th, 2023

GPT for Sheets

The GPT function can now take range as prompt. This is a huge improvement, and makes it much easier to give write a good, specific, and detailed prompt.

January 20th, 2023

GPT for Sheets

We’ve released a new magical function: GPT_FILL ! This one is really incredible to see in action. All you need to do is feed it some example rows and it will fill a range intelligently. Super useful for cleaning lists, where the right prompt can be difficult to put together.

First release of GPT for Docs!

  • You can now use the add-on from Google Docs, which is much more suitable for long-form content
  • You can type your prompt directly in the document or in the prompt box

January 18th, 2023

GPT for Sheets

This update brings two cost management features:

  • Replacing formulas with values, from the Extensions menu: once you’re satisfied with the answers of GPT, you should replace the formulas with values so that they never get recalculated.
  • Cache management: we now cache answers of the same prompt by default for a duration of roughly 6 hours. This means that every answer you get will be reused if you ask the same question again or the formula gets recalculated will help lower your OpenAI costs. You can of course disable the cache if you prefer to explore variations rapidly and do not want to reuse answers. The cache is per spreadsheet.

January 12th, 2023

GPT for Sheets

We’ve released a new function: GPT_LIST !

It makes it as simple as pie to get one item per cell when you want multiple items at once, like “5 taglines for an ice-cream shop”.

January 12th, 2023

GPT for Sheets

We’ve released a new function: GPT_LIST !

It makes it as simple as pie to get one item per cell when you want multiple items at once, like “5 taglines for an ice-cream shop”.

January 7th, 2023

GPT for Sheets first release!

It all started with a simple GPT function. The little function that could.