I don't know if you said this, but once you put virtually anything in google sheets, using middle wear you can distribute it to a gazillion other apps. So this is very exciting!
@Mr_Productive
Жыл бұрын
I tried building similar things on my channel. I know how hard it is. Thanks Rock for providing value.
@Amokdad
Жыл бұрын
Thank you for your efforts, I love your videos, can you please show us how to make in bulk, using one prompt. And if we can create different templates in multiple sheets, you are the GOAT!!!!
@RockTrembath
Жыл бұрын
I'm not 100% sure what you mean. Once the App Script is on the sheet, you can call the =AI function from as many tabs as you need. Also, the Blog post video shows you how to chain prompts together to make a whole document from 1 keyword: kzitem.info/news/bejne/omyHtqKoknaLYGk
@Amokdad
Жыл бұрын
@@RockTrembath thanks buddy
@peterkortvel
Жыл бұрын
next level efficient content. you deserve way more subscribers. keep up
@readulhaque
Жыл бұрын
Thanks a lot this will be helpful for me 👍
@FrankSchwarzfree
Жыл бұрын
Thanks for this! Amazing!
@MisterB88
Жыл бұрын
Exactly what I needed! Thank you so much for all your work
@7thWardMadeMe
Жыл бұрын
This was cool 😎. Thanks
@ClemensPfefferkorn
Ай бұрын
LOVE IT!!!! 2 things: if I want the script and function to be available in every sheet I use or create new. How would I do that? Also: if using gpt-4o i simply change the line 22? THX
@joaquincarrascosa91
Жыл бұрын
Great video! Im giving it some use already and its amazing! I do have a question. When i try running many queries at once (more than 100) i get a lot of error results (I can run up to 40 queries at once). Is there a way to fix or automate this ? If not i would have to manually do it 40 rows at a time, up to 15000 total rows (each row has a query to chat gpt). I tried increasing the max tokens but i think that works for each individual query. Any ideas? Thanks
@RockTrembath
Жыл бұрын
Sounds like you may be hitting their rate limiting by making so many calls so quickly platform.openai.com/docs/guides/rate-limits/overview I'm not sure there is a way around this, since it's happening on their end.
@sebastiantomic9415
Жыл бұрын
Thanks! Can I ask GPT to extract data from one tab and load it to another? Example simple promt: "Remove decimals from row 2" or "Calculate percentage change in row 1 compared to row 2. Show the results in row 3"
@RockTrembath
Жыл бұрын
Since it's just calling the API to a cell, it doesn't have broader awareness of the sheet. You could ask it a questions like "what is a formula to remove decimals from a cell in a google doc?" and it would respond with the ROUND formula and some context on how it works. Similar with your other example, if you ask the question: "I have two columns of data in a Google sheet. What formula can I use in column 3 to calculate the percent change between column 1 and 2?" it will tell you the formula and steps. Other option would be to create a new prompt in a cell that references your two numbers: =AI("What is the percentage change between "&A1&" and "&B2)
@thomasgronberg9270
Жыл бұрын
What do you mean costs? If I pay 20€ a month for it do I have to pay more to use it in google sheets??
@RockTrembath
Жыл бұрын
Last I checked, If you're paying for the ChatGPT plus, it doesn't include api access, so you need to pay separatly yes.
@FranckPARIENTIfranck
Жыл бұрын
Hi how to use it for GPT-4 ?
@RockTrembath
Жыл бұрын
GPT-4 is in Beta - I haven't been granted access yet. But you should be able to just change the model on Line 22 of the code to one of the GPT 4 values outlined in the API doc: platform.openai.com/docs/models/gpt-4
@FranckPARIENTIfranck
Жыл бұрын
@@RockTrembath I've changed line 22 for "gpt-4" but it's not working
@RockTrembath
Жыл бұрын
Are you approved to access the api? It's still in beta. You need to be approved off the wait list.
@JackChickenwing
Жыл бұрын
@@RockTrembath First off, thank you for these videos they have been so helpful for me. Thank you for taking the time to answer these questions as well. I have tried swapping gbt-3.5-turbo for gbt-4 and it says model gbt-4 does not exist. I do have access to gbt4 on chat gbt, but the reason for it not working is out of my understanding. Thanks regardless!
@RockTrembath
Жыл бұрын
@@JackChickenwing the api for gpt 4 is still limited. You need to apply to have it added to your account, you can do that here: openai.com/waitlist/gpt-4-api I couldn't find any data as to when they plan to open the api up further. Just have to sign up and wait for now 🤷♂️
Пікірлер: 26