Hi everyone, - there is a new version of this video here, which is much better: ua-cam.com/video/lnQPAWWmaKk/v-deo.html - if you're having trouble, please review the troubleshooting section of this page: gptforwork.com/troubleshooting/errors - if it doesn't answer your question, fill out the following form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform Thank you!
Here's a brief overview of the terms you mentioned: 1. **Prompt**: This is the initial input text you provide to the model. It's essentially a question or a statement that guides the model on what you want it to generate. The model uses this prompt as a starting point and continues the text in a way that's consistent with the prompt's context and style. 2. **Value**: This term is not commonly used as a standalone parameter in the context of GPT settings. It might refer to the specific value of another parameter, or possibly it's being used in a specific application's context. If you meant "values" in the sense of data provided to the model, it would still typically be part of the "prompt". 3. **Temperature**: This controls the randomness of the output generated by the model. A higher temperature results in more random outputs, which can be useful for generating creative or varied text. A lower temperature makes the model's outputs more deterministic and repetitive. A temperature close to 0 makes the model almost always choose the most likely next word, while a higher temperature (closer to 1) encourages diversity in the generated text. 4. **Model**: This refers to the specific version or configuration of the GPT model you are using. Different versions of the model (like GPT-3, GPT-4, etc.) have been trained on different datasets or for different lengths of time, which affects their performance and capabilities. Within a particular version, there might also be different sizes of the model (measured in the number of parameters) that offer a trade-off between computational cost and the ability to generate high-quality text. 5. **Max Tokens**: This parameter specifies the maximum length of the generated text measured in tokens. A token can be a word or part of a word, so the actual length in words can vary. Setting a higher max tokens limit allows the model to generate longer responses, while a lower limit restricts it to shorter texts.
Hi Matias, depending on what database you're talking about, and if your data is not too large, you can import it to Google Sheets with our other product awesome-table.com/connectors You'll then be able to use GPT for Sheets and make charts on the spreadsheet. Let me know if that helps!
Hi Stan, I made some really amazing spreadsheets for my company using your videos and I have been asked to demo for the CEO and the board. The now is that most of the models are timing out (3.5 turbo, for example)....so I'm now having to use davinci in order to get a response but it's so inaccurate compared to a few weeks ago, so i don't feel like I can show it off. Do you have any tips to solve this?
Hi Michael, did you set up a paid method on openai? This should make 3.5-turbo fast enough, as per this chart: gptforwork.com/tools/openai-api-response-time-tracker Shoot me an email, I'll be happy to help
Hey there! Great video loving the plug-in. Do you happen to know the function code of this plug-in so I can combine it with "=subtotal" functions? Trying to use Chat GPT to summarize filtered data but need the subtotal function... I believe. Any guidance would be amazing!
Great! Thank you! Can you tell me how to bypass the limit on the number of characters? I set the "write an article 500 words" value, but it only fills part of it.
Thank you very much! If I get 15 answers generated in the A1 Cell how can fragment each of the 15 inside A1 so that each gets their own row from 1-15 in the A column? I'm stuck on figuring this out! Thank you in advance to all kind enough to reach out!
Sorry about this. Could you please fill out the support form and include a screenshot? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
I have a big conversation in my ChatGPT account, also input things to learn how i want my answers. Can I access that context and use it in Sheet? And how much am I limited to, because in ChatGPT itself there is a limitation of a number of words.
Hello! We would be happy to help you with your particular use case. Please contact the support to give more details about what you want to do: support.gptforwork.com/hc/en-us/requests/new
I have 2 questions : - How do you copy or import the results other than the formula? I am trying to find how to get the results instead of the =gpt(,,,,). When I get the paragraph I want and click on the cell, the paragraph disappears and shows the formula, which is normal but how do we keep our results « printed »? - Do you know why it’s not showing the whole results ? The paragraph is cut at half the lines, like someone is reading something and just stops in the middle of the phrase. Request : can you make an « import result as text » formula and a translation formula? Thank you!
Hi there, I think I have answers to all your questions :) - we have a "replace formulas" feature: gptforwork.com/gpt-for-sheets/prevent-formula-recalculation - if I understand correctly, you need to increase the max_tokens parameter: ua-cam.com/video/82Fc9Olldnw/v-deo.html - we cannot "import as text" from a formula, but we are working on something else that will let you do that - you can already use GPT_TRANSLATE :) ua-cam.com/video/wQUJWoOmT8Q/v-deo.html Hope that helps
Great idea @talariansoftware. I managed to complete the setup and created prompts yesterday. I noticed that the results changed when I logged back in today. Is that by design eg the API generates a new result to the original prompt?
Hi Barry, this is how custom function in Google Sheets work: they are recalculated every time the spreadsheet is opened or the arguments change. We have implemented basic caching so that no recalculation occurs during 6 hours if arguments don't change. But if you really want to freeze the results, you need to use our "Replace GPT formulas with values feature", as shown in this video: ua-cam.com/video/rw5Gn0mIHsA/v-deo.html
Hi sorry for the late reply. - Temperature is creativity. If it's close to 0, then GPT will be more "straightforward" or "boring". If it's close to 1, it will be very creative, but could also be off-topic. - Model is which OpenAI model you use. But you shouldn't worry too much about it, as the default, text-davinci-003 is by far the best (for now). - MaxTokens is the total size of the question to GPT (prompt) and the GPT answer. It cannot go above 4000 for text-davinci-003. 10 tokens is roughly equal to 7 words in English, and 5 words in other languages.
Thank you so much for this extension, but It's not working for me at the moment, I'm a ChatGPT Plus user, could you help me with that. Google sheets just keeps saying unknown function and I have enabled Chat GPT Functions
Hello Omar. The ChatGPT Plus subscription doesn't cover use of the ChatGPT API. Please send me more information about your error here and I will help you: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
@@gptforwork Nevermind, my "easy fix" solution was to create a new spreadsheet, I think you need to be the first and only owner of the spreadsheet for it to work. Thanks for this amazing work, gonna check all the yt videos to learn more about the tool.
Hey Talarian team - this is great. I've been loving your GPT for Sheets add-on over the last few days, but I noticed it was recently removed from Google Workspace Marketplace...is it coming back or is it gone for good?
Hi Fabrizzio, sorry it was down for a bit, as I replied by email, it's back up! The downtime was so that we could push the Google Docs integration. (Unfortunately Google doesn't make it possible to add an integration to an existing without downtime). I hope it didn't affect you too much!
its a dope to see it working, Im having problem its not allowing me to set the api key, keeps giving the (line 53) error message, any suggestion on how to confirm the api is set after entering it into the api key into the set api key section?
Hello! To make sure your results don't get altered and prevent unexpected costs or loss of data, you must convert your GPT formulas to static values. You can directly replace formulas from the sidebar, either in a selected number of cells or in the entire spreadsheet if you're satisfied with all the results. You can find more information here: gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/replace-formulas-with-results
I've tried this on two separate google/openAI accounts, and waited 24 hours before trying again. Every time I enter the API Key, even though the checker says it's valid, it immediately forgets the API Key and I am greeted with the "Error: Please set OpenAI API key in Extensions menu->GPT for Sheets™ and Docs™ (line 752)." I cannot get the extension to 'remember' my API key.
I'm sorry about this. It is very likely due to the fact that you're using multiple Google accounts in the same browser session. Could you please: 1. follow this procedure to create a dedicated Chrome profile: support.yet-another-mail-merge.com/hc/en-us/articles/7120494681116 2. create a new spreadsheet: sheet.new 3. Set up your API key in this new spreadsheet 4. Try a GPT() function again
@@gptforwork Okay, it's solved. I logged out of all my google accounts and it eventually worked but not right away. So it was either that I was in two accounts at once or that the API took abnormally long to validate. Thanks so much for the infinite value this tool provides, the detailed response, and most of all keeping it free :)
I decided to try this method, instead of going on the openai website. I think this is a great idea, however your tutorial video is a bit fast, you make a couple of mistakes which interrupts the lesson and confuses the user. Can you please make another tutorial for people who don't have the same coding experience as you do. A more detailed video on how to write the syntax or how to think about writing prompts for GPT since there is a difference on the sheets extensions versus the openai browser version.
Hello Alejo, totally I will make a slower-paced video. The first video was made before I knew this tool would have a lot of interest, so it is indeed not the best quality. I'll do it by the end of the week.
@@gptforwork Woooo! I'll be ready! I'm using ChatGPT to help me market and organize my used car dealership it would be awesome if you incorporated a used car dealership business instead of an ice cream shop. If you're not able to, thats okay. I appreciate your help!
what is wrong with this method, that GPT can not remember previous propt given! each time, when you send querry via task in cell, this is like new chat with gpt so he can not learn at all which is kinda bad solution is it possible to change it to one chat with bot via multiple teaks in cells, worksheets within the sassion and reset chat to new one when needed?
Hi Krzysztof, I explain how to remember the previous prompt in this video: ua-cam.com/video/-LxO07NOdyU/v-deo.html ChatGPT works with a context window, so you have to provide the context. We could at some point introduce a feature to remember context more magically. I would really like to know more about your use-case for that, if you can write me through this form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Dear Talarian team, what about the data protection? Is my data that I have in the sheet visible to Talarian company ? What data is accessible for you and which you do not have access to? Thank you.
Hello. The add-on itself needs access to the spreadsheet in order to work.Google unfortunately doesn't provide us with a way to access only a subset of the spreadsheet. We however to not read nor store any of the data that is not used within the GPT functions. For more information, please refer to our privacy policy and data processing agreements, both available on our website: talarian.io
Amazing video!! But, I'm getting: "Exceeded maximum execution time (line 0)." many times for using the function =GPT(A1:A2,,1).. My purpose is to automate the writing of product descriptions like this. I have ChatGPT plus, but I think the error is more Google Sheets related.. Any advice?
Hi, this unfortunately happens frequently during US peak hours. We are working on a perennial solution that should be out in 3 weeks. In the meantime, here's what you can do: - simply retry, it usually works after a few retries - set up a paid account on platform.openai.com if you haven't yet (this is unrelated to ChatGPT Plus, which doesn't cover API usage). We've noticed better response times on paid accounts (though it takes 48 hours to get full rate limits) as per platform.openai.com/docs/guides/rate-limits/overview - use it outside of US peak hours for better chances - use another model (such as text-davinci-003 or text-curie-001)
Hello, this is a Google multi-acocunt issue. Please refer to this troubleshooting page: gptforwork.com/troubleshooting/errors#ef6b5004bb9f4928ad585d49b574db03
hello, we have created a pricing calculator for you to estimate your costs: gptforwork.com/resources/openai-api-pricing-calculator as you can see, for a small number of requests, it is in fact quite affordable.
@@gptforwork just create formulas just like how you can do in Excel and google sheets but all you would say is do xyz and it will create the sheet for you with all formulas and inputs there for you with the right calculations
Hi Alex, usually it takes some time for the API key to become active. See the comment from Andrew Powers. I can only ask you to be patient once you've generated your key and try again after a few hours.
@@BloggingwithSashaLassey Hi, usually it takes some time for the API key to become active. See the comment from Andrew Powers. I can only ask you to be patient once you've generated your key and try again after a few hours.
Is anyone else getting the following error: OpenAI error: HTTP code: 429 Message: You exceeded your current quota, please check your plan and billing details. (line 1141).
Just replying so others can see: - Stephen's problem was his OpenAI account was not activated or his free trial was over - setting up a payment method in the OpenAI dashboard will fix this issue.
Hi everyone,
- there is a new version of this video here, which is much better: ua-cam.com/video/lnQPAWWmaKk/v-deo.html
- if you're having trouble, please review the troubleshooting section of this page: gptforwork.com/troubleshooting/errors
- if it doesn't answer your question, fill out the following form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Thank you!
Zooming in a little will help a lot on this tutorial ! I had to do a full screen expansion on my external monitor to see it.
Indeed, this was really an experimental video, I will remake it better very soon.
new version here which is much better: ua-cam.com/video/lnQPAWWmaKk/v-deo.html
Here's a brief overview of the terms you mentioned:
1. **Prompt**: This is the initial input text you provide to the model. It's essentially a question or a statement that guides the model on what you want it to generate. The model uses this prompt as a starting point and continues the text in a way that's consistent with the prompt's context and style.
2. **Value**: This term is not commonly used as a standalone parameter in the context of GPT settings. It might refer to the specific value of another parameter, or possibly it's being used in a specific application's context. If you meant "values" in the sense of data provided to the model, it would still typically be part of the "prompt".
3. **Temperature**: This controls the randomness of the output generated by the model. A higher temperature results in more random outputs, which can be useful for generating creative or varied text. A lower temperature makes the model's outputs more deterministic and repetitive. A temperature close to 0 makes the model almost always choose the most likely next word, while a higher temperature (closer to 1) encourages diversity in the generated text.
4. **Model**: This refers to the specific version or configuration of the GPT model you are using. Different versions of the model (like GPT-3, GPT-4, etc.) have been trained on different datasets or for different lengths of time, which affects their performance and capabilities. Within a particular version, there might also be different sizes of the model (measured in the number of parameters) that offer a trade-off between computational cost and the ability to generate high-quality text.
5. **Max Tokens**: This parameter specifies the maximum length of the generated text measured in tokens. A token can be a word or part of a word, so the actual length in words can vary. Setting a higher max tokens limit allows the model to generate longer responses, while a lower limit restricts it to shorter texts.
Awesome. You are a savior man ....
Great and easy to follow video! Fab AI to use in marketing - thanks Talarian!
Glad you enjoyed it!
Excellent! Is it possible to use this with a database and ask gpt to create automatic graphics and get some insights from that data?
Hi Matias, depending on what database you're talking about, and if your data is not too large, you can import it to Google Sheets with our other product awesome-table.com/connectors
You'll then be able to use GPT for Sheets and make charts on the spreadsheet.
Let me know if that helps!
Pretty cool! Is there a way to include training prompts?
what do you mean by training prompts exactly?
Wow this will help tremendously with creating content for my ig/facebook
thanks for the feedback!
Hi Stan, I made some really amazing spreadsheets for my company using your videos and I have been asked to demo for the CEO and the board. The now is that most of the models are timing out (3.5 turbo, for example)....so I'm now having to use davinci in order to get a response but it's so inaccurate compared to a few weeks ago, so i don't feel like I can show it off. Do you have any tips to solve this?
Hi Michael, did you set up a paid method on openai? This should make 3.5-turbo fast enough, as per this chart: gptforwork.com/tools/openai-api-response-time-tracker
Shoot me an email, I'll be happy to help
@@gptforwork You are a hero, Stan! Didn't realise I needed a pay as you go in addition to the gpt-plus account
@@michaellardner7999 unfortunately OpenAI makes that extremely confusing
Hey there! Great video loving the plug-in.
Do you happen to know the function code of this plug-in so I can combine it with "=subtotal" functions?
Trying to use Chat GPT to summarize filtered data but need the subtotal function... I believe. Any guidance would be amazing!
Hi Spencer, sent you an email, I think I found the solution with GPT_CREATE_PROMPT and FILTER
Was looking for this for 4 days now thank you so much
awesome! Let me know what you want to do with it.
Great! Thank you! Can you tell me how to bypass the limit on the number of characters? I set the "write an article 500 words" value, but it only fills part of it.
Hello, you need to increase the max_tokens parameter. See this video: ua-cam.com/video/82Fc9Olldnw/v-deo.html
@@gptforwork thanks! Right now watching it!
Thank you very much! If I get 15 answers generated in the A1 Cell how can fragment each of the 15 inside A1 so that each gets their own row from 1-15 in the A column? I'm stuck on figuring this out! Thank you in advance to all kind enough to reach out!
Hi, use GPT_LIST for a single column or GPT_TABLE if you want multiple columns
Is there a similar Addin but for Microsoft Excel?
Stay tuned :)
can you please paste the formula you used & maybe put it in the description too?
(the long complicated one that you dragged down)
Hi Harry, sorry for the late response, could you please point me to the timestamp you're talking about?
@@gptforwork 9.50 ish - also what do the value & model bits mean?
Good content and well explain, so useful thank you very much!
thank you!
While trying to install it I keep getting "Bad Request. Error 400." Can't install.
Sorry about this. Could you please fill out the support form and include a screenshot? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Thank you so much! It's also great for idea generation!
Glad you think so!
I have a big conversation in my ChatGPT account, also input things to learn how i want my answers. Can I access that context and use it in Sheet? And how much am I limited to, because in ChatGPT itself there is a limitation of a number of words.
Hello! We would be happy to help you with your particular use case. Please contact the support to give more details about what you want to do: support.gptforwork.com/hc/en-us/requests/new
This is amazing, thank you!
You're very welcome!
I have 2 questions :
- How do you copy or import the results other than the formula? I am trying to find how to get the results instead of the =gpt(,,,,). When I get the paragraph I want and click on the cell, the paragraph disappears and shows the formula, which is normal but how do we keep our results « printed »?
- Do you know why it’s not showing the whole results ? The paragraph is cut at half the lines, like someone is reading something and just stops in the middle of the phrase.
Request : can you make an « import result as text » formula and a translation formula?
Thank you!
Hi there,
I think I have answers to all your questions :)
- we have a "replace formulas" feature: gptforwork.com/gpt-for-sheets/prevent-formula-recalculation
- if I understand correctly, you need to increase the max_tokens parameter: ua-cam.com/video/82Fc9Olldnw/v-deo.html
- we cannot "import as text" from a formula, but we are working on something else that will let you do that
- you can already use GPT_TRANSLATE :) ua-cam.com/video/wQUJWoOmT8Q/v-deo.html
Hope that helps
Had to use a magnifying glass to see it. 👀
Still good video! 😊
Sorry, watch the new version here, it's much better: ua-cam.com/video/lnQPAWWmaKk/v-deo.html
Hi Talarian, when you use the Sheets add-on in the extensions does it pull from GPT3 or 3.5, like ChatGPT?
Hi Lisa, we offer users all models that are publicly available from the OpenAI API: beta.openai.com/docs/models/overview
Great idea @talariansoftware. I managed to complete the setup and created prompts yesterday. I noticed that the results changed when I logged back in today. Is that by design eg the API generates a new result to the original prompt?
Hi Barry, this is how custom function in Google Sheets work: they are recalculated every time the spreadsheet is opened or the arguments change.
We have implemented basic caching so that no recalculation occurs during 6 hours if arguments don't change.
But if you really want to freeze the results, you need to use our "Replace GPT formulas with values feature", as shown in this video: ua-cam.com/video/rw5Gn0mIHsA/v-deo.html
What is Temperature,Model & MaxTokens
Can you please explain
Hi sorry for the late reply.
- Temperature is creativity. If it's close to 0, then GPT will be more "straightforward" or "boring". If it's close to 1, it will be very creative, but could also be off-topic.
- Model is which OpenAI model you use. But you shouldn't worry too much about it, as the default, text-davinci-003 is by far the best (for now).
- MaxTokens is the total size of the question to GPT (prompt) and the GPT answer. It cannot go above 4000 for text-davinci-003. 10 tokens is roughly equal to 7 words in English, and 5 words in other languages.
@@gptforwork Thanks a Lot..It helps
Thank you so much for this extension, but It's not working for me at the moment, I'm a ChatGPT Plus user, could you help me with that.
Google sheets just keeps saying unknown function and I have enabled Chat GPT Functions
Hello Omar. The ChatGPT Plus subscription doesn't cover use of the ChatGPT API.
Please send me more information about your error here and I will help you: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
@@gptforwork Nevermind, my "easy fix" solution was to create a new spreadsheet, I think you need to be the first and only owner of the spreadsheet for it to work. Thanks for this amazing work, gonna check all the yt videos to learn more about the tool.
@@doypaz yes indeed, you need to be the spreadsheet creator to set up the API key.
Hey Talarian team - this is great. I've been loving your GPT for Sheets add-on over the last few days, but I noticed it was recently removed from Google Workspace Marketplace...is it coming back or is it gone for good?
Hi Fabrizzio, sorry it was down for a bit, as I replied by email, it's back up! The downtime was so that we could push the Google Docs integration. (Unfortunately Google doesn't make it possible to add an integration to an existing without downtime). I hope it didn't affect you too much!
Wonderful!
its a dope to see it working, Im having problem its not allowing me to set the api key, keeps giving the (line 53) error message, any suggestion on how to confirm the api is set after entering it into the api key into the set api key section?
Well it started to work maybe just need to wait?
@@andrewpowers3740 yes exactly, it can take some time for the API key to become active
Question is, does it save in the sheets and never get altered again by the addon?
Hello! To make sure your results don't get altered and prevent unexpected costs or loss of data, you must convert your GPT formulas to static values. You can directly replace formulas from the sidebar, either in a selected number of cells or in the entire spreadsheet if you're satisfied with all the results. You can find more information here: gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/replace-formulas-with-results
great job
thank you!
I did the setup but I’m getting the “Error: Please set OpenAI API key in Addon menu ->GPT for Sheets (line53)”
hello Omar, please submit this form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform with more details
I've tried this on two separate google/openAI accounts, and waited 24 hours before trying again. Every time I enter the API Key, even though the checker says it's valid, it immediately forgets the API Key and I am greeted with the "Error: Please set OpenAI API key in Extensions menu->GPT for Sheets™ and Docs™ (line 752)." I cannot get the extension to 'remember' my API key.
I'm sorry about this. It is very likely due to the fact that you're using multiple Google accounts in the same browser session.
Could you please:
1. follow this procedure to create a dedicated Chrome profile: support.yet-another-mail-merge.com/hc/en-us/articles/7120494681116
2. create a new spreadsheet: sheet.new
3. Set up your API key in this new spreadsheet
4. Try a GPT() function again
@@gptforwork Okay, it's solved. I logged out of all my google accounts and it eventually worked but not right away. So it was either that I was in two accounts at once or that the API took abnormally long to validate. Thanks so much for the infinite value this tool provides, the detailed response, and most of all keeping it free :)
I decided to try this method, instead of going on the openai website. I think this is a great idea, however your tutorial video is a bit fast, you make a couple of mistakes which interrupts the lesson and confuses the user. Can you please make another tutorial for people who don't have the same coding experience as you do. A more detailed video on how to write the syntax or how to think about writing prompts for GPT since there is a difference on the sheets extensions versus the openai browser version.
Hello Alejo, totally I will make a slower-paced video. The first video was made before I knew this tool would have a lot of interest, so it is indeed not the best quality. I'll do it by the end of the week.
@@gptforwork Woooo! I'll be ready! I'm using ChatGPT to help me market and organize my used car dealership it would be awesome if you incorporated a used car dealership business instead of an ice cream shop. If you're not able to, thats okay. I appreciate your help!
Hi sorry it took a while, but I finally created a new intro video which also contains new features: ua-cam.com/video/lnQPAWWmaKk/v-deo.html
what is wrong with this method, that GPT can not remember previous propt given!
each time, when you send querry via task in cell, this is like new chat with gpt
so he can not learn at all
which is kinda bad solution
is it possible to change it to one chat with bot via multiple teaks in cells, worksheets within the sassion and reset chat to new one when needed?
Hi Krzysztof,
I explain how to remember the previous prompt in this video: ua-cam.com/video/-LxO07NOdyU/v-deo.html
ChatGPT works with a context window, so you have to provide the context.
We could at some point introduce a feature to remember context more magically. I would really like to know more about your use-case for that, if you can write me through this form: docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Dear Talarian team, what about the data protection? Is my data that I have in the sheet visible to Talarian company ? What data is accessible for you and which you do not have access to? Thank you.
Hello. The add-on itself needs access to the spreadsheet in order to work.Google unfortunately doesn't provide us with a way to access only a subset of the spreadsheet. We however to not read nor store any of the data that is not used within the GPT functions. For more information, please refer to our privacy policy and data processing agreements, both available on our website: talarian.io
Amazing video!! But, I'm getting: "Exceeded maximum execution time (line 0)." many times for using the function =GPT(A1:A2,,1).. My purpose is to automate the writing of product descriptions like this. I have ChatGPT plus, but I think the error is more Google Sheets related.. Any advice?
Hi, this unfortunately happens frequently during US peak hours.
We are working on a perennial solution that should be out in 3 weeks. In the meantime, here's what you can do:
- simply retry, it usually works after a few retries
- set up a paid account on platform.openai.com if you haven't yet (this is unrelated to ChatGPT Plus, which doesn't cover API usage). We've noticed better response times on paid accounts (though it takes 48 hours to get full rate limits) as per platform.openai.com/docs/guides/rate-limits/overview
- use it outside of US peak hours for better chances
- use another model (such as text-davinci-003 or text-curie-001)
@@gptforwork Thanks for the response :) Appriciated! You doing a great job! Whole ChatGPT is down at the moment, so let's see later on :)
I can use the chatGPT platform but I can't use the GPT in Sheets. Not sure about the quota then.
Hello, could you fill this form? docs.google.com/forms/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
Error: ScriptError: Authorization is required to perform that action.
Hello, this is a Google multi-acocunt issue. Please refer to this troubleshooting page: gptforwork.com/troubleshooting/errors#ef6b5004bb9f4928ad585d49b574db03
I'm using gpt(), but the chatgpt api cost seems to be too high. Why is this and what can I do to fix it?
hello, we have created a pricing calculator for you to estimate your costs: gptforwork.com/resources/openai-api-pricing-calculator
as you can see, for a small number of requests, it is in fact quite affordable.
Can this do a lot of math and formulas for calculating statics etc
Hi, currently it cannot do any math, but soon it will.
@@gptforwork ok how many formula and math will it be able to do?
@@skillfulactor09 that is a difficult question to answer :) what would you like it to do?
@@gptforwork just create formulas just like how you can do in Excel and google sheets but all you would say is do xyz and it will create the sheet for you with all formulas and inputs there for you with the right calculations
@@skillfulactor09 yes we will release this soon
I keep getting Error: Please set OpenAI API key in Addon menu->GPT for Sheets™ (line 53).
I have made new keys and imported quite a few times.
I'm also getting the same thing over and over. Maybe just a glitch from too many requests?
Hi Alex, usually it takes some time for the API key to become active. See the comment from Andrew Powers. I can only ask you to be patient once you've generated your key and try again after a few hours.
@@BloggingwithSashaLassey Hi, usually it takes some time for the API key to become active. See the comment from Andrew Powers. I can only ask you to be patient once you've generated your key and try again after a few hours.
The russian translation is good. But it reads weird, the context is about sight. You can't translate that literaly for caffee's ad.
I don't know much russian, so will trust you on this!
Is anyone else getting the following error: OpenAI error: HTTP code: 429 Message: You exceeded your current quota, please check your plan and billing details. (line 1141).
Just replying so others can see:
- Stephen's problem was his OpenAI account was not activated or his free trial was over
- setting up a payment method in the OpenAI dashboard will fix this issue.
it was 100 downloads a month ago and it'ss now at 300K downloads lmao
thank you for the video
and we're just getting started!
Why did you put $ sign on 7:50?
I think that was so that it would translate? That's what happened when I did it.
the $ is to fix the absolute position of the argument cell in the formula. This way I can drag it without the cells shifting.
GPT gave an error. Is that still works?
yes it still works :) please refer to this guide to fix: gptforwork.com/troubleshooting/errors
How much does that token usage cost for each request?
Hi, it really depends on the number of words in your request. A 10 word question will cost on average $0.0006
its paid openai ?
Hi, yes you need to pay openai for the API consumption.
The answer that visible is short.
not sure I understand?
I really like Gugl Shits
mi tu
Hi! Need help can you please contact me? Sheets, cells, combination, etc.
hi, please submit the support form
@@gptforwork where is it??
Hi, you can find it here : forms.gle/eJhwzcwiSnRiadHB6