what best mode v6 alpha or which one ?

That means openai took too long to respond. Do you have a balance in your account? You can receive that message if you don't have any credits. Sometimes the system just doesn't respond too. It may be as simple as reloading it.

thank you 🙂 I find it makes it much easier for me to shoot and edit videos in batches. Let me know if you give it a try.

I'm not sure I understand your question. It will send to how ever many names you have in the sheet. There is no minimum.

Yep - use the most recent version of the AppScript github.com/rocktrembath/chatGPT-google-sheets/blob/main/appscript

Hmm - looks like Google changed the security policy when you copy the document. I'll have to look into it and get back to you

Thanks @@RockTrembath !

Here's an update on this: x.com/RockTrembath/status/1723376359399977207?s=20

Yes. But you'd need to create the background in Mid journey and combine the images in a different software. If you provide it an image, it uses it as inspiration but does not add to or extend it.

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. kzfaq.info/get/bejne/Y7CYlbepqLencYU.html

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 :)

Did you authorize the script? Open the app script window and hit the Run button at the top. It should prompt you to give it access to the document. Are you receiving an error message?

great video! Really appreciate the content. I am receiving the same issue where the workflow tools does not appear at the top. However i can run it directly from the code window when I press run and it work just fine. When I did press run from app script directly it asked me to authorize, which I did and like I said it worked, but I still don’t have the workflow tools tab at the top of the google sheet. Any idea how to get that going?

@@lindsayricci8048 Once you save the code in the App script Window, you need to reload the spreadsheet for it to pick it up. Once you reload the page/sheet it should pop up on the left of the menu bar. Takes ~3-5 seconds sometimes.

Hey ara! It depends on what services you'd like to offer your clients. If I were you, I'd add a copywriter / editor to the team. If you're doing restaurants (hospitality industry) you're probably looking for someone who can do text for social media, websites, email, SMS and maybe even traditional PR. I'd look for someone who's cool to use AI text for a first draft so you can work quickly for many clients. Good luck!

Good tip. I kinda assumed you would know what it does before you got here. Check my other vids for ideas on how to use it 🙂

If you want to take time to look at the code, it's pretty straightforward to copy and edit to create your own. You create a new function (I'd copy an existing one and rename it) and add a button in the HTML file. Each network has its own html file in the left of the App Script window. Add or copy/paste/edit a new button. Make sure the button calls the new function name. I'll think about how I can make it easier.

Change the model name in the AI function to 'text-currie-001'

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

@@RockTrembath I've changed line 22 for "gpt-4" but it's not working

Are you approved to access the api? It's still in beta. You need to be approved off the wait list.

@@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!

@@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 🤷‍♂️

Go to your Open AI account and create a new one

I've put the script on a test sheet and tried breaking it. I can't reproduce this error. Check that the name of your sheet matches the variable dataSheet set on line 24. When I google it I see that error is associated with arrays, the script is expecting 2 or more columns of data, so that could be another potential issue.