- 37
- 164 736
Rock Trembath
Canada
Приєднався 15 вер 2013
Digital marketing expert with 20+ years experience working online. I've helped startups, large corporations and governement agencies get direct marketing results.
How to: Generate consistent AI characters across images with Midjourney
Generate more consistent characters across images created with Midjourney's AI. In this video, we take a look at how I use character references to improve my AI storyboards.
0:21 Generate initial character
1:14 Grab the link to your AI character
1:32 Using the character reference function in Midjourney
2:58 Thoughts on the quality and consistency of --cref
Not sure what's going on here?
Watch my intro to Midjourney: ua-cam.com/video/-JhbTxCQCAQ/v-deo.html
Twitter: rocktrembath
Website: rocktrembath.com
#ai #aicontentgeneration #midjourney #midjourneyai
0:21 Generate initial character
1:14 Grab the link to your AI character
1:32 Using the character reference function in Midjourney
2:58 Thoughts on the quality and consistency of --cref
Not sure what's going on here?
Watch my intro to Midjourney: ua-cam.com/video/-JhbTxCQCAQ/v-deo.html
Twitter: rocktrembath
Website: rocktrembath.com
#ai #aicontentgeneration #midjourney #midjourneyai
Переглядів: 275
Відео
How to: Edit Video Fast with Descript AI (Edit for Clarity, Chapters, Playback Speed)
Переглядів 1075 місяців тому
Try Descript: www.rocktrembath.com/trydescript Learn how to use Descript's Edit for Clarity function to quickly turn a long single shot video into a coherent UA-cam edit. Contents 0:38 Using the Edit for Clarity Feature 1:08 Copy edits to new composition 1:27 Removing / Changing word gaps with AI 1:52 Selecting from remaining takes 2:26 Adjusting remaining gaps 2:32 Correcting the script text 2...
AI Video Editing Tutorial: Descript for TikTok, Instagram & Youtube
Переглядів 1625 місяців тому
Try Descript: www.rocktrembath.com/trydescript Learn how I use the AI functions in Descript to quickly edit my social and UA-cam content. This Tutorial shows the tricks I use to quickly make content for myself and my clients. Contents 0:11 What is Descript? 0:34 Descript Pricing 1:00 Creating a new video project 1:12 Importing media to Descript 1:55 Removing filler words with AI 2:47 Removing m...
How to: Use Tiktok's AI Generator to Write Winning Ad Scripts
Переглядів 3086 місяців тому
Writing winning ad scripts can be hard. In this video I'll show you how to use Tiktok's AI driven Creative Assistant. Use use proven ads to create scripts for your digital advertising. 0:10 Accessing Tiktok Creative Assistant 0:18 Why isn't TikTok Insights loading? 0:40 TikTok Creative Assitant - What can it do? 1:03 Filtering the Tiktok ad library to find inspiration 1:32 Selecting inspiration...
Product Positioning Strategy - Team Exercise Example [Free Template]
Переглядів 2959 місяців тому
Product Positioning Strategy - Team Exercise Example [Free Template]
UTM Parameters: What they are and how to use them in Google Analytics (GA 4 )
Переглядів 21611 місяців тому
UTM Parameters: What they are and how to use them in Google Analytics (GA 4 )
Project Management: Marketing Team Meeting Agendas with Slack & Asana
Переглядів 83911 місяців тому
Project Management: Marketing Team Meeting Agendas with Slack & Asana
How to: Use Midjourney AI for Marketing Images & Moodboards (setup, prompt, pro tips)
Переглядів 3,4 тис.Рік тому
How to: Use Midjourney AI for Marketing Images & Moodboards (setup, prompt, pro tips)
Marketing Team Roles and Structure for Startups, Small Business or Internal Agencies
Переглядів 877Рік тому
Marketing Team Roles and Structure for Startups, Small Business or Internal Agencies
How to: Connect OpenAI ChatGPT to Google Sheets [FREE App Script Tutorial and Starter Template]
Переглядів 6 тис.Рік тому
How to: Connect OpenAI ChatGPT to Google Sheets [FREE App Script Tutorial and Starter Template]
How to: Write a AI Press Release with GPT-3 (or ChatGPT) & Google Sheets / Docs [FREE Template]
Переглядів 1,4 тис.Рік тому
How to: Write a AI Press Release with GPT-3 (or ChatGPT) & Google Sheets / Docs [FREE Template]
How to Build an AI Blog Content Generator with GPT 3 (or ChatGPT) + Google Sheets and Docs
Переглядів 7 тис.Рік тому
How to Build an AI Blog Content Generator with GPT 3 (or ChatGPT) Google Sheets and Docs
How to: Use a Keyword Research Tool for Content Planning
Переглядів 679Рік тому
How to: Use a Keyword Research Tool for Content Planning
How to: Connect Open AI (GPT-3) to Google Sheets
Переглядів 89 тис.Рік тому
How to: Connect Open AI (GPT-3) to Google Sheets
Create a Copy Deck - Free Google Doc Add-on - Template Constructor
Переглядів 1,5 тис.Рік тому
Create a Copy Deck - Free Google Doc Add-on - Template Constructor
Personal Branding - Power Up Exercises / Action Plan [FREE TEMPLATE]
Переглядів 2212 роки тому
Personal Branding - Power Up Exercises / Action Plan [FREE TEMPLATE]
Content Planning Tip: Map Your Content Ecosystem (FREE Google Workspace TEMPLATE)
Переглядів 6682 роки тому
Content Planning Tip: Map Your Content Ecosystem (FREE Google Workspace TEMPLATE)
How to Connect a Wordpress E-mail Form to Slack (without Zapier)
Переглядів 3262 роки тому
How to Connect a Wordpress E-mail Form to Slack (without Zapier)
How to Set Up Google Analytics with Tag Manager in Elementor / Wordpress
Переглядів 3,5 тис.2 роки тому
How to Set Up Google Analytics with Tag Manager in Elementor / Wordpress
How to Add a Contact List to Your GMass Message
Переглядів 7792 роки тому
How to Add a Contact List to Your GMass Message
How to: Use GMass to Send Bulk Email via Your Google or Gmail Account for Free(ish)
Переглядів 44 тис.3 роки тому
How to: Use GMass to Send Bulk Email via Your Google or Gmail Account for Free(ish)
5 Expectations for Personal Conduct (Work Ethic and Team Values) | How to Business
Переглядів 983 роки тому
5 Expectations for Personal Conduct (Work Ethic and Team Values) | How to Business
How to Host a Good Meeting (4 Simple Rules) | How to Business
Переглядів 673 роки тому
How to Host a Good Meeting (4 Simple Rules) | How to Business
cool
I'm only at 24mins out of 31... but couple Q's would love a video on, mostly in the space of refining and getting specificity from MJ -- But on the mockup stage, I'm trying to work out if can use a mood board given by a client for MJ to reference in building initial mockups for event theming and promo activations, I find I often have something in mind I could create from scratch in PS but clients want everything yesterday, or the idea is just for a pitch so I want to say time if its not a job I know I have yet, and MJ has been kind of helpful for this - issues being I will have mood boards and specific ideas before going to MJ but find it hard to put the image in words (I use GPT and individual images from the moodboards to do that visual elements to text description part for me sometimes) but also often after the first generated response there's one or two versions that are close but I have like 2-3 minor specific changes I want, but I can't work out the vary region tool, sometimes it does what I ask, and other times its like PS generative fill in its first iteration, or just ignores the region vary request all together or varies outside the selection?
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.
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
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.
"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?
It is because they have deprecated universal analytics. You can only create a Ga4 property now
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?
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
Perfect thanks <3
what best mode v6 alpha or which one ?
hello
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
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.
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
This guy sure walks a lot!
Now we talkin'. This good content, man!
Awesome tutorial have been considering this for socials
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.
How do I add just a couple of names
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.
Nice :) thx
Brilliant! Is there a way to get it to work with GPT4?
Yep - use the most recent version of the AppScript github.com/rocktrembath/chatGPT-google-sheets/blob/main/appscript
Sirrrrr thank you so much! I was struggling. Suscribed!!
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?
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
not working for me when clicking the sidebar buttons, nothing happens.
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
Are you able to use your own existing images and have the program create backgrounds?
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.
hello is it possible to do the same thing with our artificial intelligence? anyway thank you very much for your videos
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
next level efficient content. you deserve way more subscribers. keep up
Thanks a bunch this will help out my in-house system I am building.
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?
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
How to do this with bluewillow or mid journey
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
Super helpful! Thank you brother!
I was thinking your going to manipulate some spreads sheets with AI prompts
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.
"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?
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.
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??
Last I checked, If you're paying for the ChatGPT plus, it doesn't include api access, so you need to pay separatly yes.
Great vid ! Awesome tool for the tool box. Thanks Rock !
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 ?
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!
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?
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
Thanks so much @Rock Trembath! Love your systems and process management techniques. Looking forward to your videos for steps #4 and #5 . 😀
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.
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.
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 🙂
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
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.
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 ?
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.
Thanks for this! Amazing!
Depending on the chatgpt prompt, it's not unfair to assume you can pull in factual data right????
Yeah. It's generally decent. I'm just not taking any responsibility for saying that it's correct 🙂
I love these generator videos! Anymore?! you've earned a subscriber!!
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
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.
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!
Hello Rock, if somone has already been a plus user, do they need worry about the cost by using DaVinChi?
Is it possible to replace davinci model with text-curie-001? If yes, how?
Change the model name in the AI function to 'text-currie-001'
Hi how to use it for GPT-4 ?
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 🤷♂️
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"
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)
Exactly what I needed! Thank you so much for all your work
Umm this is super amazing, I love it. Thanks so much! If I have feedback after I implement I'll let you know. 🙋🌟🤓
my api key is expired what should i do
Go to your Open AI account and create a new one
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?
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.
This was cool 😎. Thanks