thank you! I'd be happy to hear more about your use-cases if you want to write to me. also do not hesitate to leave us a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654 as it really helps!
This is great. If I want it to reference two columns in my Reference tab... a category and its keywords, do I have to add an ARRAY function to this GPT_CLASSIFY function as well instead of just a single column?
Thanks for this great video Stan. If Chatgpt does not get the category correct, is it possible to "train" it on your own definition or examples of the Category?
I'm a psychologist - do you recommend using CLASSIFY if I want GPT to return a single integer that reflects a specific behaviorally-anchored rating scale that clarifies whether it to give a 1, 2, 3, 4 etc. based on specific text content in a sample (value variable)?
Hello, how can I give feedback on the classification ? I'm using this tool to classify my expenses. (I download them from several banks and payment providers, consolidate them into a single Excel, and classify them in several categories). For the classification part, the tool is great and beats copy and paste back and forth into GPT/Sheets ! However, I sometimes find that the classification is not working as I hoped. (for example, it's never able to detect when I buy coffe and classify it accordingly). --> With copy and paste into ChatGPT, I'm able to train the model by giving feedback to the tool. Is it something that would be implementable ?
Hello! It should work with the examples parameter in GPT_CLASSIFY, or with custom instructions. Check out our documentation about GPT_CLASSIFY parameters here: gptforwork.com/help/gpt-for-sheets/gpt-functions/all-available-functions#gpt_classify-function We are working on new tools that will be available soon, that will save you from typing the formula. Those new tools will make them easier to add custom instructions!
Is it possible to use GPT_CLASSIFY to classify column A values into very abstract groups into column B and leverage that B has already been partially filled (~20%)?
@@gptforwork Thanks for the response. I think the GPT_FILL is what I'm looking for but it appears that my data set is too large. I'm getting a maximum context limit of 4096 but my dataset is about 8 times that. I've tried adjusting the maximum_token variable but that did not appear to work. Is there any way around this?
@@forsak3n87 there is probably a better way, can you fill this form with the details? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Hello! You can specify it in your prompt if you use the =GPT() formula instead of GPT_CLASSIFY. If you're still struggling do not hesitate to contact our support team: support.gptforwork.com/hc/en-us/requests/new
Hey! Thanks. How do you think will it work if a have a range of 6000 categories? I’m not sure that it can choose the one 😅 I use the GPT4 in paid version.
Hi! It should work with gpt-4-turbo, but it will be very expensive. It would be better to group the categories to a higher level first and then subcategorize if possible.
Hey man! Really great products, can’t believe it’s free 😂. May I ask a dumb question. I know the price for OpenAI API is like 0.002 per 1000 credits and about 800 words. But for these prompts, it would literally just generate like 1 word, Will OpenAI charges us for the prompt as well, or we literally get to do this for that cheaply?
Hi there. Not a dumb question. All tokens count, prompt + response. If you only generate one word (for example in a classification use-case), then you still have to pay for every word included in the prompt. But to be honest, it is now very absurdly cheap with gpt-3.5-turbo.
Awesome tool, however I get a lot of "#ERROR" messages, "Exceeded maximum execution time (line 0)" even when Im sorting few lines (like 10). Is there something I can do?
Hi Nelson. Sorry about that it is due to custom functions requiring a response in less than 30 seconds. Unfortunately since 3 days it seems OpenAI servers response times are much higher, presumably because they reallocated capacity to ChatGPT Plus for GPT-4. Hopefully they get around improving availability soon. As for us, we should have full solution within a month, regardless of what OpenAI does.
Hey, thanks for the lessons..... as to "category" don't trust me, trust the AI: "Sure! The word “category” is pronounced as /ˈkætəɡɔːri/ with the stress on the first syllable. The word “categorize” is pronounced as /ˈkætəɡəraɪz/ with the stress also on the first syllable. Is there anything else you would like to know?"
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
Your work done here is amazing. I m currently wrapping my head about some solutions and your work was a huge part of it. Thank you for your help.
thank you! I'd be happy to hear more about your use-cases if you want to write to me.
also do not hesitate to leave us a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654 as it really helps!
Thank you - an incredible tool. Tons of efficiency gained.
You're welcome! Don't hesitate to leave us a nice review here: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654 :)
This is great. If I want it to reference two columns in my Reference tab... a category and its keywords, do I have to add an ARRAY function to this GPT_CLASSIFY function as well instead of just a single column?
Hello, not sure I fully understand the question, but you can include a range of cells for categories if you want
Thanks for this great video Stan. If Chatgpt does not get the category correct, is it possible to "train" it on your own definition or examples of the Category?
Hello! Yes it's possible, with the examples parameter of GPT_CLASSIFY, or with custom instructions that can be added in the sidebar.
How can i make it give me the top 5 or top 10 categories instead of one (GPT CLassify) or the 30 its giving me (GPT Tag)?
Hi Mark, could you let me know if the method I send you via email works? Would like to repost it here if it does.
Cheers
I'm a psychologist - do you recommend using CLASSIFY if I want GPT to return a single integer that reflects a specific behaviorally-anchored rating scale that clarifies whether it to give a 1, 2, 3, 4 etc. based on specific text content in a sample (value variable)?
Hi Matt, it's recommended to classify with semantic categories, that you can then match with their respective integers.
Hello, how can I give feedback on the classification ?
I'm using this tool to classify my expenses.
(I download them from several banks and payment providers, consolidate them into a single Excel, and classify them in several categories).
For the classification part, the tool is great and beats copy and paste back and forth into GPT/Sheets !
However, I sometimes find that the classification is not working as I hoped.
(for example, it's never able to detect when I buy coffe and classify it accordingly).
--> With copy and paste into ChatGPT, I'm able to train the model by giving feedback to the tool. Is it something that would be implementable ?
Hello! It should work with the examples parameter in GPT_CLASSIFY, or with custom instructions. Check out our documentation about GPT_CLASSIFY parameters here: gptforwork.com/help/gpt-for-sheets/gpt-functions/all-available-functions#gpt_classify-function
We are working on new tools that will be available soon, that will save you from typing the formula. Those new tools will make them easier to add custom instructions!
Is it possible to use GPT_CLASSIFY to classify column A values into very abstract groups into column B and leverage that B has already been partially filled (~20%)?
If I understand well, I think GPT_FILL is what you're looking for. Tell me if not: ruclips.net/video/Mb6ufl4H5go/видео.html
@@gptforwork Thanks for the response. I think the GPT_FILL is what I'm looking for but it appears that my data set is too large. I'm getting a maximum context limit of 4096 but my dataset is about 8 times that. I've tried adjusting the maximum_token variable but that did not appear to work. Is there any way around this?
@@forsak3n87 there is probably a better way, can you fill this form with the details? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
@@gptforwork filled! Thanks for all the help and great tool.
@@forsak3n87 just replied to you
Thank you, How many data or sentences this method can analyze for once? What if 1000 sentences?
1000 sentences should be doable if you use the text-embedding-ada-002 model
but it's probably better to do them one by one and drag the formula.
in our company, a bunch of DS tried to figure that out for 1 year. WIth this a 8 year old kid can do it in 5 mins, brilliant :)
hehe thanks!
4:11 DEEZIGNERS@@gptforwork
Hi, Is it possible that to classify the sentiment it can be done on a particular entity that appears in the analyzed text? How could I do it?
Hello! You can specify it in your prompt if you use the =GPT() formula instead of GPT_CLASSIFY. If you're still struggling do not hesitate to contact our support team: support.gptforwork.com/hc/en-us/requests/new
Hey! Thanks. How do you think will it work if a have a range of 6000 categories? I’m not sure that it can choose the one 😅 I use the GPT4 in paid version.
Hi! It should work with gpt-4-turbo, but it will be very expensive. It would be better to group the categories to a higher level first and then subcategorize if possible.
Hey man! Really great products, can’t believe it’s free 😂.
May I ask a dumb question.
I know the price for OpenAI API is like 0.002 per 1000 credits and about 800 words.
But for these prompts, it would literally just generate like 1 word, Will OpenAI charges us for the prompt as well, or we literally get to do this for that cheaply?
Hi there. Not a dumb question. All tokens count, prompt + response. If you only generate one word (for example in a classification use-case), then you still have to pay for every word included in the prompt.
But to be honest, it is now very absurdly cheap with gpt-3.5-turbo.
What is the difference between a tag and claffify?
TAG returns the top_k values that apply whereas CLASSIFY returns only one value. (TAG with top_k=1 is the same as CLASSIFY)
This is absolutely brilliant
Awesome tool, however I get a lot of "#ERROR" messages, "Exceeded maximum execution time (line 0)" even when Im sorting few lines (like 10). Is there something I can do?
Hi Nelson. Sorry about that it is due to custom functions requiring a response in less than 30 seconds. Unfortunately since 3 days it seems OpenAI servers response times are much higher, presumably because they reallocated capacity to ChatGPT Plus for GPT-4. Hopefully they get around improving availability soon.
As for us, we should have full solution within a month, regardless of what OpenAI does.
@@gptforwork I see! I thank you for the reply/information, I'm really happy and excited with the work you guys are doing
Hi! Very useful, works only in english?
no, it works in most languages :)
It works in most languages! :)
Hey, thanks for the lessons..... as to "category" don't trust me, trust the AI:
"Sure! The word “category” is pronounced as /ˈkætəɡɔːri/ with the stress on the first syllable. The word “categorize” is pronounced as /ˈkætəɡəraɪz/ with the stress also on the first syllable. Is there anything else you would like to know?"
🎉🎉🎉🎉🎉❤❤❤❤😂
how can we get chatgpt in googla sheet clearly
See the set up guide: gptforwork.com/setup
Mw vle tandem kreyol
I can't speak Creol!
Moslim
sure
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