Bulk Create YOUTUBE SHORTS Using CHATGPT, CANVA & GOOGLE SHEETS (Canva PRO Feature)

in this video I'm going to show you how to bulk create YouTube shorts using chat GPT canva and Google Sheets no hanging about let's get straight into it firstly open up chat GPT and let's get some content what I'm going to do is ask it to create a list of 30 facts about the world put it in a table with two columns in the First Column put the number order of the fact for example Fact one fact two fact three Etc in the second column put the actual fact so hopefully that's clear then I'm just going to press enter and as you can see it's creating a column one and column two you'll see why it's important to create a table shortly so once that's done I'll copy and paste this into Google Sheets it actually stopped generating Midway through fact 28 but that's no problem I can just ask chatgpt to continue writing if I wanted to finish it off but for the purposes of this video I can just use the 27 and a half facts we have here so what I'll do is I'll scroll back to the top highlight both columns then click copy and then head over to a Google Sheets document right click or just paste that in as you can see the two columns are pasted in what I'll do is just so that you can see it I'll just make the text black and just remove the background color so you can see it there you go lots of data in a Google spreadsheet now I'll just click on the title and rename this document I'll just call it World facts click away to save that now click on file download and save it as a CSV file comma separated value you need it you need to save it in this format so that we can input it into canva so head over to canva now I'm going to create a YouTube short so I'll just search for YouTube short template now I'll choose one of these standard templates they have because this is a video about world facts I'll just choose this one or you can choose any one and I'm going to customize it anyway so once that loads I'm just gonna delete these three extra pages I don't need them I just need one page and then I'm going to bulk create 28 other Pages based on the facts that I created so I'm going to select this text now actually I'm going to change the video so I'm going to click and delete the video now I'm going to go to elements and I'm going to add in a video I have of the world spinning because it's a dark background I can put white text on top of it so let me just find that video here it is I'll click and drag that onto the page okay just reposition it slightly you can do that by double clicking it and then dragging it across just to get the frame incorrect so we've got some animated arrows at the bottom and then we've got an outline of a mountain I'll just get rid of the mountain because I don't want that I think I'll keep the arrows so I'll just leave that there the text looks okay it could be slightly more readable but for the purposes of this video I'll keep it as it is now I'll click on bulk create and upload my CSV file so let me find the file and upload it and as you can see it's picked up two data fields fact number and the fact so what I need to do is assign them to different elements because there's two elements I need two text boxes so I'm just going to copy and paste this and create two text boxes on the page I'll just make it slightly smaller because this is going to be for the fact number and this one's going to be for the main fact so what I'll do is I'm I'm going to shrink it because some of the facts are several sentences long so I'll just make I'll just make the text slightly smaller and push it higher up just to give it more space when it does generate the actual text I'll also move the arrows at the bottom now what I'm going to do is attach the text to it so right click on it click connect data and I'm going to connect it to fact and I'm going to click this left click connect data fact number let me see so this video is 16 seconds long I'm just going to shrink it down to about five seconds that should be long enough to read the facts one by one once that's done I am going to click continue and as you can see it's loaded all the facts in a list now you can upload all of them or just select the ones you want you see this fact at the bottom fact 28 that one didn't complete but I'll generate it anyway and now I can delete it here once it's created the pages and there you go 28 individual Pages created with the 28 facts so if I scrub along the timeline you can see the text comes in it's animated let me see I've got Fact one two and three yeah it looks like it's all fitted in nicely okay if you wanted to make one of the clips longer you can click and drag it as I did here you can also change the transition between them you can use a slide if you want I prefer dissolve because the world is spinning so it will look natural if it just spins and dissolves into the next video as you can see there are 28 Pages created I'm going to select the last one because this one didn't complete delete that okay as you can see fact 27 this one was quite long so it actually overlapped the bottom element so you can go in and adjust them if needed with a bit more foresight I could have predicted this and adjusted it before I imported it um but that's something you can just adjust as you go along as you can see the bulk of the work is created if you did want to change the video Behind any of the text you can go in and do that one by one if you want a quick and dirty way to create YouTube shorts this is it and it doesn't just apply to this you could do a YouTube shorts Channel about jokes and just get jokes from chat GPT or you can do motivational quotes and have the author instead of the fact number so you can have the author at the bottom and then a quote at the top and connect those two columns I mean once you're finished fine tuning it what you can do is click on share then click on download here make sure it's on MP4 now you can choose to download the entire thing this is all 27 facts but remember YouTube shorts you only have a maximum of 60 seconds so this is probably too long what you could do is download them either one by one or you can download five or six of them and this would be one short download that then come in unselect it then download the next bunch and that would be another YouTube short and then go in deselect those download another bunch and click done so you can download a bunch of them as one file or the entire thing then click download and you're good to go so there you go that's how to make YouTube shorts with canva chat GPT and Google Sheets I hope you found this video useful feel free to like And subscribe and I'll see you in the next one foreign

Channel: Learn With Seb

Views: 139,816

Keywords: how to make youtube shorts, how to make youtube shorts in canva, youtube shorts, canva tutorial, youtube shorts video, how to make youtube short video in canva, youtube shorts canva, how to make youtube shorts on pc, how to make youtube shorts video, how to create youtube shorts video in canva, bulk create canva, bulk create youtube shorts, bulk create youtube shorts in canva, bulk create shorts canva, bulk create short chatgpt canva, bulk create canva videos

Id: Mo-NtzRBE5M

Length: 8min 19sec (499 seconds)

Published: Thu Apr 06 2023