Repurpose your content over and over again using this automated system.

So this is a really good overview of the first couple parts of our system, which is the input and the database. And it really comes down to thinking about, okay, what are those different source pieces of content? Are they a video? Are they an image? Are they a community post? Is it a voice note? And not only that, but what is the mechanism that gets them into the database itself? Is it a form that you just manually fill out and upload? Is it an automation? So now we're starting to understand and abstract a bit about how to manage this system, get stuff in, what type of content is it and we're creating the database to actually store it all. And we're starting to think through, okay, how are we actually going to get that content into the system itself? All right, cool. So now we have demonstrated the input and the database side of our content system in order to just multiply our content and reuse it and repurpose it. Now we need to start talking about production. And obviously when it comes to production, any one of these things could be done manually, right? If we could take our database, we could take texts, we could take video images and somebody could produce something manually and then put it back into the system. And I think that's always an important part of your process, whether it's review or, you know, adding on or whatever that might be. That's an important part. In this video, we are going to focus on the automated part. So let's just keep pushing this forward a bit and be patient as we kind of build this out because we're going to do some really cool stuff here. This is going to get super cool. And once we build this out, you're going to feel really empowered to repurpose your content in as many different ways as you could imagine. So first, let's just start with some basic examples here. So we've got this video. So in other cases we have copy already, which is great. We could use that in a number of different ways, right? We could maybe take this copy and, you know, create a carousel or whatever with repurposing video with automation. Typically, the first thing that we're going to need to do is to convert it to text so that then we can do something with. And then once we have some text, we'll create some other automations that convert the text into carousels or video carousels or some Twitter posts. And we'll just do that in just a few minutes. But first we need to convert that video into text. So the next thing I'm going to do here, let's make this a little bit smaller. And over here on the views here, I'm going to rename this to content. And then I'm just going to adjust these columns a little bit. At some point we might need to create new views or hide some fields or shrink things a bit, just so we can fit it all on the screen. I'm going to go ahead and delete some of these rows that were here originally. And now what I'm going to do here is I'm going to add a new column. I'm going to go ahead here and say link to another record, and I'm going to create a new table and I'm going to call this table transformation actions. And then we have to name the table and I'm going to name it the same thing. And right here for allow linking to multiple records, I'm going to turn that off. There are some advanced ways that we could use that later, but to keep things simple for now, I'm going to go ahead and just create it just like that. So we have this new field here, which allows us to add transformation actions. And if you jump over here, we're going to see we have that new table here. So we have a name and then we also have a reverse lookup field, which is going to show us for each one of these rows that we create, which piece of content is it connected to? So I'm going to go ahead and rename this column to action name. We'll leave it as a single line text. And then I'm going to go ahead and hide this. We don't really need to see that. Hide, and now I'm going to go ahead and add an ID here, and you'll see why in just a little bit. And again, I'm going to use an auto number and I'm going to say ID, I'm going to say create field, and then I'm going to go ahead here and I'm going to type webhook URL and you'll see why I do that in just a second as well. This is going to be super cool when you see how this works, create field. And then what we're going to do here is we are going to name this action name media to transcription. And then I'm going to go ahead and adjust the columns a little bit. So now what we're going to be able to do is we're basically creating a bunch of different actions that we can apply to our content that will run an automation by calling this webhook to do whatever this action is. So in this case, we're creating an automation to convert media to a transcription. So in this video, we might also create an action for text to blog or text to carousel, or we might do carousel to video, or we might do text to 5X tweets. So now what we've done is we've created five different actions here that we can go to our content and we can say, all right, for this particular video, let's go ahead and perform this action, which is media to transcription. And what we want here is that when we add this, it's going to fire off a request to this remote webhook on make.com to perform that action. And then when it's done to come back and update this row with the results. So in this case, media to transcription, it should download this media, create the transcription and write it back to air table, and then remove this here so that we can then perform other actions on this content or really any other content that we are working with. So let's go ahead and build this one out before we move on to any of the other actions, just to show you what this would look like. So first up, I'm going to come over to make.com and I'm going to create a new scenario. And in this case, I'm going to add a new webhook, custom webhook instant. I'm going to create that webhook, going to go ahead and click save. And now that webhook URL is here. Now we can call this, I'm going to go ahead and copy it to the clipboard. And then you have to make sure to click. Okay. And we're going to come down here and click save. And then I'm going to come back to our air table and we are going to add that webhook right here. And now that we have that webhook, I'm going to come over to content and I'm going to come over to the transformation actions. And I'm going to go to this little carrot right here. And I'm going to say, add lookup field. I'm going to go ahead and bring all three of these into the content table. I'm not sure if I'll need them all or not. I'm going to add those three fields. And then what we're going to see here is that when we apply one of these different things, those lookup fields are auto-populating with the content that is related to whatever we select. So we can see that we have the action name that is from that table here, and we have the ID that is from that table here. And we have the webhook that is from that table here, which is related to the one we actually selected. Now we don't need to see these particular fields in the main view. So I'm going to go ahead and hide them. Just like that. And then I'm going to go ahead and continue to build out the automations to actually trigger this remote webhook that we actually created. So to do that, I'm going to come over here to actions and I'm going to go ahead and create a new trigger. And I'm going to use when record matches condition. And I'm going to go ahead and select a table and I'm going to click the content table for the condition. I'm going to say when the transformation action is not empty. So what that's going to mean is, is that anytime I come here to the transformation actions and select one, well, that's going to say, well, this column is no longer empty. And so it's going to trigger this automation to run. And so if I choose a record here, we should see a few different options here. They all have video, which is good. I'm going to pick this row here, number 10, and then we have to actually do something when this is triggered. So I'm going to come to this step here. I'm going to run a script now for this script. I'm going to copy and paste this from another project. Last week, I did a video on converting mid journey images into videos with Luma labs. So I'm going to come here and grab the script contents here. I'm going to edit the code. I'm going to grab this. I'm going to come back to our automation here. And before you try to copy this, let me go ahead and update everything that I need to update. And then you can just pause the video and copy everything. What we need to pass to this web hook is the record ID that is triggering it. So we want to know, is it this record or is it this record or is it this record? And we also want to know the transformation action. And we also want to know the web hook that is associated with this, because when we start to build out this automation pretty quickly, what we're going to do is we're going to create a route that will do different things depending on what transformation we're trying to do, right? So for the media to transcription, we're going to go down this path for other automations. We're going to go down those different paths. So hang with me as we build this out, going to come back here to the automation. So I'm going to need to add a couple of variables here. We need the record ID. As I mentioned, keep in mind that the case matters here. Record uppercase I lowercase D for the value. Go ahead and click this button here and add the record ID for the name here. I'm going to go ahead and put action ID and for the value. And again, pay attention to the case action, uppercase I lowercase D. And for the value, I'm going to go ahead and click this blue button and make sure not to pick this ID here. I want to scroll down and grab the ID from the transformation actions. I'm going to go ahead and click in here and we're going to grab this value here. Now I'm just going to make a quick note. So in this transformation actions, we have the action name and then we have a unique ID. I could use the action name and pass the action name and then pass that into the script here to determine which path I go down. Now, the reason why I'm not using the name is because the name could change. What if I come back here and I change this name sometime? Well, it's going to be annoying because then I'm gonna have to come back to the automation and change the automation, which path was it, blah, blah, blah. In this case, because I'm using the ID, I can change this however I want. And the ID is not going to change. So I'll come back to the automation here, action ID, and then we've got the value. And now I'm going to grab the web hook URL, and then I'm going to go ahead and add the value. I'm going to click the blue button here. Let's go ahead and scroll down. Now we're looking for the web hook URL. It's not super obvious, but there's a little arrow there. You click on that and you're going to grab the value. And so now what we're doing here is we're passing in these three values from this record here. And if you remember, this record had these three values added because we added them from the lookup table up here. So back to the automation. Now the final thing we need to do is make sure that we're actually sending these two values and we're using this web hook. What this line does here is it gets these values right here and allows them to use this in the script. So right now we're saying we're basically calling a web hook. And so we're pulling in that web hook URL. That's this right here. And then we're patching in the record ID. And now we need to make a little tweak here because when I made this web hook call from the other application, we call that action. In this case, I'm going to call it action ID. And then we want to change this to action ID. So there we go. That should be good. I'm going to go ahead and finish editing. Then I'm going to come back and just edit again. It's good to finish. Sometimes you need to finish it before everything kind of syncs together. And now what I can do is I can come back to our automation here. I'm going to change the name real quick. I'm going to call this our transformation actions. I'm going to come down here and save everything. Then I'm going to go ahead and run once. Then I'm going to come back to Airtable and our automations. I'm going to test this. This is going to send the record ID, the action ID, and then it's going to use this webhook URL to get us a message into make so that then we can actually build out our automations. So let's check it out. See if it works. Test. There it came through. We can open that up and now we can see here we have the record ID and the action ID. Perfect. So next, every time this runs, we are going to need to look up that record ID, right? Because first thing we need to do is actually open up this record and get all of its data so that we can do something with it. So every time this is called, I'm going to go ahead and do that. So I'm going to add another module. We're going to add an Airtable module. We're going to get a record. We're going to choose the right connection. We're going to add the base. The base is project 10 X. The table is content and the record ID is going to come from step one here, record ID, and we'll go ahead and click. Okay. And now the next thing we're going to need to do is actually do a route so that we can start to only execute on the route that was actually sent to us. So now I'm going to add another module. I'm going to go with flow control and we were going to pick a router. And then for the first route, we are going to come to the condition here and we are going to use this action ID and we were going to say equals to one and we'll go ahead and click. Okay. Now we can start to build out the rest of this automation that is going to convert the media into a transcription. So like, what do we need to do next? So when we load this record here and we open this up, we have the videos. So we have the video URL here. So the only thing we should really have to do is use chat GPT whisper to convert that video into a transcription. Now, again, the only thing you do need to be careful about is, is that video larger than 25 megabytes? If you are processing larger videos, then you are definitely going to need a, another module like cloud convert to do that. In this case, my video is just 10 megabytes, so I'm not going to have an issue. So I'm going to go ahead forward with adding in chat GPT, create a transcription. The connection will use my existing connection. If you don't have one, you'll need to add one. So now in order to use chat GPT whisper, now that I'm seeing this, we actually have to download the file. So it will not allow us to just simply pass in a URL like this. We actually have to download the file and map it in. So in order to do that, we're going to come right here. Let's expose this a bit more. And then we're going to add a module right here, add module. And then we're going to type in HTTP. We're going to get a file and we're going to grab that URL from air table. We're going to jump over to the videos. We're going to expand that. We're going to grab that URL and we're going to click OK. And now what's going to happen is we're going to have the data here. So if I come back to whisper now, it's asking for that file. We can just put it right here and we don't need to add a prompt. We can go ahead and click OK. Similar to what we did with the voice notes. We're going to simply update air table here. We're going to update a record. It's going to use the existing connection. We're going to add the base. Then we're going to add the table content. And then we are going to update the copy with the result from chat GPT whisper, which is the text. I'm also going to do something else here, which is I'm going to try to update the transformation actions and remove the field here so that after it runs, it clears this out so that we can apply the next transformation action. I might have to experiment on this a little bit, but I believe if I open this up and I add a null value, so I'm going to select in here and then I'm going to come up to these controls here and I'm going to add a null value. I believe that will send it back to just empty. We'll see how that works. Going to go ahead and click OK. Actually, it's I didn't put in the record ID, so I got to add that. That's coming from the original step. Going to go back to the controls here, come to the record ID, and then we'll click OK. We'll go ahead and click save. I'm going to use this little magic button here. It's going to realign everything for me. I'm going to run once. I'm going to come up to our test. I'm going to go ahead and test. Jump back to make to see this run. Downloaded the file. Looks like we had an issue here. So it's not recognizing the file type. I'm going to come in and do a map instead of get a file so that I can actually pass a file name. And then I'm going to put a dot MP4. Let's see how that works. Sometimes you have to troubleshoot some of this stuff. Go ahead and click OK. I'm going to go ahead and save that. And then I'm going to go ahead and click run once. Going to jump back to Airtable and then we're going to trigger this again. Nothing's ever easy, but that's the kind of stuff you have to be able to navigate. So we downloaded the file. Now it worked. Now we got another one. So it doesn't like that null value there. OK, so I'm going to come back. So instead of doing this, I'm going to remove that. I'm going to click the map here. And then what I'm going to do is I'm just going to pass an empty array. What that means is I have an empty array here, which is the open bracket and a closed bracket, which should clear that out. That's another way to handle this. I'm going to go ahead and give that a try. Go ahead and click OK. Go ahead and click save. And now if I come back to the data here, we should not see the copy because that errored out. So let's come back to make. I'm going to go ahead and run once and come back to the trigger. I'm going to trigger that again and let's cross our fingers transcription still having an error with that. It's not a valid record ID. I'm going to try one more thing here before I just do something different altogether. I'm going to come in here and just add a null value, put null in that array so that there's some value in there. I'm going to go ahead and click. OK, that doesn't work. I'll show you something else. I'm going to go ahead and save it. Going to run once and I will come back to air table and we'll trigger that again. Do the transcription. Ah, another error just doesn't like how we're doing that. So instead of doing it that way, I'm going to go ahead and come in here and I'm going to remove this here. Just leave that blank and turn this back off the map so that we're not really messing with this at all. I'm going to go ahead and click. OK, and I'm going to go ahead and click save. And then what I'm going to do first, I'm just going to run this and see if it's working. The transcription part of it come back to air table and we'll test it with the transcription. This time it should update. No problem. If I come back to the data now we have that transcription. So now I'm going to handle this a different way. I'm going to come up to our automation. This is working. And so what I'm going to do is I'm going to update that here. I'm going to update the record and go to the table and then go to the record ID, which is going to be this one here record ID. And then I'm going to go ahead and choose the field. In this case, it's going to be transformation actions and we're just going to leave it blank. And then that should solve our issue. I just click this here and I'm going to run a test is what I really want to see is this to disappear. And I'll tell you why I run this. OK, now it disappeared. Once I turn this automation on now and we're going to call this the trigger transformation action. And once I turn this on and then I turn on this automation here, you can see what's going to happen. I'm going to come back out of this automation. I'm in the edit mode. I'm going to step back to just view mode where I can see things that are actually running. And then what you're going to see here is if I come back here and I say media, let's let's remove this media to transcription. This is going to trigger. See, it's going right now. That means if I jump over to make it's happening, right, it's going to run, it's going to update and then remove that. Now I can call the next thing. So now I can say, OK, now let's turn this text into a blog.