Відео

Yes. Getting it to focus on what you need is difficult. Sometimes. You could try upscaling the one that's closest to what you're looking for, then provide it as a reference in a second prompt and see if constrains it more closely to what you're trying to do.

The only way I know to always have it available, would be to make a generic template and always duplicate your sheets from there. When you duplicate it includes the script. And yes, to update the model just change the name in the app script and it should be good to go.

It is because they have deprecated universal analytics. You can only create a Ga4 property now

If you already have a property, and you're looking to track the same user base, you can just create a new data stream within that property. If the site or app you're looking to track is a different domain or entity, I would recommend setting up a second property. Hope that helps

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

Did you copy it to your account and authorize the script? I just tested it on a fresh account and it worked fine.

Thanks Figured it out. @@RockTrembath

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. ua-cam.com/video/-JhbTxCQCAQ/v-deo.html

This should put the code on all pages generated by Elementor. For facebook, you would set it up in the tag manager and set it to fire on All pages, or the specific page you want to have the conversion sent

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

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.

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.

Last I checked, If you're paying for the ChatGPT plus, it doesn't include api access, so you need to pay separatly yes.

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!

Yes - in the App Script there is a constant variable named MAX_TOKENS You can try increasing the amount of tokens to process. The max gpt 3.5 is 4096.

@@RockTrembath Got it- Thanks

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 🙂

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.

You need to install the plugins. Look up 'how to add plugins to wordpress' This video uses a paid version of Elementor.

@@RockTrembath so plugin place is not free right? I must buy new plan from elementor for add plugin place then I can use. am I understand right ?

Yes. If you are knowledgeable about code, you can add the code directly in the template with the free version, but that may be too advanced for you.

Yeah. It's generally decent. I'm just not taking any responsibility for saying that it's correct 🙂

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

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)

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.