gpt3-in-your-sheets.js

thank you sir

awesome!

Great!

Awesome!

Thank you

Hi @abi , do you know how we could adapt this code to allow something like this seen in this video? The user seems to add an example array in the first parameter and then a second array to be completed in the second parameter. Thank you so much!

Thank you so much !

Very cool!

Merci !!!

Author

@laurentbroering yup, shouldn't be hard at all. Just need to modify the prompt we are sending to OpenAI.

thanks abi, very useful

Getting some sort of error in running this script if someone can please help.

Reference Error: sk is not defined
(anonynous) @ Code:gs 1

Getting some sort of error in running this script if someone can please help.

Reference Error: sk is not defined (anonynous) @ Code:gs 1

This is really awesome, nice work

Getting some sort of error in running this script if someone can please help.

Reference Error: sk is not defined (anonynous) @ Code:gs 1

Thank sir @abi, but I have the same issue after type the command on GG Spreadsheets. Please check it.

For those getting sk is not defined error, try putting it as a string, like "sk-*******************************"

brilliant project! I have one problem with categorizing. When I type =CATEGORIZE($A$38:$A$41;A2) I get TypeError: rules.join is not a function (line 41). What can I do?

For those getting sk is not defined error, try putting it as a string, like "sk-*******************************"

Thank you sir

amazing!
is there a way to get more than 10 rows when getting the results?
thanks!

add a new ChatGPT account and it comes out like this

15:45:48 Error
Exception: Request failed for https://api.openai.com returned code 429. Truncated server response: {
"error": {
"message": "You exceeded your current quota, please check your plan and billing details.",
"type": "insufficient_q... (use muteHttpExceptions option to examine full response)
AI @ Código.gs:28`

Using your script with the new model gpt-3.5-turbo throws the following exception. Also, the completion URL needs to be changed to /v1/chat/completions from /v1/completions

Any plans to update /extend your code? Thanks!

Exception: Request failed for https://api.openai.com returned code 400. Truncated server response: { "error": { "message": "'messages' is a required property", "type": "invalid_request_error", "param": null, "code": null } } (use muteHttpExceptions option to examine full response) (line 32).

why doesn't this work with the curie model?

It's Great. Thank you vary much

@abi , can you explain about CATEGORIZE function?

@abi, I modified the prompt parameter inside function AI by manually inputting a string value but somehow gpt's responses does not take this into account. How should I modify the prompt to be sent to openAI correctly?