Home/Videos/Automation

Google Gemini 3 Pro Wrote My Entire n8n Workflow - 2026

By Ani BjörkströmPublished 26 November 20259 min videoAutomation

Gemini 3 Pro preview generated an importable n8n workflow JSON from a single prompt: run daily, read an RSS feed, limit to ten items, append to Google Sheets.

Transcript

0:00 In this video, I will show you how to use Google's new Gemini 3 Pro preview to create an NA10 workflow. So, we will start with asking Gemini to create the NA10 workflow. I'm using this promp that I actually generated via trag. So, here you can see I'm saying create a complete N10 workflow in JSON. It should run daily with schedule trigger. Read an RSS feed from URL. And here you can see the URL that I'm giving it. Limit the result to 10. append the item to Google sheet. So the idea here is that I'm creating content in YouTube and I want to know what are the contents that are most hyped in YouTube. That's why I want to run this workflow in YouTube daily so that I can see what are then the nan or tech or I related content that gets most views.

0:47 And you might ask why am I using uh Google's errors feed instead of using Google's API or YouTube's API. So the reason is that this area feed is totally for free. You don't need to use any API key and it does the job because from here you can get the most hyped videos also from YouTube. [snorts] Let's now go ahead and run. We can give a couple of seconds to Gemini to give us the whole code. And also if you don't know this model is totally for free. It was released about a week ago and it is super powerful to create different type of applications that are powered by generative I. And here you can see that it is giving us a prompt in JSON and it even explains what we need to do.

1:35 So you can see that involves schedule trigger and then it involves Google sheet note. Okay. So from here we will basically just download this JSON workflow by clicking on download button and then we will go to NAN. So we will log in into N. You can see that I'm running anything locally. If you are interested and want to know how to run anything locally totally for free, I have another video about this that I will link down below. But right now what we will do, we will create a new workflow and then from here we will click on those three dots and we will choose import from file and then we will scroll down. We will get that file that we have just uploaded from Google studio. We will make sure that it is the right file and then we click on open. Okay.

2:25 And now we can see the workflow. We can see that the first one is schedule trigger. The second one it says that it's feed rate. However, the node wasn't actually created. Then we have limit to 10. And then we have Google Sheets and then we have set columns and we will then go and choose RSS feed. We will click on plus button. And from here we will search for RSS rate. [snorts] And then in here we will use the RSS link that we already sent to Google I studio. So we come back to Google a studio and from here we will get that link just copy this one and going back here we can pass this one and this link also can be updated for example you can see that here I'm saying that it needs to look for keywords in YouTube that are in it and then I tools or software then I'm also using the location US for example If you are located in another country and you want to know what are then the most viewed YouTube videos in your country.

3:34 So then you will update US to your country. For Sweden it will be for example SE and then also you can even update the language. But in this case we are just keeping this as it is. And let's try and see if this works. If I click on execute setup we can see that it doesn't work. And the reason that it doesn't work because there is another node before this note that is not working that is called also set columns. If I come out of this you can see that yes it was automatically connected to this set columns but we don't want to connect it there. So let's just double click on this one and test again see if this will work. And we can see that this worked and here on the right side we can see the output title. We can see that for example the first one was viral infographic with nano banana pro and it framework for YouTube. And then if we go to the right side, you can see it was published today.

4:22 You can see even the content. And if we do a quick test, copy this one and we go to YouTube and try to search this the name of this YouTube video that we got as published today and was viewed. So this is the video and we can see that was published 13 hours ago and it has 495 views. We go back to anything. Now we know that SS read is working. So we come out of this and we will just delete this question mark and we will put SS read in here. Then we will connect the schedule trigger. After that we have limit to 10. So here the idea is for example we got 19 different results and we just want to watch most watched 10 videos.

5:08 So we want to limit it to 10. That's why we use this note that is called limit to 10. And if we double click on this, you can see that max items is 10 and it also says keeps first item. So this was also totally correct configured by Gemini. Then you can see even that was connected to Google sheet. If we double click on Google sheet here, we obviously need to connect this to a Google sheet. So we need to first go to Google drive and create a Google sheet. And that's something that I have already done. And now we need to connect this Google sheet to our document. So we will click on choose and from here we will choose the document that we already created in Google drive and for me the name of the document is Gemini 3.0.

5:55 So we'll choose that one and then the sheet is basically the first tab in the Google sheet. So in here you can see that I have only sheet one. So that's is what we will choose. Okay good. And then we have title link and basically we have all the output names that comes from limit to 10. And in order to do the mapping now we will click on execute previous note. We can see that there is a problem. Okay. So what we will do? We will come out of this. We will save this workflow. And here you can see the limit to 10 didn't work because it wasn't connected to feed. So now after we connected that one if we go to Google sheet double click on that let's try to execute previous node one more time and here you can see that it worked.

6:48 So now we need to do the mapping from here we need to drag and drop it in here in this title and then link the same thing we need to drag and drop in here and then pop date which is publish date we need to drag and drop in here. Then we have content. We do exactly the same thing with content. Then we have content snippet. Same in here. And then we have ISO date. That is the date in ISO format. Okay. So that sounds good. And let's try to execute this tab. Yeah. So you can see that we have even an output. And let's try to click on this link. And we can see that it is leading us to YouTube.

7:33 So we are basically landing on the YouTube video. And from here we can just watch the YouTube video that was published during the last day and got the most top views. Great. So now if I come back to anything we can come out of this delete this set column because we don't need this. We have an workflow that was working. And if we try to reflect what Google Gemini Pro did, it created schedule trigger created limit to 10 and also Google sheets. to set columns wasn't linked in this case. We can delete that. And RSS read wasn't created either. So we need to choose this RSS read on our own. So I will rate this maybe 80% accurate. And this definitely made the process a lot quicker for us. But we can't say that we can use Google's new model to create N without any manual updates.

8:23 At least when we are giving this shorter prompt, if we ask chat GPD to create more detailed prompt, in that case maybe any flow can be better. But yes, that was it. And if you like, I can send this anything workflow totally for free. Just comment n down below and like this video. Have a good evening. Bye.