"Create a Universal Analytics Property" wasn't a feature I could select while creating the new property. Is that because it's the default option?
@onbeingattached2 күн бұрын
Thank you for the content. I'm stuck at Creating a Property because we already have a property created for the website in analytics from early 2023. Do I make a new property?
@VividVentssАй бұрын
Perfect thanks <3
@VividVentssАй бұрын
what best mode v6 alpha or which one ?
@cgc23002 ай бұрын
hello
@RvSharma-h6w2 ай бұрын
hello sir i saw your video and use gpt-4 + google sheet to create content for my website but it gives this error "Exceeded maximum execution time (line 0)." can you please tell me how i solve this error
@RockTrembath2 ай бұрын
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.
@RvSharma-h6w2 ай бұрын
hello sir i saw your video and use gpt-4 + google sheet to create content for my website but it gives this error "Exceeded maximum execution time (line 0)." can you please tell me how i solve this error
@leanb2b2 ай бұрын
This guy sure walks a lot!
@leanb2b2 ай бұрын
Now we talkin'. This good content, man!
@lacklusterbeverage3 ай бұрын
Awesome tutorial have been considering this for socials
@RockTrembath3 ай бұрын
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.
@DavidLutz-yi2nw3 ай бұрын
How do I add just a couple of names
@RockTrembath3 ай бұрын
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.
@richardrispoli45085 ай бұрын
Nice :) thx
@user-rq9sp3oo2n6 ай бұрын
Brilliant! Is there a way to get it to work with GPT4?
@RockTrembath6 ай бұрын
Yep - use the most recent version of the AppScript github.com/rocktrembath/chatGPT-google-sheets/blob/main/appscript
@alferez99636 ай бұрын
Sirrrrr thank you so much! I was struggling. Suscribed!!
@sasdub9 ай бұрын
Hi rock, Very curious about this copy deck, but for some reason the "Copy Deck Constructor” menu is not visible. Any idea how I can fix this?
@RockTrembath9 ай бұрын
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
@sasdub9 ай бұрын
Thanks @@RockTrembath !
@RockTrembath9 ай бұрын
Here's an update on this: x.com/RockTrembath/status/1723376359399977207?s=20
@mgc332 Жыл бұрын
not working for me when clicking the sidebar buttons, nothing happens.
@phoustonnow Жыл бұрын
Are you able to use your own existing images and have the program create backgrounds?
@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.
@SD-rg5mj Жыл бұрын
hello is it possible to do the same thing with our artificial intelligence? anyway thank you very much for your videos
@RockTrembath Жыл бұрын
I'm not sure what you're talking about.
@SD-rg5mj Жыл бұрын
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
@RockTrembath Жыл бұрын
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.
@SD-rg5mj Жыл бұрын
@@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 ?
@RockTrembath Жыл бұрын
@@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
@peterkortvel Жыл бұрын
next level efficient content. you deserve way more subscribers. keep up
@corvox2010 Жыл бұрын
Thanks a bunch this will help out my in-house system I am building.
@LumenSolarCo Жыл бұрын
I have landing pages I made through elementor. Will this also track any activity on the landing pages or will that have to be a separate thing? Also, would I connect facebook pixels through GTM as well or would there be a different process for that?
@blockchainmafia4635 Жыл бұрын
How to do this with bluewillow or mid journey
@spencerkain3516 Жыл бұрын
Super helpful! Thank you brother!
@jonsunderland7708 Жыл бұрын
I was thinking your going to manipulate some spreads sheets with AI prompts
@RockTrembath Жыл бұрын
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 :)
@andrewlawson8233 Жыл бұрын
"Export generate text to a Google Doc" function not working for me. I.e I don't see the "Workflow Tools" menu. Anyone else had this problem and if so how did you fix?
@RockTrembath Жыл бұрын
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?
@lindsayricci8048 Жыл бұрын
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?
@RockTrembath Жыл бұрын
@@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.
@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??
@SRC7777 Жыл бұрын
Great vid ! Awesome tool for the tool box. Thanks Rock !
@user-in5ex2yk8s Жыл бұрын
hello rock , I'm a content creator who's trying to build a marketing team , at the moment all of my clients are in the food business ( product , restaurants , ect..... ) , the only reason why my clients are happy with my work is because of my photography and videography skills but as you know digital marketing doesn't end with just photos and videos , so in your opinion , other than a graphic designer and a website builder what expertise do i also need to help me build a good marketing team ?
@RockTrembath Жыл бұрын
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!
@ABITATco Жыл бұрын
This was very easy to follow and super easy to implement. However when I requested an article to be 750 words the results it generated in the body were incomplete. Are there limitations in terms of the length of texts in the code?
@dannefrazier Жыл бұрын
Thanks so much @Rock Trembath! Love your systems and process management techniques. Looking forward to your videos for steps #4 and #5 . 😀
@jobelab Жыл бұрын
was following along but couldn't complete cause I have ChatGPT plus subscription and not chatgpt thru OpenAI, which is a separate bill. Gonna try to add ChatGPt add on instead to Google Docs/sheets instead.
@69xXefiXx69 Жыл бұрын
An excellent guide, I just lacked at the beginning a view of what it actually does and to be impressed and then go into the details of how to carry out the guide.
@RockTrembath Жыл бұрын
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 🙂
@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
@YamacKeskin Жыл бұрын
sir at my Wordpress doesn't have plugin, users,elementero etc why ? my Wordpress version is 6.0.2 so I haven't authorization or other problem ?
@FrankSchwarzfree Жыл бұрын
Thanks for this! Amazing!
@alpineai Жыл бұрын
Depending on the chatgpt prompt, it's not unfair to assume you can pull in factual data right????
@alpineai Жыл бұрын
I love these generator videos! Anymore?! you've earned a subscriber!!
@alpineai Жыл бұрын
This is fantastic! Do you do a video on how to make your own custom template? I can see the power of this using ChatGPT
@RockTrembath Жыл бұрын
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.
@alpineai Жыл бұрын
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!
@a1ang0r85 Жыл бұрын
Hello Rock, if somone has already been a plus user, do they need worry about the cost by using DaVinChi?
@dieforla Жыл бұрын
Is it possible to replace davinci model with text-curie-001? If yes, how?
@RockTrembath Жыл бұрын
Change the model name in the AI function to 'text-currie-001'
@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 🤷♂️
@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"
@MisterB88 Жыл бұрын
Exactly what I needed! Thank you so much for all your work
@1kbean Жыл бұрын
Umm this is super amazing, I love it. Thanks so much! If I have feedback after I implement I'll let you know. 🙋🌟🤓
@aminefreelancer9988 Жыл бұрын
my api key is expired what should i do
@RockTrembath Жыл бұрын
Go to your Open AI account and create a new one
@markusw.8978 Жыл бұрын
Hi. Awesome video! Thx for that! I got an error when trying to save to document: Exception: Die Parameter (number[]) entsprechen nicht der Methodensignatur für DocumentApp.Body.appendTable. Or in englisch it should be: The parameters (number[]) don't match the method signature for DocumentApp.Body.appendTable. and cannot fix it.. what could be wrong?
@RockTrembath Жыл бұрын
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.