Loving this extension, Question - is there a way to bring in multiple values in a single formula. For example =gpt(A1:A12,"Create catchy headlines that are", B1:B12, "and provide information about", C1:C12). This would be incredibly helpful when using GPT in a drag manner, in this example the outputs would occur on D1:12. I know I could capture them all in a table but the output is a bit odd and could be improved if I could insert the variables at different spots within the prompt.
sorry for the late reply, but yes of course, that's the whole point of this add-on :) You can use either the native CONCATENATE function for this, or our GPT_CREATE_PROMPT formula which helps you stitch together different cells or ranges. Note that to make it draggable, you probably want to do D1=gpt(gpt_create_prompt(A1,"Create catchy headlines that are", B1, "and provide information about", C1)) and then drag it down to D12
Guys, your extension is bombastic. 🚀 I am amazed by its possibilities. I already have a couple of use cases in mind. You've just given a second life to spreadsheets.
thank you! If you like our product don't hesitate to leave a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
amazing tool. If there a way to get a description into bullet points (using gpt_fill(reference data, command text) but to transpose it horizontally into separate cells rather than down a list?
Thank you, very cool tips. Everything worked except the "few-shot prompt" for the davinchi model. For the GPT 3.5 model I use the Examples parameter, but in the davinchi model it adds the examples as part of the text. Which parameter should I use? My formula now =GPT_LIST(C40:D46;;;; "text-davinci-003") My parameters in range C40:D46- Task: Topic: Country: Tone: Examples: Event: Length: Can you suggest a parameter name instead of Example?
Hi , can you demonstrate an example of a table with two columns with numbers and I want a third column with GPT analysis about the relations between the 2 numbers in each raw
hello, sure this can now be done by using an OpenAI assistant (we've recently integrated with them). Will make a video of it soon. Would you have an example of numbers you'd like to analyse?
Hey Stan, I just wanted to take a moment to say thank you for all of the helpful tutorial videos you've been putting out! Your expertise and attention to detail have been invaluable in helping me improve my own skills. Keep up the awesome work! #grateful #tutorialvideos #creativityboost #lifelonglearning @Stan #JuanUsingGPT
by default it is gpt-3.5-turbo as documented gptforwork.com/gpt-for-sheets/get-started you can specify the model you want by input its name in the model parameter
Hello, I'm not sure I understand the first question, but I think the answer is yes. You can also nest two functions in one, but I recommend to use different cells.
Hi, the add-on itself is entirely free for now but you need to pay the openai consumption cost. We will in the near future add paid features to the add-on.
Loving this extension, Question - is there a way to bring in multiple values in a single formula. For example =gpt(A1:A12,"Create catchy headlines that are", B1:B12, "and provide information about", C1:C12). This would be incredibly helpful when using GPT in a drag manner, in this example the outputs would occur on D1:12. I know I could capture them all in a table but the output is a bit odd and could be improved if I could insert the variables at different spots within the prompt.
sorry for the late reply, but yes of course, that's the whole point of this add-on :) You can use either the native CONCATENATE function for this, or our GPT_CREATE_PROMPT formula which helps you stitch together different cells or ranges.
Note that to make it draggable, you probably want to do D1=gpt(gpt_create_prompt(A1,"Create catchy headlines that are", B1, "and provide information about", C1)) and then drag it down to D12
Guys, your extension is bombastic. 🚀 I am amazed by its possibilities. I already have a couple of use cases in mind. You've just given a second life to spreadsheets.
thank you! If you like our product don't hesitate to leave a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
amazing tool. If there a way to get a description into bullet points (using gpt_fill(reference data, command text) but to transpose it horizontally into separate cells rather than down a list?
Hi there, I'm almost sure it's possible to do what you want. Can you please send more details through here? forms.gle/eJhwzcwiSnRiadHB6
Yes that's what I need!
@@Steven-Bamber how did you solve this?
Love your videos man! Keep posting more content please!
Thanks, I will!
Can you do a video on managing data in bulk on multiple sheets? Can i hire you to build a sheet for me?
Hi there! Can you send me more detail here please? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Is there a way to add an input parameter (e.g., a PDF document) and use a GPT function to output the data primarily from the PDF document first?
Hi Kevin, currently that is not possible. What kind of PDF document would you like to export from?
Thank you, very cool tips. Everything worked except the "few-shot prompt" for the davinchi model. For the GPT 3.5 model I use the Examples parameter, but in the davinchi model it adds the examples as part of the text. Which parameter should I use? My formula now =GPT_LIST(C40:D46;;;; "text-davinci-003") My parameters in range C40:D46- Task: Topic: Country: Tone: Examples: Event: Length: Can you suggest a parameter name instead of Example?
Hi, I'm sorry it's difficult to answer your question. Why do you want to use davinci specifically?
Hi , can you demonstrate an example of a table with two columns with numbers and I want a third column with GPT analysis about the relations between the 2 numbers in each raw
hello, sure this can now be done by using an OpenAI assistant (we've recently integrated with them). Will make a video of it soon. Would you have an example of numbers you'd like to analyse?
Hey Stan, I just wanted to take a moment to say thank you for all of the helpful tutorial videos you've been putting out! Your expertise and attention to detail have been invaluable in helping me improve my own skills. Keep up the awesome work! #grateful #tutorialvideos #creativityboost #lifelonglearning @Stan #JuanUsingGPT
You probably spent 10x more time posting on each video than writing it haha! Thanks a lot
Stan... Do you have examples how to use in Google Docs?
Hi Steve, I will very soon make videos on Google Docs, sorry I'm late on those!
Thank you for your sharing.
Can I use GPT in google sheet to translate into my country's language?
Hello, I don't know how good GPT is with asian languages, but you can try!
awesome
thank you!
And with the limited number of words, how can we apply this? Can you suggest more about this?
Hi Nhat, can you please clarify your question?
how do we know which model it is calling from? eg da-vinci-003 or similar
by default it is gpt-3.5-turbo as documented gptforwork.com/gpt-for-sheets/get-started
you can specify the model you want by input its name in the model parameter
can i select more than one value? or can i nest two functions in one?
Hello, I'm not sure I understand the first question, but I think the answer is yes.
You can also nest two functions in one, but I recommend to use different cells.
WHICH RECORDER U R USING ?
loom.com in this case
How do I create multiple tagline? If i drag the formula, it just creates the same tagline again and again
Hello, you need to disable the cache: gptforwork.com/gpt-for-sheets/explore-variations-reduce-cost
why cant i no longer download the extension to my google sheet?
hello, what error are you encountering? are you using Chrome?
Is it free or paid?
Hi, the add-on itself is entirely free for now but you need to pay the openai consumption cost. We will in the near future add paid features to the add-on.
Something isnt good. I tried, but I recieved this mesage: Error: Invalid prompt parameter. Received: #NAME?. (linha 2718).
did you launch the sidebar? what did you type?