Transcription
Guys, hello everyone. Now I will show you how to create your own content monitoring system, thanks to which you will receive mountains of ideas for your niche daily. What competitors are filming, what are their views, how many likes, comments they had yesterday. And you can take, you see, my system is working now, and I receive a message about who filmed what, how many views they had, what the topic is. You can immediately go to their channel, watch, and decide whether to film similar content or not. This eliminates the "blank page" effect, and you will have a mass of ideas for creating your content daily. Creating this system is quite simple. Now I will show you how to assemble this template. You can repeat everything after me, or you can download this template and install it with one button. Well, here at the top is "import from file". You click it once, and everything is ready. You will only need to configure it. You can get this and other templates in my club. Templates for agents, for publishing res in Instagram, templates for publishing content on VKontakte, for AI assistants in Telegram, and so on. Templates are added weekly. You can also ask questions if something is unclear. Well, if you don't want to bother with the technical side of content creation at all, I have created a content machine on a monthly subscription. I will also leave the link in the description, thanks to which you can literally, well, connect and start using it in 15 minutes, get content monitoring, create content, and publish it on social networks. The same link will also be in the description, so go ahead, check it out, and of course, subscribe. I also periodically publish free templates in my Telegram channel. The link will also be in the description. Well, and we will proceed to create this template. Now I will do everything from scratch as well. I am creating a template, or rather, downloading a template. And here it is ready. For this, we will need, I have already prepared a summary here. What will we need? We will need Telegram for business. Well, here for "dosa" it will not be needed in this template, so I will remove it. Telegram is free. Telegram bot is also free. The N8N platform. You can install it on your server, on your hosting, and pay 210 rubles per month for it. Or you can use a cloud solution for 24 or 29 dollars per month, but I have it installed on my hosting. The link to the hosting will also be attached here, in this template. And under this video, there will also be API keys from AirTable. How to get keys, I have a separate video for that too. The link will be in the description under this video and in the description in the template, if you suddenly need to know where to get something. Also, how to create a bot, I have a video on the channel, the link will also be under this video. And here in the template as well, when you are assembling it, so that you don't have to search everywhere, so that everything is in one place. And we begin. In order to run the template by time, we will need the first node, trigger "cron", that is, a time-based launch. You can install it using the plus sign. Find it here, and here, here, here, here, here are the triggers, you see, a lightning bolt at the bottom. Go in here, and here we have these clocks. Click, and we get the cron node. Where, where here you set the frequency with which you need to run this process. It currently runs every hour for me. We will set it now. Not every hour, because every hour is currently set with the content machine. Since this is a mass product, the system accesses the table and monitors who needs to receive what content. And when you do it individually for yourself, you don't need this. Therefore, here we set it to run every day at a specific time. To do this, set the time. I will set 11 o'clock now. Well, you can set it to 09 o'clock, 10 o'clock, if you need to. So, here you set your time. And the next node we need is to get the YouTube channels that we need to monitor. For this, we will use AirTable. You can also do this through Google Sheets. But AirTable is a bit more convenient, especially if you are doing it for yourself, then the free tariff, in principle, allows you to work absolutely for free per month. I will also leave the link to Airtable in the description. It will need a table with two tabs. This is "reference". Those channels that we monitor. For this, we will need the channel ID and the chat ID of Telegram, where to send messages. You can send it to yourself personally, meaning the bot will send it specifically to you, or send it to your group or channel. I have created a separate channel to receive monitoring, so that there is no mess in the bot. This is much more convenient, but you decide for yourself where it is convenient for you to receive it. Therefore, we need the channel ID and the ID of your group or Telegram bot. Everything else, in principle, is not needed. How to create a bot in Telegram? I have a video on the channel, so we won't cover this now, you can watch it later. But how to find the ID of the channel you want to monitor, I will show you now. To do this, go to the YouTube channel of the person you want to monitor. Go to their channel profile, expand the description, and at the very bottom, there is a "share" button. And here you will see a "copy channel ID" button. Copy it, go to the table, add a new "channel ID", author, link to the channel, content type, status, this is all optional. For this system to work, the channel ID and chat ID are enough. You can also get the template for this table along with the workflow template. It is also installed quite simply. Go to Airtable. Here on the main desktop, you have a "Create" button. Click to create a new table. And here you see how to create it. Choose CSV, choose a template. Install. Well, and here your template is restored. Also, add the second template here. Add a new tab, choose the second file "analytics", if you need analytics, of course. And install the second file. Rename them as you like. We have created the table. Next, we proceed to configure the Airtable node. To do this, click the plus sign. Find Airtable here as well. Select the API key from Airtable. How to create this key, I have a video, as I already said, so watch it. I won't dwell on this now. Here we select the "Search" operator. Then select the table we created, the sheet. And after that, click the "Test" button. Check how it works. We received 10 references, for which we will now monitor. That's it. The next node is RSS monitoring. Also find this node with the plus sign, RSS. Select it. And here we need to insert the link to the channel we want to monitor. The link will need to be assembled from a fixed part and a variable part. It looks like this. The fixed part of the link and the channel that is pulled from the previous node, that is, from the table we just created. And here we have received information about videos from those channels that we entered into the table. Video description, link to video, publication date, channel author, and video ID. There is one nuance here. RSS monitoring retrieves the last 15 videos from the channel, regardless of when they were created and regardless of the format they were filmed in. Therefore, so that our table does not turn into a dump and so that you do not receive a bunch of unnecessary content daily, we need to install a code node that filters only for yesterday. That is, after this code, you will only receive videos that were uploaded to the channel yesterday. You see, we received 150 videos at the input, and only nine come out. The next node takes one video, processes it, and returns it in a loop like this. So as not to overload the system, we take one video and process it in turn. The system sends you this video. Nine videos, it works in turns. Next, the YouTube node. And here we will need to configure it. I'm taking it out now. What do we need here? We will need to get API keys from Google. How this is done, I also have a video on the channel, so watch it separately. And then we will need the video ID. The channel ID is pulled from the previous node. And after we click the "Test" button, we get analytics for the video. A lot of unnecessary information comes in. Therefore, we also need to filter it further. We will filter it with a code node as well. First, it filters tags, brings them into the correct format so as not to get an error later. It's already unclear how the tags were entered. And here we cannot foresee anything. In order for you to always receive notifications in the Telegram channel, we need to bring the tags to a single format here. Therefore, this node first brings the tags to a single format, and at the same time extracts the video ID, video duration. The next node is saving. Here we save to our Telegram. Here we save the data we received to our table. Only the Airtable node, only the "Create" operator here. Create a new row. And here, whoever downloaded the template, everything will be configured for you. If you are doing all this from scratch, you choose where you need to get the data from. In this case, we get data from the YouTube node. And we need to get the video ID here. Here it is, video ID. Find it, drag it, and everything is ready. Well, and you drag everything else from the previous nodes. And after that, click "Test". And all this information is written to the table. Here we see the channel ID, publication date, video title, video description, author, link to video, duration, views, likes, comments, and so on. Next, we create a "Set" node. In this node, we create a file name to save it to file storage. And here we also save the chat ID. You can come up with any file name, but in order for it to be dynamic and always unique, I use this expression, which shows the current time in milliseconds. So it will always be unique. This is needed for us to save it to file storage and then delete it. Of course, you can immediately send it to Telegram using binary files, but as practice has shown, the preview from the channel that we download is not always in the format that Telegram accepts. That is, it is always different, and I periodically had errors, so I built in file storage where we upload, and after we send the file to Telegram, we delete it from there. This is also done automatically. Here we download the binary file. For this, we will need an HTTP node and a link to the YouTube video. We take this from the YouTube node. Drag it here, click "Test". And here we get the binary file. That is, if you look at the preview, then here is the picture, that is, the preview of this video, which will come to our Telegram channel. After that, we upload to S3 storage. In this case, I use Backet. The cost of this storage is quite ridiculous, but if you upload and download like this, it will be absolutely free, because they only charge for gigabytes. And if you upload and delete, in general, everything up to a gigabyte will be absolutely free. Here the files that we are about to download will go, and then they will be deleted from here. How to create this storage, I will also have a video on the channel, so subscribe so you don't miss it. Well, the link to Backet and to N8N itself, which is located here, I already have videos on how to install it, and the link is also in the description. For this, we will need the upload method here. Here in this node, you will need to specify your file storage, the file name that we pull from the previous node, and, of course, the keys that you create here. After clicking "Test", the response came that the file was uploaded. And then a message goes to Telegram. Click "Test". And here the message itself has been sent. For us to receive a beautiful message, that is, underlined in bold, we need to set the markup here in this node. How to set the markup? I also have a small instruction here in the template. Go in and choose which method you use. Markdown or HTML. And if it's HTML, then if you need to make it bold, then copy and paste "new video reference". There are insertions on the sides, and here is the text. That is, this comes in bold. The next node is code. I inserted it to guarantee the deletion of messages from file storage. This happens, at least it happened to me, that for some reason the previous deletion node was interrupted. It did not see what to delete, so I put this code. It guarantees to extract everything that was before. That is, we need the file ID and chat ID. That is, it extracts, and we get access to the file name and Telegram chat. File deleted. Well, that's basically it. Well, and let's run it now, let's see how it works. I click "Test". And here it goes. See? The videos are flying. One video, second video, third video, fourth. See, it goes in a circle and takes videos in turn. And we receive videos from our table in Telegram. And here we see who filmed it, what they filmed. Link to the video itself, video topic, duration, views, likes, comments. So, remember, you can get the template in my club. This template and many others. The cost per month is for the club. You can also ask questions there if something is unclear. If you don't want to deal with the technical side, then I have already created a content machine, including content monitoring there. So I will also leave the link in the description. Go ahead, study, subscribe. Subscribe to my Telegram channel, where I talk about how I create a content machine, what difficulties and obstacles are on this path, and periodically post free templates. So subscribe and see you in the next videos. y