This is absolutely amazing. I had that extension up and found the 999+ permission asks a bit excessive. Can't wait to plug this in. That said, did I miss something about how you compiled that database? Have you made that available somewhere or is that your internal work for clients?
So cool to hear you relate to this! Thank you for your comment. And yes, it is for now internal thing. I am still going through it as needed, cleaning it up and polishing it. If enough of people ask, probably it makes sense to share it. (of course, for free :))
I mean I just saw someone offering 50 prompts for $150 and no guarantee they actually work, and I've already paid $10 for a prompting ebook that didn't have one bit of usable information in it. What I mean is if you release your thing as a pay-what-you-want then I'd rather pay you for stuff I know you worked hard on and is good quality, than pay someone else for nothing of value.
hello could I use the GT4 API in Google sheet and thus have image descriptions in SEO, and that could create my catalog which I will only have to import into my site
Excellent. I really like you showing the demo at the beginning. So many tutorials start with the boring stuff. Also, this example is SUPER practical. Thanks!
This video is a fantastic resource for upgrading Google Sheets with the ChatGPT API key and leveraging Canva to transform data tables into visually appealing designs. The step-by-step guide provided by Sjoerd in the blog post is extremely helpful for those who want to enhance their Google Sheets experience with AI capabilities. Thanks for putting this together!
I think it's important to consider that, while the ability to customize your own scripts is fantastic when tackling complex tasks, for most people and in most use cases, mastering the Zapier plugin (plugins now being accessible to + users) might be a more user-friendly approach, enabling them to accomplish more. Both methods are worth considering and can be adapted to suit your workflow, style, and needs.
you are awesome, thank you for all the knowledge you share!.....i just came across your videos and im blown away.....i had NO IDEA what chatGPT was REALLY capable of...... some of it is rather scary ...... please continue to keep us informed! Thanks
You're among the 3 influencers I'm following on a regulary base since a while. Hi, how are you? Thank you for your work. Get in touch anytime you need my help. Have a good day.
Hi fellow prompt engineers I am building a full novel with GPT4 at the moment. I have been working on it for the past four months and I have made significant progress with it. I have the full writing style, the world-building, the plot summary, the character list, and the visual imagery for each scene. Obviously, I am massively exceeding the token limit and had to build it in sections. I am struggling to get the bot to produce any useful writing, but I can't think of any more information to teach it to produce good work. I'd love to hear your ideas!
When I copy down or drag the function to the next field it creates identical copies of the first item generated. Its not giving me new generations every line... can you tell me what I missed
Yes! Spot on! Just think about the ideation process for advertisement creatives. Or I also did technical papers and product sheets. I also thought that real estate listings could be automated from spreadsheet to one-pager design in probably 10min.
hello what is the difference with the gpt for sheets module? I have difficulty understanding on my own since I speak poor English anyway thank you for your videos
So, if you can operate with the table content, that would add like a memory layer? Assuming you can format the info in each cell in a way it's suitable and create the right prompts, could this compare to using agents in some way?
Yes! In the code you need to tell different link for different model. Basically the link is the same. But ending is whichever model you want to use. :)
Really great info and easy to do the Sheets integration. thank you! QUESTION: In this script, do you know what the variable "val" is and where it comes from? it's concatenated into the prompt, but where is it defined? I'm experimenting with ways to use dynamic data from cells in the sheet to create prompts and API calls and it looks like rather than concatenating long prompts in the cell, I will need to write them programmatically into the scripts. Thanks for sharing this - love the bonus part about finalizing output in Canva (one of my favorite apps!)
Hi ! Is there any update or new version of this? I tried in every ways but can’t h’get it working. The function got is not even recognised ! Anyone can help please
Hi Goda Go. I was wondering, where did you get the dataset with the 660 use cases by industry? I’ve tried googling it but can’t see any reference for it? Thanks
The videos are good, but I find the audio quality of your voice a bit off and hard to understand sometimes. Consider checking your compression and limiter. 😉
I finally realized the symbolism of Goda Go. 🤣 Personally I do think we should be very worried about what has been unleashed upon the world. It’s a fun toy and has many uses, but most people don’t need it. Instead it will be used to control us.
Try to refresh the page. It should appear. If not. The walk around it is to select what you need to be in text values, copy, paste special, paste values only :)
I feel happy i am soon out of the work force. It all looks to overwhelming and impossible to catch up. Goodnluck with all this shit and jumping to 100 hoops and apps while you get overloaded my your manager since you now have AI to help you...😁😁
About halfway through your video, my head started hurting because I couldn't understand anything, so I decided to give up. Maybe it's easy stuff for a zoomer like you, but for a dinosaur like me, it's definitely like the Klingon language.
Oh, I am sorry to hear it! Don't give up, I do recognise this could seem a bit harder but choose your battles. There are so many great tools that require no effort. Just all depends what help you need and what is your current workflow. :)
@@godago do you have a website /blog? Perhaps it wouldn't be a far-fetched idea for you to post an article on your blog for each video, explaining in more detail and in a more didactic manner what you discussed in the video. I know, due to the short attention spans and impatience of today's youth, you have to literally run and cut any space between words. Unfortunately, this is no longer a world for boomers; we prefer measured and well-explained speech. In fact, I invite you to compare the speaking speed of late millennials and centennials with that of boomers and pre-millennials. There's a big difference. In this regard, for example, I like Lex Fridman. His slow and reflective way of speaking is refreshing. Of course, there are exceptions. Stephen Wolfram, for instance, is a speaking machine gun; his brain is much faster than what his vocal interface allows him to transmit. But don't worry, the world is changing. Maybe in 50 years, we won't even use our mouths and ears to transmit and receive spoken information, and everything will be through brain interfaces. Or perhaps, due to all these developments in artificial intelligence, we will have become so lazy that most people won't even bother studying anymore, because why would they? Or maybe we'll all be dead, exterminated by artificial intelligence.
And you know what's fun application of this? Exposing how many different outputs to one prompt GPT can provide. I got even, that it can't generate me random names next to other output generating those names.
All links and some Spreadsheet prompt examples are in the Description Box. Make sure to check out 🚩Sjoerd’s Blog Post on How to Upgrade Google Sheets with ChatGPT: bit.ly/3B81JeD
Hi Godago! :) Big fan from india first, you are the angel/saviour. I have a request that can you please share that google sheet with chatgpt use cases in all the industries ?🙂🙏
This is can of sad for me since we cannot pay to use the playground here in Colombia, so there is no GPT Key here, but at least we can pay for ChatGPT Plus. I wish I could find a way around.
This is absolutely amazing. I had that extension up and found the 999+ permission asks a bit excessive. Can't wait to plug this in.
That said, did I miss something about how you compiled that database? Have you made that available somewhere or is that your internal work for clients?
So cool to hear you relate to this! Thank you for your comment. And yes, it is for now internal thing. I am still going through it as needed, cleaning it up and polishing it. If enough of people ask, probably it makes sense to share it. (of course, for free :))
@@godago Would be amazinig!
I mean I just saw someone offering 50 prompts for $150 and no guarantee they actually work, and I've already paid $10 for a prompting ebook that didn't have one bit of usable information in it. What I mean is if you release your thing as a pay-what-you-want then I'd rather pay you for stuff I know you worked hard on and is good quality, than pay someone else for nothing of value.
hello could I use the GT4 API in Google sheet and thus have image descriptions in SEO, and that could create my catalog which I will only have to import into my site
Brava, greatings from Italy (north Italy from Dolomities)
Excellent. I really like you showing the demo at the beginning. So many tutorials start with the boring stuff. Also, this example is SUPER practical. Thanks!
This video is a fantastic resource for upgrading Google Sheets with the ChatGPT API key and leveraging Canva to transform data tables into visually appealing designs. The step-by-step guide provided by Sjoerd in the blog post is extremely helpful for those who want to enhance their Google Sheets experience with AI capabilities. Thanks for putting this together!
Thank you, I appreciate how well edited your videos are, no time wasting!
You're a magician. I need to watch and watch again.
I have been using ChatGPT for a while now, but I still found some new information in your video. Great job!
Thank you so much for this awesome video!
Goda Go, i just found you right now and just I can say I love you. Thank you for sharing your knowledge. :)
I think it's important to consider that, while the ability to customize your own scripts is fantastic when tackling complex tasks, for most people and in most use cases, mastering the Zapier plugin (plugins now being accessible to + users) might be a more user-friendly approach, enabling them to accomplish more. Both methods are worth considering and can be adapted to suit your workflow, style, and needs.
hello do you think I could make image to text with GT4 and Google sheet
Hello, do you think I could do image description in a Google sheet using one of these modules?
you are awesome, thank you for all the knowledge you share!.....i just came across your videos and im blown away.....i had NO IDEA what chatGPT was REALLY capable of......
some of it is rather scary ......
please continue to keep us informed!
Thanks
Thank you 🙏🏻
As always very useful video ma'am. I had some doubts about OpenAI paid account. All are cleared through this video ma'am. Thanks :)
Impressive and insightful explanation 🙏, become quick fan of you 😎
You're among the 3 influencers I'm following on a regulary base since a while. Hi, how are you? Thank you for your work. Get in touch anytime you need my help. Have a good day.
Hi fellow prompt engineers I am building a full novel with GPT4 at the moment. I have been working on it for the past four months and I have made significant progress with it. I have the full writing style, the world-building, the plot summary, the character list, and the visual imagery for each scene. Obviously, I am massively exceeding the token limit and had to build it in sections. I am struggling to get the bot to produce any useful writing, but I can't think of any more information to teach it to produce good work. I'd love to hear your ideas!
Thanks for your videos, they are very informative! 🙂
When I copy down or drag the function to the next field it creates identical copies of the first item generated. Its not giving me new generations every line... can you tell me what I missed
Maybe you converted the field into text only? Can you check if it is still a formula? And also, what is the prompt if you don't mind sharing?
Same shit here
This technology can be a game changer for the marketing business.
Yes! Spot on! Just think about the ideation process for advertisement creatives. Or I also did technical papers and product sheets. I also thought that real estate listings could be automated from spreadsheet to one-pager design in probably 10min.
Thank you GG❤️ for this
What did you use for you control? What base line are you comparing the result against?
Where is the g sheets with use cases?
That would be interesting an useful for many
hello what is the difference with the gpt for sheets module?
I have difficulty understanding on my own since I speak poor English
anyway thank you for your videos
Super, thank you !
Have you already tried microsoft copylot ?
It doesn't work for me for some reason...
+1000. Thank you. 😃
So, if you can operate with the table content, that would add like a memory layer? Assuming you can format the info in each cell in a way it's suitable and create the right prompts, could this compare to using agents in some way?
Exactly!
@@godago Been playing with it for a couple hours. It's quite tricky to get usable data, but there's a huge potential!😅
You have the nicest voice
we are waiting for you new video :(
we missed you... 🙏🏼
The video is coming out at the latest tomorrow! I miss you too!
isn't Gemini is already built in Google sheet..?
great content as usual, keep up u are awesome
Thank you so much for your kind comment!
hello I would like to do image description, could I use models other than 3.5?
Yes! In the code you need to tell different link for different model. Basically the link is the same. But ending is whichever model you want to use. :)
@@godago oui je vois qu'il n'y a que deux modèles : gpt3.5 turbo et texte Da Vinci, n'est-ce pas ? mais je ne peux pas utiliser gpt4?
Really great info and easy to do the Sheets integration. thank you! QUESTION: In this script, do you know what the variable "val" is and where it comes from? it's concatenated into the prompt, but where is it defined? I'm experimenting with ways to use dynamic data from cells in the sheet to create prompts and API calls and it looks like rather than concatenating long prompts in the cell, I will need to write them programmatically into the scripts. Thanks for sharing this - love the bonus part about finalizing output in Canva (one of my favorite apps!)
wow youare awesome
Hi ! Is there any update or new version of this? I tried in every ways but can’t h’get it working. The function got is not even recognised ! Anyone can help please
Yes it doesnt seem to work anymore.
cool!
hello it does not work with chatgpt 4?
Get it girl 🎉🎉❤
It is a hooded AGI.
That has left me a little disappointed, where is the link for 660 use cases? Have I missed something?
Hi Goda Go. I was wondering, where did you get the dataset with the 660 use cases by industry? I’ve tried googling it but can’t see any reference for it? Thanks
I created it for my personal use. Probably would make sense to release it..
@@godago It would! Please let us know if you do end up releasing the GoogleSheet. :D
The videos are good, but I find the audio quality of your voice a bit off and hard to understand sometimes. Consider checking your compression and limiter. 😉
How do we fix this error: "Exception: Cannot call SpreadsheetApp.getUi() from this context."
Did you use Sjords code or chatgpt gave you one?
I got it to work! Thank you🎉
I finally realized the symbolism of Goda Go. 🤣 Personally I do think we should be very worried about what has been unleashed upon the world. It’s a fun toy and has many uses, but most people don’t need it. Instead it will be used to control us.
hello could this work with images, I mean image to text
how much money did it take to make all the 660
$50 :(
06:35 what command formula did you put in here?
My Sheet with GPT integration worked but there is no GPT button next to 'help'. 🤔
Try to refresh the page. It should appear. If not. The walk around it is to select what you need to be in text values, copy, paste special, paste values only :)
@@godago Thank you! I will try that tomorrow😁
Worked!
I feel happy i am soon out of the work force.
It all looks to overwhelming and impossible to catch up.
Goodnluck with all this shit and jumping to 100 hoops and apps while you get overloaded my your manager since you now have AI to help you...😁😁
ah. AI for left brains. "Uniting the right-brain dreamers with the left-brain doers." ;-)
About halfway through your video, my head started hurting because I couldn't understand anything, so I decided to give up. Maybe it's easy stuff for a zoomer like you, but for a dinosaur like me, it's definitely like the Klingon language.
Oh, I am sorry to hear it! Don't give up, I do recognise this could seem a bit harder but choose your battles. There are so many great tools that require no effort. Just all depends what help you need and what is your current workflow. :)
@@godago do you have a website /blog?
Perhaps it wouldn't be a far-fetched idea for you to post an article on your blog for each video, explaining in more detail and in a more didactic manner what you discussed in the video. I know, due to the short attention spans and impatience of today's youth, you have to literally run and cut any space between words. Unfortunately, this is no longer a world for boomers; we prefer measured and well-explained speech. In fact, I invite you to compare the speaking speed of late millennials and centennials with that of boomers and pre-millennials. There's a big difference.
In this regard, for example, I like Lex Fridman. His slow and reflective way of speaking is refreshing. Of course, there are exceptions. Stephen Wolfram, for instance, is a speaking machine gun; his brain is much faster than what his vocal interface allows him to transmit.
But don't worry, the world is changing. Maybe in 50 years, we won't even use our mouths and ears to transmit and receive spoken information, and everything will be through brain interfaces. Or perhaps, due to all these developments in artificial intelligence, we will have become so lazy that most people won't even bother studying anymore, because why would they?
Or maybe we'll all be dead, exterminated by artificial intelligence.
I am lost lol
More than anything, this video demonstrates the potential for these LLMs to generate unlimited bullshit at almost zero cost.
And you know what's fun application of this? Exposing how many different outputs to one prompt GPT can provide. I got even, that it can't generate me random names next to other output generating those names.
All links and some Spreadsheet prompt examples are in the Description Box. Make sure to check out 🚩Sjoerd’s Blog Post on How to Upgrade Google Sheets with ChatGPT: bit.ly/3B81JeD
Hi Godago! :) Big fan from india first, you are the angel/saviour. I have a request that can you please share that google sheet with chatgpt use cases in all the industries ?🙂🙏
This is can of sad for me since we cannot pay to use the playground here in Colombia, so there is no GPT Key here, but at least we can pay for ChatGPT Plus. I wish I could find a way around.
Is there anyway we can connect ChatGPT with MS office documents??
Google I/O was definitely heavy on AI to the point where I think they're worried about losing money and SEO's are like "oooph"