Hey, for what it's worth, I'm just some random dude on the Internet, but I wanted to let you know that your content is really good. You have a good style. You're easy to listen to, and it's easy to follow. Thanks for putting this together and sharing it.
I know this is not actually the point, but I love how it uses 'revolutionising' even though you prompted for the perspective of a baseball coach (which is an American sport).
I Sub'd & 👍. Cause you're the 1st YTuber who didn't Sugarcoat the fact you need to spend $$ to use GPT-3. Many countless YTbrs doesn't even mentioned this fact as they're all going for clickBait.
Before I go any further: "I wasn't popular in high school, so i need your approval to keep going"....had me in stitches! You got my like 👍 Now DANCE MONKEY to earn my sub!!
Great video! Endless possibilities with this.. Any security concerns with providing my API code to this script? For example, can the author of the script see it or export it?
i find this very useful, if i update my spread sheet weekly and ask AI to output an analysis of the weekly data and also make a 5-week analysis along with a worded description and graphs.
You don't strike me as a dumb person, but I wanted to at least mention there is no blurring in this video on secret keys and while you personally may not be using those keys now, I think it least worth a mention to the unfamiliar with code and these keys to NEVER share them with anyone. Great video!
This is great, I thought I was missing something. So much better than using "API connector" for this purpose, which just glitches out with the formatting.
Great video. A quick question tho. I'm confused as to why you would do this? Why would you pay for those functions when you get them for free at the openAI homepage? I might have missed it, but those examples you provided aren't any different from doing it at the homepage.
Depends on your use case. Once it's in a spreadsheet it's much easier to save and work with. If you're looking to make it part of your operations , using the homepage isn't very scalable . In an upcoming video I'll show how to use it as part of a Content generation work flow. It was originally going to be one video, but I realized the setup explanation should stand on its own.
Thanks, it worked. Is it possible to give a prompt to read the cell in Google Sheets and get an out come. For an example read the keyword and suggest blog topics ...
Doing it in a word processor is more complicated. It's harder to Target where the copy is going to go. In my next video I'll show you how to export the sheet data to a doc for editing
I am here to give you the approval you so desperately require. Awesome video, very useful. It would be cool to take it one step further and be able to make up the prompt out of several cells for keyword > title > meta > content outline creation. When I figure it out Ill let you know.
Thank you 🙏 my glass is one drop closer to full 🙃 Next video is on generating a draft of a blog post and exporting it to a word doc, should be out later this week
Nice, very good explanation, you rock, thanks. now, same comment as one of the comment I have read, not sure how to use this, i would rather try to connect my spreadsheet data and give me insights and create additional info, or maybe do infography from it.
Hi, thank for the video, It does help me save time. However, sometimes there is word limitation in each response, so I have to type "continue" to get the full answer. How can I access to the "continue" function in this? Thank a lots
There is a word limitation, you can try increasing the number of max tokens in you App Script. It's currently set to 200. It will increase the cost. The other thing you could try would be using multiple prompts for the different sections of text.
hello, i have try it but if the request is to long it give an error "Exceeded maximum execution time (regel 0)." Is it possible to change the 30 sec Custom function runtime to 200 sec?
I'm not sure if you can change the runtime. I got around this error by splitting my prompts into smaller pieces. Trying to generate too much text would cause it to time out.
This works amazing and it was easy to set up! Only issue i'm having right now is Google sheets recalculates custom formulas every time you open the spreadsheet, so it runs the code every time, meaning the content is lost and rewritten... anyone found a fix for that? if i have 100s of rows/ 1000s of cells, it will run the API ever time, meaning it gets expensive fast!
You can create a cell with a checkbox to use as an on/off toggle. 1) Pick a cell, I'll use B2 as an example. 2) Go to INSERT > TICK BOX in the menue at the top. 3) Now put an IF statement before you call the AI function: =IF($B$2, AI("Write a short title for an article about beaches")) If the box isn't checked, the AI won't run.
@@RockTrembath This is super helpful man thank you! I would love to see an update video on using GPT turbo ... tried to figure out how to update my app script to call the new gpt api, but couldn't figure it out.. i added the new model, new post URL, but till broken!
Is there a way to modify this script to trigger off of simply entering data into a cell? For instance, I enter a questionsinto any call in column A and the answer is automatically posted in the same row in column b?
Yes, you can reference your input cell inside of the AI function. For example the formula "=AI(C2, 1)" would take the input of C2 as the string to pass the API
@@RockTrembath what about a whole column, so if I wanted to load 50 questions in cells A1 - A50 it would cycle through the questions and enter the responses into the cells C1-C50 for instance? Is that possible? Or just a column with no range so you could just continually submit questions endlessly? is that possible?
@@CreateAI-nr7mw Well, it's in a spreadsheet, so if you put them all in rows 1-50, you can just just fill-down the formula column from 1-50 and it will provide answers for each in the accompanying cell.
Can you show how to do this with say a Jupiter Notebook or maybe to build a google Colab? GPT is excellent writing code, but copying and pasting back and forth slows things down.
The script may need to be authorized. In the app script window press the Run button at the top of the toolbar, if it's not authorized it will have you give permission for it to work within your sheet.
How do I get the prompt to reference a cell. Such as =ai(write a 150 description about cell A2 that includes X Name, .4) that could be dragged down that would reference A3, A4, and so on? Also, how do we reference 'model' in the formula? In your example you stopped at temperature in the formula.
You don't need to change the model, it's already configured. You can join strings by using the & plus the cell reference. It's similar to other Sheets functions. =AI("Write about "&B2&".", 1)
Because that's is the proper use of the formula. I believe it is because it is a boolean you need to tell to return true, but if someone else knows, please chime in
I think the results vary in different languages. According to Open AI this model is optimized for english: help.openai.com/en/articles/6742369-how-do-i-use-the-openai-api-in-different-languages
There is one called rows you could look at. It's debatable if you'll find it any easier of you find this difficult to follow, but you can check it out at rows.com
I Amazin video, thanks!! But I am getting this error: "Sintaxis error: Missing ) after formal parameters., line: 14" I tried everything but it is not working
@@RockTrembath - for some reason it's not working for me. I even went as far as to copy the prompt you sent to @novel and then wrote out the prompt and still nothing. Can you help me with this?
How can this be used with looking at DATA? I can't think of many people who create tweets in Excel, seems like this use case is more for people just want to churn out AI generated content on blast.
It's a natural language algorithm, so data analysis isn't really it's primary function. You can create all types of content I'll be going over it in future videos this is just the setup step.
I don't know about google spreadsheet, but I used it to make some code for r language in RStudio, it made some graphs based on some conditions I specified, then I asked for it to print a sentence if a condition is met or not. The codes I did manually were not evenly close to how efficient AI code was.
Midjourney is currently only available through their Discord connection. I did an info to it over here if you're interested ua-cam.com/video/-JhbTxCQCAQ/v-deo.html
hello and thank you very much for your answer, I'm having trouble with your method since I don't know anything about code, I follow the method of a tutorial to do my prompts directly in a Google sheet and get the answers from chatgpt in it, simply by copying and pasting the chatgpt API key, 6 digits, and pasting it into a Google sheet module, I'm not sure I understood your video well since I speak English badly, I'm French, in any case what you do is the same thing? I mean is it to do the prompts directly in a google sheet and get the answers from chatgpt in the google sheet? anyway now i would like to do something a bit different, could I send you an email? and again thank you very much for your answer
My french is not great - but... Oui. Si vous suivez les étapes de cette vidéo, le code vous permet de mettre une prompt chatgpt dans la feuille et de recevoir une réponse dans la même cell. La commande à utiliser dans votre feuille est : =AI("Votre invite pour ChatGPT") La réponse sera retournée dans la cellule dans laquelle vous entrez la formule.
@@RockTrembath bonjour , dans votre dernier commentaire vous m'expliquer comment faire un prompt dans une cellule de mon Google sheet et obtenir la réponse dans une autre cellule de mon Google sheet ? mais ça c'est ce que vous expliquez dans votre vidéo ? je me demandais si je pouvais faire la même chose avec une image? je veux dire dans la colonne à je met toutes mes images ( en a1, a2... ) puis je fais mon prompt en b1 ( décris-moi l'image que tu vois en a1) est-ce que tu comprends ce que je veux dire ?
@@SD-rg5mj Oui. Je comprends. Ce script utilise le modèle GPT qui crée des réponses textuelles. Pour les images, vous devrez utiliser le modèle DALL-E. Cette vidéo n'est donc pas ce que vous recherchez. J'ai une vidéo sur l'utilisation de Midjourney pour créer des images qui peuvent aider, mais c'est un système différent. ua-cam.com/video/-JhbTxCQCAQ/v-deo.html
The function included in this script may not quite fit that use case. It could get you part of the way. You could prompt it with something like "what is the population of Canada? create a two column table with data split by age group" and it will return data, but it will be formatted in a single cell like this: "| Age Group | Population | |----------|------------| | 0-14 | 8,945,869 | | 15-64 | 22,890,073 | | 65+ | 5,919,737 | | Total | 37,755,679 |" You'd have to Text-to-columns on the " | " and build your chart from there. So it will take more code than what's provided. It's not absolute magic.
It's really up to you to experiment, it's quite versatile. You can check out my vid on generating blog posts if you'd like some ideas : ua-cam.com/video/A6QPnrYDZ-4/v-deo.html
ChatGPT will make updates to 2023, and begin a pricing model to charge for it's use. They are in the process of growing a global dependency on it to get everyone, from businesses to individuals, completely hooked. Initially those hooked on it will be for profit, but it will end with becoming hooked on it for survival.
Did you follow the steps to add the script? The function is contained in the App Script. In some accounts, You will need to give the script permission to run.
@@nexeatsimple640 That is very strange. You're the first person to have this issue. If you saved the App Script to your doc it should recognize the function. You hit the 'Save' button in the App Script window? That's the only other thing I can think of.
I think you can extend it by changing the max tokens length in the App Script. It's currently 200. Keep in mind it will put the cost up. Reference : help.openai.com/en/articles/5072518-controlling-the-length-of-completions You can also break you jobs out into multiple steps. Downside is you need multiple unique prompts.
The ChatGPT API is now available! Update your App Script for improved results. Learn how here: ua-cam.com/video/Z0sL2io9CEc/v-deo.html
Hey, for what it's worth, I'm just some random dude on the Internet, but I wanted to let you know that your content is really good. You have a good style. You're easy to listen to, and it's easy to follow. Thanks for putting this together and sharing it.
Hey! Thanks Chris - that means alot. Appreciate you letting me know you found it helpful 🙂
I know this is not actually the point, but I love how it uses 'revolutionising' even though you prompted for the perspective of a baseball coach (which is an American sport).
Great stuff. I tried to follow other's directions to make this happen. They failed. You succeeded! Thank you.
I Sub'd & 👍. Cause you're the 1st YTuber who didn't Sugarcoat the fact you need to spend $$ to use GPT-3.
Many countless YTbrs doesn't even mentioned this fact as they're all going for clickBait.
Before I go any further: "I wasn't popular in high school, so i need your approval to keep going"....had me in stitches! You got my like 👍 Now DANCE MONKEY to earn my sub!!
Well… that was amazing! Thanks for the simplicity of your explanations and taking time to put this up.
Very clear and simple instructions for non-coders.
Great video! Endless possibilities with this.. Any security concerns with providing my API code to this script? For example, can the author of the script see it or export it?
No. Your keys are local to your sheets, and are only used in calling openai. If you share the sheet with others, your key will be available to them.
@@RockTrembath Awesome, thanks so much! I subscribed to your channel - looking forward to seeing your next videos!
i find this very useful, if i update my spread sheet weekly and ask AI to output an analysis of the weekly data and also make a 5-week analysis along with a worded description and graphs.
You don't strike me as a dumb person, but I wanted to at least mention there is no blurring in this video on secret keys and while you personally may not be using those keys now, I think it least worth a mention to the unfamiliar with code and these keys to NEVER share them with anyone. Great video!
Excellent observation!
I deleted the one used in this video, but that is an excellent point for others to note 🙂
It also says that on the page that gives you the keys. Not to share them 😉 Should be common knowledge.
@@cjenkinsiv common sense isn’t always common
McDonald's was sued for having hot coffee 🤷🏼♀️
This is great, I thought I was missing something. So much better than using "API connector" for this purpose, which just glitches out with the formatting.
Great video. A quick question tho. I'm confused as to why you would do this? Why would you pay for those functions when you get them for free at the openAI homepage? I might have missed it, but those examples you provided aren't any different from doing it at the homepage.
Depends on your use case. Once it's in a spreadsheet it's much easier to save and work with. If you're looking to make it part of your operations , using the homepage isn't very scalable .
In an upcoming video I'll show how to use it as part of a Content generation work flow. It was originally going to be one video, but I realized the setup explanation should stand on its own.
@@RockTrembath Alright, fair enough!
Dude, I can think of a thousand usage. Imaaagination.
@@John-jt3dn give me 10 from that thousand.
@@virgiliustancu9293 You must think in terms of numbers not texts.
Thanks, it worked. Is it possible to give a prompt to read the cell in Google Sheets and get an out come. For an example read the keyword and suggest blog topics ...
Yes. I have a video about this coming out next. You can replace the prompt with a cell reference. =AI(B2, 1)
Helpful instructions. Thanks. I look forward to future videos.
That's GREAT but... can you improve the language to gpt-3.5-turbo ?
I CAN. Video just dropped an hour ago: ua-cam.com/video/Z0sL2io9CEc/v-deo.html
PICKLE SURPRISE !!! hahaha almost fell out of my chair laughing
Thousands of views and you're the first one to say anything lol
Glad it made you smile 🙂
@@RockTrembath I found that hilarious / horrifying commercial on FBE. UA-camrs react to WTF did I just watch
thank U
Can you do more vids of having your own private AI and using data sets to train it to do different specialized analysis/use cases?
My upcoming ones are more around using this in a content production flow, but I will consider this as well.
Very cool, and thanks for sharing. Could you do this in Google Docs, so Chat GPT works in the word processor?
Doing it in a word processor is more complicated. It's harder to Target where the copy is going to go. In my next video I'll show you how to export the sheet data to a doc for editing
Why are you inserting "1" after the prompt? Mine works without inserting the number "1". Thanks!
Excellent sir!! Nice content!
Thank you kindly!
I am here to give you the approval you so desperately require. Awesome video, very useful. It would be cool to take it one step further and be able to make up the prompt out of several cells for keyword > title > meta > content outline creation. When I figure it out Ill let you know.
Thank you 🙏
my glass is one drop closer to full 🙃
Next video is on generating a draft of a blog post and exporting it to a word doc, should be out later this week
Content will start to be generated at a furious pace, I wonder what it will lead to?
Nice, very good explanation, you rock, thanks. now, same comment as one of the comment I have read, not sure how to use this, i would rather try to connect my spreadsheet data and give me insights and create additional info, or maybe do infography from it.
Very useful. Thanks!
Is it possible to replace davinci model with text-curie-001? If yes, how?
Change the model name in the AI function to 'text-currie-001'
Thanks Rock! Learning everyday ;)
Whoaaaa! Thanks a lot!
I learned something really cool today!
Thank you.
Hi, thank for the video, It does help me save time. However, sometimes there is word limitation in each response, so I have to type "continue" to get the full answer. How can I access to the "continue" function in this? Thank a lots
There is a word limitation, you can try increasing the number of max tokens in you App Script. It's currently set to 200. It will increase the cost.
The other thing you could try would be using multiple prompts for the different sections of text.
@@RockTrembath sure, thank for the suggestion, I'm still working with the code to create the "continue" function to get all the answer fully,
Cool... thank you!
thank you so much,
hello, i have try it but if the request is to long it give an error "Exceeded maximum execution time (regel 0)." Is it possible to change the 30 sec Custom function runtime to 200 sec?
I'm not sure if you can change the runtime. I got around this error by splitting my prompts into smaller pieces. Trying to generate too much text would cause it to time out.
Awesome content!!
This works amazing and it was easy to set up! Only issue i'm having right now is Google sheets recalculates custom formulas every time you open the spreadsheet, so it runs the code every time, meaning the content is lost and rewritten... anyone found a fix for that? if i have 100s of rows/ 1000s of cells, it will run the API ever time, meaning it gets expensive fast!
You can create a cell with a checkbox to use as an on/off toggle.
1) Pick a cell, I'll use B2 as an example.
2) Go to INSERT > TICK BOX in the menue at the top.
3) Now put an IF statement before you call the AI function:
=IF($B$2, AI("Write a short title for an article about beaches"))
If the box isn't checked, the AI won't run.
@@RockTrembath awesome man! I will try that ❤️
There is an example of how this is done in my latest vid: ua-cam.com/video/V5_T0c17VaI/v-deo.html
@@RockTrembath This is super helpful man thank you! I would love to see an update video on using GPT turbo ... tried to figure out how to update my app script to call the new gpt api, but couldn't figure it out.. i added the new model, new post URL, but till broken!
Since it uses the Chat API end point, the request needs to be formatted differently. I just did a proof of concept. Will put it out soon :)
Well done Rock.
Is there a way to modify this script to trigger off of simply entering data into a cell? For instance, I enter a questionsinto any call in column A and the answer is automatically posted in the same row in column b?
Yes, you can reference your input cell inside of the AI function.
For example the formula "=AI(C2, 1)" would take the input of C2 as the string to pass the API
@@RockTrembath what about a whole column, so if I wanted to load 50 questions in cells A1 - A50 it would cycle through the questions and enter the responses into the cells C1-C50 for instance? Is that possible? Or just a column with no range so you could just continually submit questions endlessly? is that possible?
@@CreateAI-nr7mw Well, it's in a spreadsheet, so if you put them all in rows 1-50, you can just just fill-down the formula column from 1-50 and it will provide answers for each in the accompanying cell.
Can you show how to do this with say a Jupiter Notebook or maybe to build a google Colab? GPT is excellent writing code, but copying and pasting back and forth slows things down.
Good idea. My next few are focused more on content generation, but I will take look at some Google Collaboratory ones as well 🙂
Anyway I can dynamically import value from a cell to use with the prompt?
Yep
ua-cam.com/video/A6QPnrYDZ-4/v-deo.html
hello i did as you said
But I got an error as below
Can you help me?
erro Maseeage
ReferenceError: sk is not defined
The script may need to be authorized. In the app script window press the Run button at the top of the toolbar, if it's not authorized it will have you give permission for it to work within your sheet.
How do I get the prompt to reference a cell. Such as =ai(write a 150 description about cell A2 that includes X Name, .4) that could be dragged down that would reference A3, A4, and so on? Also, how do we reference 'model' in the formula? In your example you stopped at temperature in the formula.
You don't need to change the model, it's already configured.
You can join strings by using the & plus the cell reference. It's similar to other Sheets functions.
=AI("Write about "&B2&".", 1)
Top man! Thanks
Great, thank you for the video. In my case, it doesn't work with =AI("prompt",1) BUT =AI("prompt,1") works. Any Idea why?
Because that's is the proper use of the formula. I believe it is because it is a boolean you need to tell to return true, but if someone else knows, please chime in
Why is the code using Davinci and not ChatGPT? Can we change this, if so how?
Chat Gpt api wasn't available when this video was made. Will look to update it in the coming weeks
Here you go: ua-cam.com/video/Z0sL2io9CEc/v-deo.html
is it working only in for prompts in english? I tried to write one in a different language but the results were poor
I think the results vary in different languages. According to Open AI this model is optimized for english: help.openai.com/en/articles/6742369-how-do-i-use-the-openai-api-in-different-languages
@@RockTrembath thank you
I was thinking your going to manipulate some spreads sheets with AI prompts
Haven't gotten there yet - mostly focused on content generation. If there is something specific you'd like to see, I'll look into it :)
@@RockTrembath Thanks, I would love to see prompts leading to the generatation/insertion/manipulation of data.
there is a Google Sheets add-on called "GPT for Sheets" which is much simpler to use
There is one called rows you could look at. It's debatable if you'll find it any easier of you find this difficult to follow, but you can check it out at rows.com
a plus user will also have to pay right?
I believe so. I don't think API usage is included in that plan.
I Amazin video, thanks!! But I am getting this error: "Sintaxis error: Missing ) after formal parameters., line: 14" I tried everything but it is not working
The formula is pretty straight forward:
=AI("your prompt", 1)
If you're getting a syntax error you are probably missing the end bracket
@@RockTrembath - for some reason it's not working for me. I even went as far as to copy the prompt you sent to @novel and then wrote out the prompt and still nothing. Can you help me with this?
How can this be used with looking at DATA? I can't think of many people who create tweets in Excel, seems like this use case is more for people just want to churn out AI generated content on blast.
It's a natural language algorithm, so data analysis isn't really it's primary function. You can create all types of content I'll be going over it in future videos this is just the setup step.
I don't know about google spreadsheet, but I used it to make some code for r language in RStudio, it made some graphs based on some conditions I specified, then I asked for it to print a sentence if a condition is met or not. The codes I did manually were not evenly close to how efficient AI code was.
How to do this with bluewillow or mid journey
Midjourney is currently only available through their Discord connection. I did an info to it over here if you're interested ua-cam.com/video/-JhbTxCQCAQ/v-deo.html
hello is it possible to do the same thing with our artificial intelligence?
anyway thank you very much for your videos
I'm not sure what you're talking about.
hello and thank you very much for your answer,
I'm having trouble with your method since I don't know anything about code,
I follow the method of a tutorial to do my prompts directly in a Google sheet and get the answers from chatgpt in it,
simply by copying and pasting the chatgpt API key, 6 digits,
and pasting it into a Google sheet module,
I'm not sure I understood your video well since I speak English badly, I'm French,
in any case what you do is the same thing?
I mean is it to do the prompts directly in a google sheet and get the answers from chatgpt in the google sheet?
anyway now i would like to do something a bit different,
could I send you an email?
and again thank you very much for your answer
My french is not great - but...
Oui. Si vous suivez les étapes de cette vidéo, le code vous permet de mettre une prompt chatgpt dans la feuille et de recevoir une réponse dans la même cell.
La commande à utiliser dans votre feuille est :
=AI("Votre invite pour ChatGPT")
La réponse sera retournée dans la cellule dans laquelle vous entrez la formule.
@@RockTrembath bonjour , dans votre dernier commentaire vous m'expliquer comment faire un prompt dans une cellule de mon Google sheet et obtenir la réponse dans une autre cellule de mon Google sheet ?
mais ça c'est ce que vous expliquez dans votre vidéo ?
je me demandais si je pouvais faire la même chose avec une image?
je veux dire dans la colonne à je met toutes mes images ( en a1, a2... ) puis je fais mon prompt en b1 ( décris-moi l'image que tu vois en a1)
est-ce que tu comprends ce que je veux dire ?
@@SD-rg5mj Oui. Je comprends.
Ce script utilise le modèle GPT qui crée des réponses textuelles.
Pour les images, vous devrez utiliser le modèle DALL-E. Cette vidéo n'est donc pas ce que vous recherchez.
J'ai une vidéo sur l'utilisation de Midjourney pour créer des images qui peuvent aider, mais c'est un système différent.
ua-cam.com/video/-JhbTxCQCAQ/v-deo.html
Nailed it
I thought you were going to use it to create graphs?
Nope. More focused on content generation with this series of vids.
my api key is expired what should i do
Go to your Open AI account and create a new one
how do i get it to create tables and graphs directly into google sheets?
The function included in this script may not quite fit that use case.
It could get you part of the way.
You could prompt it with something like "what is the population of Canada? create a two column table with data split by age group" and it will return data, but it will be formatted in a single cell like this:
"| Age Group | Population |
|----------|------------|
| 0-14 | 8,945,869 |
| 15-64 | 22,890,073 |
| 65+ | 5,919,737 |
| Total | 37,755,679 |"
You'd have to Text-to-columns on the " | " and build your chart from there. So it will take more code than what's provided. It's not absolute magic.
@@RockTrembath Gotcha! appreciate the insight. Can't wait for the magic!
I think you can prompt it to give you a CSV output
what are other prompts you can use?
It's really up to you to experiment, it's quite versatile. You can check out my vid on generating blog posts if you'd like some ideas : ua-cam.com/video/A6QPnrYDZ-4/v-deo.html
@@RockTrembath i mean in the googlesheet. how do you call a cells or columns?
For example: write a greating for a person in cell a1
@@RockTrembath ok figured it out. but why am I getting errors on some cells?
What's the error?
Anyone figured out how to get it to interact with other cells? For example, rewrite the content in column a, row 2.
Next video will show you how, but short version would be:
=AI("rewrite "&A2&" to be unique")
Where A2 is the cell you want to reference
@@RockTrembath top man
cool
you didnt blur your key, can't it be stolen?
I deleted it after. But yes. It could have been used.
ChatGPT will make updates to 2023, and begin a pricing model to charge for it's use. They are in the process of growing a global dependency on it to get everyone, from businesses to individuals, completely hooked. Initially those hooked on it will be for profit, but it will end with becoming hooked on it for survival.
They already charge for api usage. That's why a credit card is listed as a requirement in this video.
why unknow function "AI" ?
Did you follow the steps to add the script? The function is contained in the App Script. In some accounts, You will need to give the script permission to run.
@@RockTrembath Yes, I follow step by step and permission account google, but unknown function "AI"
@@nexeatsimple640 That is very strange. You're the first person to have this issue. If you saved the App Script to your doc it should recognize the function. You hit the 'Save' button in the App Script window? That's the only other thing I can think of.
Let’s gooo
can we access 2023 data from this code?
As I mentioned in the video, the model only has access to data up to ~2020.
hello
Rick Grimes
umm... hope you deleted that API key.
Of course I did. But I like the idea of someone wasting their time tapping it out 😂
😅gahahah bla bla
Thank you for the spicy good material.
Is it possible to adjust the maximum length?
I think you can extend it by changing the max tokens length in the App Script. It's currently 200.
Keep in mind it will put the cost up.
Reference :
help.openai.com/en/articles/5072518-controlling-the-length-of-completions
You can also break you jobs out into multiple steps. Downside is you need multiple unique prompts.