This is amazing! How do you deal with request limits? I'm set to 3RPM for all models, so I'm unable to drag and drop this into a sheet as it will only do 3 at a time.
Good question. I don't have a good answer right now except to find yourself a higher limit :) 3rpm is really really low and you should be able to find even a free service or wrapper that offers more. Check out Groq or Together.ai
Hello, thank you for a great video. I am trying to integrate it with the app script but i keep getting error on var Response line in saying invalid user content. Is there any alternative to that?
I found this useful, possibly the code needs to be improved so that the google sheet doesn't make repeated and unnecessary calls to OpenAI. At least to me it looks like calls are made every time the sheet is opened and when certain unrelated things are changed in the sheet. Overall, highly interesting.
Thanks and agreed. It shouldn't run the code just from opening a worksheet, but it would be worth looking into more. I added a version to the code repository that uses Google Sheets' built-in caching, but it has some of its own limitations. I was thinking that going through a proxy with caching would be beneficial. Open to any ideas to reduce API calls and token usage.
Great tutorial, thanks for posting it.
Your Videos are very informative, Thank you
This is amazing! How do you deal with request limits? I'm set to 3RPM for all models, so I'm unable to drag and drop this into a sheet as it will only do 3 at a time.
Good question. I don't have a good answer right now except to find yourself a higher limit :) 3rpm is really really low and you should be able to find even a free service or wrapper that offers more. Check out Groq or Together.ai
Súper... 👍 me funciono... Muchas gracias, Saludos desde Chile... 🇨🇱
Thanks. Is it possible to make a webscraping from a given url in a column?
This is a task better suited for another tool. I'd check out apify.com/
Hello, thank you for a great video. I am trying to integrate it with the app script but i keep getting error on var Response line in saying invalid user content. Is there any alternative to that?
I found this useful, possibly the code needs to be improved so that the google sheet doesn't make repeated and unnecessary calls to OpenAI. At least to me it looks like calls are made every time the sheet is opened and when certain unrelated things are changed in the sheet. Overall, highly interesting.
Thanks and agreed. It shouldn't run the code just from opening a worksheet, but it would be worth looking into more. I added a version to the code repository that uses Google Sheets' built-in caching, but it has some of its own limitations. I was thinking that going through a proxy with caching would be beneficial. Open to any ideas to reduce API calls and token usage.
Your videos are fantastic. Because of the amazing value you deliver on TH-cam, I discovered Entry Point and became a customer.
Awesome! Thanks for sharing - see you on the Masterclass today 😉
hello can you help me