Microsoft Power Automate Desktop: Hands On Building Automations

1. Course Intro: Automating your favorite social media platform has never been easier. My name is Greg or marriage and I'm going to show you how to automate your favorite social media platform. I have been working in automation for the past decade, working for companies like PwC, EY, and Accenture, where I learned the tools of the trade in my journey, I have automated pretty much any process that you can think about from on-boarding and recruiting all the way to social media. I have worked for large enterprises and small companies as well. Since I have opened my own company, I have seen the need in first-person to automate many social media activities that we run. That's why I have created this video to show you how you can easily with Microsoft Power Automate Desktop, a free tool, how you can easily without any code, automate any activity or task that you perform on your favorite social media platform. It's going to be great. In this course, you will learn how to use the Microsoft Power Platform, microsoft Power Automate Desktop, which is going to allow you to create all of these amazing automations. This platform is completely for free and should be installed by default on your computer. This course is special because it's going to be a hands-on course. I'm going to pick examples and real-life scenarios where we are going to automate actual processes that are going to give you benefits straightaway, the course is structured in a very simple, easy to follow along manner. We're going to begin the course by understanding the tool and just taking a short walk through. And then we're going to dive immediately into the examples where we're going to see how to use this tool to create some amazing time-saving automations. The ideal student for this course is anybody that is spending time on social media. If you're spending time on social media, either looking for leads or posting to different groups or unfollowing or falling friends. While this course is perfect for you because it's going to allow you and teach you how to automate those activities so that you can replace them by a robot and free up your time and go and enjoy life. Instead of sitting in front of a computer doing repetitive tasks. I'm super excited about this course. I hope you are too. Let's jump right into this course and start right away. 2. Course Roadmap: Robots have been working on social media. Since social media has been invented, there is already thousands and thousands of robots making posts, commenting, liking, and so on. You don't even know when you engage on a post, if you're engaging with a real person or if you're engaging with a robot. The downside is that most of these robots have been really hard to build using Python code, selenium libraries, and so forth. And you had to have very specific set of skills to be able to do automation in social media or just build automation for the web with the creation of different tools, local tools. This has been democratized and pretty much anybody that has the interesting can create automations for the social media. Before we jumped into the different workshops that we're gonna be building in this course. I think it's a good idea to have an understanding at a high level of what we're going to cover in this course and what is going to be the logic of how we're gonna be learning the different things. In this short video, we are going to have a couple of minutes of overview and introduction into the different topics that we're gonna be covering. I will share some tips, suggestions, and guidelines on how to best capitalize on this course and how to best use it for yourself. With that in mind, let's start by thinking different. We have start thinking differently because we're not going to be using our manual time and our manual resources to use social media. So if we need to post a post onto different groups, if we need to unfollow a 100 people, if we need to do different things. Now we have to start thinking that a robot can do this for us. With automation. We can save lots of time. And we can also reach a lot of people, way more people that if we were to make the pose ourselves or if we were to like or comment on different pictures ourselves. These are just a few examples of different things that robots can do. Another main important why we have to start using automation right now is because it has been extremely easy and most important, free to use. Microsoft has came out with Microsoft Power Automate Desktop. And Microsoft has made available this technology on all licenses of Windows 11 for free and already pre-installed on their machine. If you're running an older version of Microsoft like Windows ten, then you can download this tool for free from Microsoft shop. This tool is an amazing local tool that allows you to automate pretty much any task that you are performing on the computer. It is a drag-and-drop tool were no code will be learned to use this tool. Only drawback is that you have to use a Microsoft account. So if you haven't signed up for Microsoft, it's entirely for free, but you don't need to sign up for Microsoft so that you can log into Microsoft Power Automate Desktop. The roadmap for this course is very straight forward. In the beginning of the course, we're going to understand a little bit about what automation is, how to use Microsoft Power Automate. Where are the different components located on Microsoft Power Automate and just get familiar with the platform so that when we dive into the workshops, we can follow along and go fast without stopping on different functionalities. I think the best way of learning is with a hands-on training where we actually build the processes that we can use straight away and immediately get benefits from these processes. That's why I have structured this course with a really short introduction just to get a hand off the platform and then dive into building the processes ourselves. A couple of tips and suggestions before we dive into this amazing journey is that you should follow along with all of the workshops that we built. Now, the workshops, you can jump onto the workshop that you like the most and social media that you want to automate the most like Facebook, LinkedIn and so forth. However, I do suggest that you work graduate because they have been put together in such a way that they build up on top of the previous one. Therefore, if you complete one and then you go to the next one, the next one has some things that the previous one has. Therefore, I suggest you that you follow chronologically this course. In addition to this, should you have questions? Well to share? And also if you want to meet me and the community, I have shared the link to our discord server where we can connect and chat and answer any questions. Obviously, if you leave some comments and suggestions in the comments below, I will answer. However, if you want a direct line of communication with me and the community and you want to jump into discussion right away. I suggest that you connect to this call and that's it. We are ready to start. We are ready to dive hands-on into this workshop where we're gonna be learning automation on social media. I'm super excited and I can't wait to start. Let's start immediately. 3. Microsoft Power Automate Desktop Walkthrough: Knowing web automation in 2022 is a key skill to have. Everybody is doing some tasks or processes that are online and that need to be automated. In this video, we are going to be looking at Microsoft Power Automate Desktop 2022. Key features and functionalities to understand how best to this tool works, where everything is located and how to use it to build all of the amazing processes that we're going to build later on. This video is very important because it's going to allow you to familiarize yourself with Microsoft Power, Automate Desktop key functionalities and features so that when we dive into it, you will not feel lost. I'm very excited about this. Let's dive into this video right away. Once you install Microsoft Power Automate Desktop, you are going to be presented with this. Well, you're not going to have any flows that I have here. You will have this screen. To give you a short overview. In the top, we have the main features that we're going to use. Well, what we're going to use most of the time is to create a new flow in the settings we have some configuration regarding Microsoft Power Automate, one of the most important functionalities is this functionality that is going to allow you to stop any running processes. In addition to this, you should also check for updates once in a while to make sure that you are running the most up-to-date version in the Help tab, you're going to find some useful links, line documentation and getting started guide. It's a walkthrough for Microsoft Power Automate link to the community, the blog of Microsoft Power Automate and so on. That's pretty much everything that we have in our, in our configuration. The next thing that is new will match the Power Automate 2022 is this example right here. This example right here, I'm going to give you a skeleton process that shows you how Excel web automation and desktop automation war. There is quite a few interesting processes, so it's worth a look going through a couple of these, seeing how their belt, alright, let's create a new flow and see how we can create flows. We monks of Power Automate Desktop. Alright, so this is what our blank Canvas looks like. It looks a little bit confusing, but it's extremely simple. As I always say, there is no code involved, so it's everything is drag and drop. What do you mean by drag and drop? All these actions that we have on this left panel here. All these are the things that we can make our process do. Imagine anything that you are doing on a computer. Well, with all of these actions here, you can replicate pretty much all of those activities. There's activities for web automation such as opening a Google Chrome page or Firefox page, clicking on a button, extracting information and so on and so on. We have Excel automation, database automation, and many more other actions that can be used inside of our processes. So on the left side we have our actions. We can also easily searched for our actions if we think about something that we want to do. So for example, let's say we want to send keys. So instead of looking for it, we could just type in send keys and it would find this everything that could be related to that. This is very useful because if you don't know how to do something, you can maybe think about the world and try inserting it and see what comes. Actions come out. Now, let's try one of these oxygens. Let's try one of the most basic web automation actions, and that is to open a new instance of Google Chrome. So we drag and drop a new instance of Google Chrome. And once we drag and drop it, L configuration window will appear. Every action has a configuration window where we can find what the action that. So for example, in this one that we open a new Chrome, we can tell it to different things. So for example, we can open a new instance of Google Chrome, or we can attach it to the one that is already running. We can insert the URL that we want to open. We can open the window normal, maximize or minimize depends on how we want our automation to perform. We have some advanced options, such as clearing, cash, clear, and cookies, and these configuration parameters, they are different for each one of these actions. However, one thing that is same for every action is that there is always hope for the majority of cases there is a variable that is produced, a variable that is produced as a result of the action. And also for every action we can add an on error. On error is a way that we can manage our actions. So let's say it fails. Microsoft Power Automate Desktop fails to open a new window. So we can do have our process lose something in case of that happening. So that is what our error would do. We're not going to get into much detail about this. However, it is pretty intuitive and very straightforward. There is no code involved in any of these. These are our actions. So let's add an action and a link, maximize this link and save this. So we have our first step inside of our process. We can see that this is where a process is going to be built. We're going to be dragging and dropping different actions inside of this pain. And they're gonna be piling up one underneath the other. Another thing that we can see is that we have on the right side, we have our variables. We have our variables and we have a variable that has been created. It's the browser variable. So everything, all of the variables that we are going to create are going be created out of our actions. They're gonna be stacked up here and we're gonna be able to see the data that is contained in these variables. Variables are just like data containers are containers for some information. Like maybe you want to save the name of somebody that is going to be stored in the variable called name. So that's why we have our variables. In addition to that, right underneath here the variables, we have the UI elements. Ui elements are required if you want to integrate with different elements on a web page or on a web application. Let's see an example of this. So let's launch our process from the top. We're going to have some actions that are very important, saving our process. Remember when you first create your process, it is not going to be saved until you click save. If your computer crashes and you have built a full process and you haven't saved, you're going to lose all of your work. So remember to always save your information every time if you think it's required, then we have the button to run our process. Once we click this button, this is going to execute all the different steps that we have here. After that, we have the button to run the next action. This is good in debugging when we want to test the different steps one by one. And finally we have the record, but let's say we don't want to, to create our automation using the different actions. We can just record what we do with this button right here. So let's test our process. Let's click on run and see what happens, what I'm expecting to happen, and what has happened. Google has opened and has gone to the first page. Amazing, we have our first process. So the next thing to do would be to integrate or spy different elements inside of Google, we can use the recorder as we have seen previously. And by clicking on the record button, we're gonna spy different elements. This input text, we're going to right-click into it. We're going to add some text with IMV and we're going to search for process. Let's, we're going to add this text right here. And after that, we're going to click on this button right here. That is pretty much everything we want to do right now. We're going to click Finish, and we're going to see that some actions have been created for us already. And you launch new Chrome has been created an action to populate. Textfield has been created an a plus button on a web page. Now, if we look for these actions right here, we're going to find all of these actions right here. So we have a pause button on a web page. We have populate text with a specific text and also launched Chrome. So as you can see the recording just take these actions, captures what you are clicking and creates them. Going back to our right side of the panel, if we go in the UI elements, we can also see that there has been to UI elements that have been created for us. The first element is the input. We have a screenshot of it right here, and the second one is the Google button. It is good practice to remain these elements. So we're going to rename this search. And if we press F2, we can rename this element. We have renamed our UI elements. In addition to this, we can also see how our UI elements have been created. If we double-click into the UI elements, we can see that our UI element has been created in this method. So this is a way that Power Automate knows where to click on a webpage. It is using a hierarchy system that is taking all of the elements on a web page like this one. It is stacking them, stacking them and is designing the order of different depths. So this is how it knows. There's other ways that it can find the different elements, such as with a UI selector. So if we, for example, were to drag and drop this, and we wanted to insert or add a UI element. We could add it in a different way. So let me show you what I mean. So if we select this text, right-click on, on this text. We have created a new element. This element right here has a different selector. As you can see, it has a CSS selector. Microsoft Power Automate has now created a CSS selector for us to use. Now based on our process and on the automation, we can try to use either one. It's easier to do our automation. So let's remove this that we have just created. And also we can remove all of the unused UI elements. This is going to clear all of the elements that we have here and that we are not using. In addition to this, we also add the right side. We also have this right here, which is for images. If we're gonna be creating a process with images, we're gonna be using this to take screenshots and postpartum different images that we have inside of our process. Now that's pretty much it. Well, there's one last thing I want to point your attention to, and that is this pane right here, and this pin right here. This pin down here is going to tell you, the main thing is going to tell you the speed of which your process is automating or it's running. Currently, your process is running with 100 milliseconds. It's good practice while you're debugging to set this to 500 milliseconds so that your process is a little bit slower. Remember that once you reopen your process, this is always going to be set to default 100. In addition to this, here, you're going to know how many subflows Actions and select an actions to have inside of your process. In the subflows, you can add new subflows that are going to appear right here, or they're going to be grouped inside of this tableau menu. That is pretty much everything that we have to know. We have obviously the usual tools that are that are, that have been listed in the list is already previously. You can access the same tool from the menu in the top. That is, everything that is Normal. Microsoft Power Automate Desktop, an extremely powerful technology that allows us with no code to automate the most complex processes that we can imagine. And as a result, is going to allow us to save countless hours of time and free us from repetitive and manual tasks. Now once you master automation, that is on manual and repetitive tasks, if we add artificial intelligence, then we can automate pretty much anything. I'm really excited about the next workshops and the automation that we're going to build next. So let's go to the next video and thank you so much for watching. 4. Set up microsoft power automate desktop : Setting up Microsoft Power Automate Desktop is extremely simple. If you are on the newest version of Windows, you should have it by default installed on your computer. And all you have to do is search your computer for Microsoft Power Automate Desktop, and you will find it. If you're running an older version of Microsoft Power of Microsoft Windows, you will not have Microsoft Power Automate Desktop installed on your computer, and you will have download it and install it yourself. If you need to set it up. The first thing that you would do is search on Google for Microsoft Power Automate Desktop. Usually the first link is provided by Microsoft, and that is the link that you're going to have to click on. All you have to do is start your free version and download Microsoft Power Automate Desktop. Now you will download the installer, but at the same time you have to have a Microsoft account in order to use Microsoft Power Automate Desktop, download Power Automate installer. This will download in a couple of minutes and at the same time, set up a account on Microsoft. This is a free account that you will require on Microsoft, you can also use your office thing on a 60 account if you already have that setup. Once you have installed and download Microsoft Power Automate and you double-click on the installer, you will be presented with this screen. We have to login to Microsoft Power Automate in order to be able to use it. So before we created a Microsoft account, now let's use that email to log into Microsoft Power Automate. Once we input our login and our password, we will be automatically logged into the server of Microsoft, and we will be able to visualize all of the robots that we have created. This means that from any computer in the world, if we log into Microsoft Power Automate, we will have our flows available for us. This also means that you can also share flows with other people, but also that if you forget your account password and your email, or if you cannot access your account anymore, you will not have access to your robots anymore. So it's always good to back them up and always know which account you're using to log in to Microsoft Power Automate Desktop. One thing that we need to do right after installation, and that is go into the settings. In the settings we are going to click on the Show updates notification. This will show us automatically where Microsoft Power Automate Desktop has some updates. They will pop up for us and we're not going to have to do this manually. The other thing that you should do is you should configure how you stop running flows in default configuration, you have to click Control Shift, Alt and T to stop ending running first. However, you can change this, however, you want. Keep an eye out that this is an important functionality. If you're flows keep on running and you don't have a way of stopping them. The best way is to use a shortcut. That's pretty much it. We have set up successful in Microsoft Power Automate desktop, and now we're ready to create our flows. This was super easy, as it's going to be super easy to create some amazing flows that are going to allow us to save some time. Let's continue and see the other videos. How we're going to create some amazing automations. 5. Project 1: Twitter Bot (unfollow connections): How to build a Twitter bot in 2022 has never been easier. Unfortunately for Elon Musk. In this video, I'm going to show you how to create a Twitter bot in less than five minutes with the knowledge that you're going to gain in this video, you're not just going to be able to create the button that I will show you how to create. But you will also be able to create pretty much any ball. And the best part of this all is that we're gonna be using Microsoft Power Automate Desktop 2022 with the newest and greatest features or for free and available for Microsoft. No coding experience required. So let's get started right away. I assume that you have installed and download Microsoft Power Automate Desktop, which is available from Microsoft for free, and it's really easy to install. Once you have set it up, you will see something like this. Now after late update on my computer, I have lost all of my clothes. I have decided to start creating a series of videos. We're going to be replicating the majority of the flows that I had lost. So let's get right into it. We're going to create a new flow. In the new flow, we're going to call this elan with the bot. Let's create a bot. So what are we going to be creating? We're going to be creating a robot that is going to unfollow all of the friends that we have on Twitter. Now the idea of this video is not create really a robot is going to unfold all of our friends. But to show you how you can use the different features of this tool to create pretty much any kind of problem with the example that I'm going to be showing you right now. Alright, so once we have created our blank canvas, the first thing that we're gonna do is we're going to launch Google Chrome. Google Chrome. We're going to look for web browser automation right here. And then we're gonna launch actually Microsoft Edge. Alright, once we have launched microsoft Edge action from right here, we're going to insert the URL of Twitter that we want to go and automate. Now, let's save this. Let's test this out and let's just see that everything is working fine. And let's take it from there. It has opened a new browser and it has taken me to the homepage. Now, I can automate all of the steps of going to my profile and going to the following and following friends. Or I can just navigate directly to all of the people that I am following to this page and copy this link right here. Now when I go back to launch Microsoft Edge, I can replace this link. And by doing this, I have saved myself a couple of steps of automation. So that is great. We're already down a couple of steps. Remember, if your robot has less steps, the bar is going to work. Awesome. Alright, so the next thing that we have to do is click on this button. What is going to happen once we click on this, we're going to have a pop-up and then we have to click on this again. And that's when we're going to be able to unfollow somebody. Now, let's go back to our robot and let's integrate this into our automation. There is different ways that we can click on the unfollow button. Now the easiest way to do it is by clicking on the Record button. You can also drag and drop different actions. We're going to use the easiest way, since easy is good. Let's run this process and see what happens. So tutor has opened on the correct page. So the next step would be to unfollow all of these steps. Let's use the recorder and unfollow all of the different steps. So the first thing would be to unfollow different people. Not just one person, but unfollow different people. So the easiest way to do this, and here is a tip. You should not select the div or DVC charged, select the lowest element first and then work your way up and see what element works for your automation. So in this example, we're going to select the span. So we're going to click on unfollow and then cancel here. We're going to click on the next one as well. And you can see that I'm generating different events right here. So this is our recorder in action. And then let's click on one more. And just for good practice, Let's do one more. Awesome. Alright, so now we have four buttons. This is going to be important. Why? Because we're going to create a robot that's going to click on 1234567 until all of our, all of our friends have been unfold. Alright, so let's finish this automation and we have generated a bunch of steps. Now you can see that this tab has been recreated, so I can just use everything that has been generated for me by Microsoft Power Automate. That's great. Let's test this robot and just see if it works. Let's add a breakpoint here. We don't want to click on all of the buttons. It has launched and it has already clicked on the unfollowed button. So the next step would be to click on this and follow button right here. But before we do that, well actually let's do that straight away. Now, the next step is that we have to automate is to click on this button here. Now, again, there is different ways that we can do this week and record it. We can drag and drop. We can click with a mouse or something easy is to just send a mouse keyboard enter and have it ultimate like that. So let's do just that. Let's search for send keys. And we're going to send some keys. So right above our break point, we're going to send some keys and we're going to send. The enter key. We are also going to give it a weight of two seconds. So we're going to have it wait two seconds before sending the key is just to make sure that we're on the right page, or maybe three seconds. Alright, so we're going to open a new Microsoft Explorer. So we change this from attached to a running instance to launch a new instance. We're going to set it to maximize. And then we're going to click on the item that we've spine before. We're going to wait for three seconds and then we're going to hit Return. Let's see what this does. It opened successfully flow. It has clicked on the first page. It's waiting for three seconds and it has entered. So we managed to unfollow the first-person. Now, let's unfollow everybody else. So just as easily as we have done all of this, the next thing that we have to do is we have to create a loop. So let's create a loop. A loop is going to allow us to go to all different items and we're going to create a loop in the most efficient way possible. We're going to add in a loop right above this page. Here. We're going to add the number where the loop is going to start from. So the loop is going to start at 0 and it's going to start at one. He's going to start at 0, and it's going to end in ten, and it's going to increment by one. After that, we're going to move all of the different steps that we have created. We're going to move them inside of our loop. That means that they're going to repeat it ten times. However, there is one problem. Right now, our button, this button that we have spite of clicking the Follow button is just set. So this is just going to click on the first button is not going to click on all of the other buttons. Now for that reason, we have spied all of these other select us. Why have we spied all of these other selectors so that we can find a difference in them and we can understand how we can create a custom selector. This is going to be super easy. So pay attention right here we have span, spend to spend three and spent four. So let's go to span and let's take a look at this selector. So this is what it looks like more or less. Let's pay attention to these numbers right here and look for something that is changing. Now, let's open maybe span three and see the same numbers. Notice anything that has changed. Maybe I think there is a tool that has changed right here to be a 100% certain of that we're going to take this element, we are going to create a new one right here. And we're going to just paste the new element in there. Now when we see these two elements side-by-side, we can see that right here, there is a discrepancy or there is a number that is changing, is starting from 0 and it is at two. That means that this number is dynamic. If we change this number, we are going to be able to change our button to push on all of the different buttons. Now, let's do just that. Let's double-click on this, go into R or less, double-click on the bottom one is going to be easier. Go into the tool that we know it's a dynamic number right in there. Let's add the loop index. Awesome. We have added the loop index that is going to be from one until ten. That is a variable that is generated automatically when we create a loop, nothing complicated, it is extremely easy. Now we have created our first loop. Well, let's test this out and see if this works. I can also delete all of the other steps that I don't need. And we can try this process and see what happens. So it has managed to open Twitter as expected. It clicked on the first button as expected, and it also clicked on the ad follow. Alright, now it's clicked on the second one. It seems like it's working. So if the second one is working, so it seems that all of these are going to work. That's awesome, amazing, great. We have built a bot in just a couple of minutes that is able to unfollow all of our friends. Just like this, we can create all kinds of book that follow other people that copy, tweets, that copy, retweets that post on Twitter, and so on. Would you like me to create a specific Twitter bot, even though Elon Musk is not going to be that happy about it. Well, let me know down in the comments below. Thank you so much for watching and I will see you in the next automation. 6. Project 2: Facebook Bot (post to multiple groups): In this video, we are going to learn how to save time by automating the process on uploading to multiple Facebook groups. At the same time. You have to upload a post multiple Facebook groups at the same time. And are you doing it manually? Well, in this video, I'm going to show you how to use Microsoft Power Automate Desktop 2022, and how to do it using automation. It is going to be super simple. There is going to be no coding required. And we're just going to do it in less, probably less than ten steps. Without further ado. Let's jump straight away into building our automation and helping us save time. As always, we're going to start from a blank Canvas. I have already created a process called Facebook multi-page post, but it's an empty process. We're going to fill it up our selves. The first thing that we have to do is we have to start from a group of Facebook pages. So what we are going to be doing is we are going to be posting to multiple Facebook groups. At the same time. I have a list of all of the Facebook groups that I'm a member of in this Excel sheet, objective of the process is going to go to each one of these groups and make a post. The first thing would be to read the information on our Excel sheet. So to do that, we're going to look for Excel and we're going to read the information inside of an Excel. We're going to start by launching an Excel, a blank. We're going to open a document and look for the excel sheet that we have saved. Once we have inserted our Excel, we're going to save this and we're going to launch our Excel. The next thing is we have to read the content of our Excel sheet. So to read the content, all we have do is read from Excel worksheet. There's different ways that we can read from the Excel worksheet. We can read all of the values. We can read a range of values. In this example, we are going to read everything because our Excel sheet is very simple. Our Excel sheet is just one column. So when we say to read, everything is just going to read everything that is in one column. We're going to input all values from worksheet. After that, we are going to save our Excel and we are going to close the Excel sheet. Why are we closing the excel sheet? Because we don't need the Excel sheet animal. All of the information is going to be stored in the Excel data variable. Let's launch our process and see if this part of the robot works. Alright, this is the information that we have extracted 74 different groups that we're going to pause our post too. Alright, what is the next thing that we have to do? Now we have to automate Facebook. We are going to be using browser automation and we're gonna be using Microsoft Chrome. So we're going to launch Microsoft Chrome, a new instance. We're going to just add for the time being, a link from one of the groups that we are a member of. For the time being, this is going to be static just while we're recording the steps that we need for our process. Let's launch our process, and let's start recording the different actions that we need. As always, we're going to start with the easiest method. We're going to use the recorder and start recording the different actions. So what we have to do is we have to click in this and write a post. So let's spy the different elements and let's add them to our recording. So let's hit under code and spy the innermost element of this button. After that, we're going to click inside the write something. So let's make sure we click on the inner most one. And let's delete the other one. Right now for testing, we're going to click on the Close button. Alright, perfect. That's just three actions. Let's finish this process and let's test it out and see if it works. Now, this is what has been generated for us. Let's move it to the bottom of our process. Well, we could also leave it in the tops. This is what has been generated for us. Let's try this process and see if it works. It has opened successfully, it has clicked and has closed the button. Perfect. What we're missing right now is we need to add some text. So to add some text, Let's just type and search for text, or let's send keys. And this is where we are going to be putting the content of our posts. Now let's prepare a post and inserted in here. Alright, once we have our post id, we are ready to test our process. Now there's just one little modification that we're going to do. We're going to add some weights. Now why we are adding weights? Probably we've seen that everything works so far. However, we want to facebook think that we are not robots, we are human. So we're going to add to three seconds of width between every action. So once we click on the button, once we click inside, paste our text. And also, alright, now that the weights have been inserted, we can test our process again and see if the key is that we have added is working with this process. Now this is a great way of working and debugging. There's many different ways that a process can be created. So it's always good to try the easiest way first and then work our way towards a more difficult approach. Alright, so far, the process has worked successfully. We have managed to insert our texts. Now the next step would be to spy this button right here, post and post on this button, and then go to the next page. We're almost done. This is amazing. We're going really fast. We're gonna be using the recorder once again, and we're gonna be spying this post button right here. So let's click on the Record button, and let's spy on this post button over here. Once that is done, we don't need any other action. That is everything that we need. This is the content that has been created. Let's remove the extra things and let's rename our buttons before we forget salt, we have meaningful names for them. So this is post. If we press F2, we can named on the fly. So this is post button. This is going to make it much easier for us once our process start growing to know exactly where we are clicking. And if we made a little bit of a mess with all extra actions, all we can do is remove unused UI elements. This is going to remove all of the elements that we are not using in our process. Perfect, Let's clean up our process a little bit. And let's add the final button. We can remove this. And now that everything has been created, we should add a loop. Loop is going to allow us to go through all of the different 74 pages that we have inside of our Excel sheet and post to each one of them. Now, we need a special loop for this, we can just use a normal loop. We have to use a for each loop. So let's add a for each loop in the bottom of our process, and let's select a value. The value is going to be the Excel data. So the Excel data that we extract is going to be the value for our, for each loop. This means that it's going to circle all the data inside of our Excel sheet. Let's take all of the different steps and move them inside the for loop. I have moved the wait three seconds here and canceled, erased the last weight. Now this is pretty much everything we should do. The last thing we have to do is change this to a dynamic variable. Now, we have added a for each loop, we also have access to the current item. We're going to select the current item and we're going to try our processes. The current item is going to be the current row where the loop that we have inserted is solid current item first is going to be this, then this, then this, then this, and so on. So the idea is to post on each one of these pages. Let's try our process and see what happens. Alright, so far, so good. We are on the first link. So we are on the first page. We managed to successfully click on the Create Post. We've managed to click also on the, on the link to paste data. We managed to paste it. We are clicking on the post. Perfect. We managed to post on the first page. Now we're on the second page. And let's see if it's working on this one. It clicked on the first page. Now, one observation with this process is that it should be slowed down a little bit. It's going a little bit too fast. It's going too fast for Facebook is going to detect it. We are Robert. So, so far we've seen that our automation is working really well. Now, what we have to change is we have to just slow it down. Awesome, perfect. In just a couple of minutes, we have created an automation can help us really save loads and loads of time of doing something manual and repetitive. If you have enjoyed this video, you'll know what to do. You know where to find the RPA champion. I have many more videos like this, but most of all, I want to hear. What kind of videos do you want to see? Right down in the comments below. Thank you so much for watching, and I will see you in the next video. 7. Project 3: Linkedin Bot (send automatic messages): In this video, you are going to learn how to send Canvas messages or lignin, but not by doing it yourself, but by using a robot. We're going to create a Microsoft Power Automate Desktop problem that is going to create countless messages on linkedin and help us save countless hours of time. Now, if this sounds interesting, it is interesting. And also it is not illegal. It is not illegal because this is legal. However, it can get your account ban on Lincoln. And if you don't take certain steps that I will show you in this video. Without further ado, let's jump right into this and see how we can create a Lincoln and automated robot that is going to do some lead generation for us. As always, we're going to start from a blank canvas. We're going to create a new flow and we're going to call our flow Lincoln them. But remember to name your bots with something meaningful so you don't lose track of all of the different automations that we're going to create together. And just as a reminder, this is a series that I'm creating to remake all of the bonds that I have lost in the latest update. So what are we going to be automating? We're going to create a robot that is going to do a search on LinkedIn for us is going to search for different title, is going to input the different filters that we want, such as the people for the location, for the category type of contact that we want. And after that, we want our robot click on the Connect button to add a note to type in a message, and then to send this to the person. And we want it to do it for all of these people that we have, and also for all of the other pages of people that we have. Now, as I always say, if we can, let's create a robot that is as simple as possible. That means that we shouldn't automate every single thing in Lincoln and meaning we shouldn't click on LinkedIn, go from the homepage login and navigate through all the different pages. We will perform the filter that we want to do, get the link and start from here. This will save us some steps in automating all of different actions that are required to get to this page that is going to make our robot more efficient and better working. So once we have our link, we can start creating our automation. We're going to open a Internet Explorer or microsoft Edge. And we're going to do our automation on Microsoft Edge by inputting the link. This is going to automatically open the link. However, there is a problem with this link. As you can see, this link has been encoded. So what we have to do to make it work in Microsoft Power Automate decimal, we just have to decode this link. This is extremely simple. You have to do is go to a URL decoder service online, paste that link and get this link that comes out, which is the decoded version of our link. So let's copy this, go back to our automation, pasted, maximize the screen, and test out our automation and see if it's working so far. If it's opening Microsoft Edge and going into the page that is supposed to be going. It's seems to be working. It has open the page and has opened it with all of the different filters that we need. Now let's pass on to the next step. Let's try to click on this button, click on this button and a node, add some text, and then click on the Send button. As always, there is different ways that we can do this. We can do this by dragging and dropping different things. We can automate our keyboard, we can do it in all kinds of different ways, but I like to start with the simplest way first. The simplest way would be to use the record. So let's click on the record and see what we can get done with this quarter. The recorder is polar is going to help you create a basic skeleton for your process and also give you some pretty good selectors. And I'll show you in a second what I mean. So let's click on the record and record the different actions that we need. So we're gonna get the innermost element out of this. So we're going to click on this connect. After that, we're going to click on the Add note. We're going to right-click into the text area and we're going to add text with ME. After adding the text that we want to add, we're going to click on Add text. This is going to add the tax. And finally, we're going to click on the Send button. Let's click on this button right here. So this is going to send our message. And also right here in the recorded actions, we can see that we have recorded all of the different actions that we need for our automation. Now let's do one more thing. So let's click on one more button, and let's exit out of this. And let's click on one more button and exit out of this. We're doing this because we are looking for differences in these buttons so that we can create an automation is going to click on all of the different command buttons, not just the first one. You will know what I'm talking about just a little bit later in this video. All of this is extremely simple. We're not creating any code, writing any code. We'll just using a new tool. If this is all new to you, don't worry, this is just feeling. You're feeling a little bit overwhelmed because the tool is new. However, it is a very simple tool, but yet very powerful. Alright, now let's get rid of everything that we don't need. So this was the code that has been generated for us automatically by the recorder. I got rid of the comments and also of the first. Action that served to launch a new Microsoft Edge. So we're launching Microsoft Edge. And if we go right here in the right UI elements, we can see everything that has been created for us. Now, while our memory is still fresh, we should click and rename all these different elements so that we don't get confused as we're working in. So I'm going to rename this. I have renamed all of the elements that I need. Now this two last spans are the Connect button, just a different Connect button. I don't need this. I will need those for something else. Alright, now, we could try our automation and see if it's working. I am going to add a couple of weights so that it looks a little bit more human. This automation and I also don't really run the risk of blocking the page are going too fast for the page to load, to execute the different actions. So I'm going to add a couple of weights between the different actions. Just saw to make my automation a little bit more human and a little bit less like a Rob. I've added a weight of two seconds between every single action. Let's run our automation and see what happens. So far. It is successfully launching Lincoln then on the right page. Now the next thing that it should do, it you click on the Connect button. It has clicked on the Connect button. Now, it's also add text and perfect, our automation should stop right here. It's working perfectly fine. That's great. And the last partial send the message. Alright, now let's stop this for a second and let's change it a little bit up. So right now we're just clicking on one button. We want to click on all of the different buttons. So how do we do that? Well, it's very simple. We have to add in a loop. This is what we always do when we have repetitive actions to do. We're going to drag and drop this loop right underneath our launch new Microsoft Edge. We're going to start the loop at 0 and add the loop at Penn and incremented by one. This means that our loop is going to start at 01234567, is going to go until ten and then it is going to stop and finish this automation. We're going to move all four steps inside of this loop. Once all the steps are moving inside, we have one more thing. What we're doing right now is we're going to be clicking on just one Connect button. We want to click on the different connect buttons. Let's see how we can do that really quickly. So remember we took this additional elements of the Connect button. Why don't we do that? We did that so that we can analyze them and take a little bit and look at them. I'm going to copy this element and I'm going to go into my original Connect button. I'm going to add a new element and just paste them what I have. Now. Right now, I'm going to look for the differences between these two elements. Here. I've spotted a difference already from two to three. So if we make this number dynamic or if you make it increased by itself, 23456, our automation is going to click on a button, connect to button connect three, button connect four, and so on. Button connect five, and so on. Extremely simple. So now that we know where our magic button or magic selector is, we're going to go inside and we're going to change it. So it is the second tool right here. We're going to change this and we're going to add our loop index. So this is going to be a dynamic number that is generated automatically with our loop that we have created. Amazing, right? We're done. We're pretty much done. So all we have to do right now is test automation and see if it's working. Let's add one final thing, and that will be to close the web browser. So let's close the web browser with this. So once our automation is done, is going to close the web browser. We're going to move it outside of our loop. We're going to remove this. Alright, we are ready to try out our automation. And just remember, it took us not even a full ten minutes to build this automation. This automation can help us save countless hours of time and allow us to do things that otherwise would not be able to do. So, alright, so we can see a first arrow that is happening. It has clicked on the first button, which was a following button. Now this has caused our process to go into cash. So the easiest and quickest way to solve this, we're going to go into each one of these actions and we're going to click on air and we're just going to continue the floor. Why are we doing such a lousy error handling? Well, because we don't expect anything else to happen on this page. So either we're going to have connect pending or following. So whatever. If it's not connecting, It's not connected, then we're going to tell our automation, just go to the next step and so on. So if you don't find a Kinect or if you don't find that, actually just go onto the next button. So for the first one following, while you're just going to skip it and go to the next one. If this one is not connected, you're just going to skip it and go to the next one, and so on. So we're just going to do this really quickly on error and continue flow run for each one of our actions. Also, for the sake of this demonstration, I'm going to change this to four. Why? Because in our process here we are starting, I think from a number four or number five. So we're going to start from here and go all the way until the end of the page. If this process works, fingers crossed that it is going to work. Let's add one final on error here. This should do it in just less than 12 steps. We have created this process. Again, fingers crossed that it is going to work. And just in a little bit, I'm also going to show you a couple of more tips and tricks on how we can make this process even more better. Alright, So far, so good. We are sending an invite toxin. We've managed to send in the text, and we managed to send them the invite. That is awesome. So we sent our first invite. It took us literally no time because a robot is doing it for us. And here is a invite for an Keita. It's a pleasure to meet you. And here we go. We sent another invite. Here's another one. So this automation is working, is gonna do it for ten times. Now, let's pause right here and stop. So there's one thing that is missing in our automation. Do you know what it is? I think you can tell. What is missing is that we're going to come to the end of this page. And then one, how are we going to change from this page on to the next page? We're going to click Next and then repeat the cycle. Well, there's even a faster way to do it. And it all goes with this link that we're gonna, we're gonna look at right here. So this link, once we click on one of these pages, all the way in the end of the link, we get this page three. So if we add this to our link, we can make it go from one page to the other. So let me show you what I mean. So if I change this page number, if I change it to, for example, five, now we're going to go automatically to page number five. Let's try it out and see if it works. Here we are, we're at page five, whole set of new connections that we haven't sent messages to. All right, let's pause this automation and finalize our process. What do I mean by finalized? We need a way of incrementing this page number from 12345. So that once we finish executing all of the ten invites that we have in here, we don't go into close the browser just yet, but we're going to change this page number from five to six to seven or something else. Just very quickly. You will do that with a loop. However, I'm going to let, let you do this so that you figure it out yourself. It is extremely simple. If you need some help, I'm here to help ask some comments down below and it will be given to you. Also remember that I have left the code for this video on the axis lines webpage where you find all of the code for this automation and many other. Thank you so much for watching and I will see you in the next video. 8. Final Project: Lead Generation Bot Part 1: In this video, we are going to learn how to scrape data from LinkedIn in more detail. We are going to go linkedin and we're going to download the full list of our connection. And we're gonna put all of these connection in excel sheet. After that, we are going to visit each one of the profiles in our Excel sheet. And we're going to download all of the connected information that this person has, such as the email or any other relevant information. We're going to add this information to our Excel sheet. That is going to be our process. Our process is going to help us by downloading all of the LinkedIn information from our connections that we want and create an Excel sheet of leads for us. We are going to take this process a step further. And for all of the connections that have an e-mail, we are going to send them an automatic e-mail. This is going to be an amazing process, really fun, and this is going to be a two-part video. In the first part, we're going to just create an Excel list of all of different contexts and as much information as possible. As always, I'm really excited about this. Let's jump into creating this right away. Before opening Microsoft Power Automate, we should navigate to link them. We should search for the people. We should look for first level connections, and then we should look for a geographic region. After that, we're going to type in the keyword that is going to filter our connection as much as possible, such as automation, marketing, CEO, or so forth. After that, we are going to have a link, a link that is going to be pointing to this page. Now to save us some automation steps so that we don't automate all of these filters and navigating to this page, we're just going to start our automation from this link right here. This link is encoded. So first we're going to have to decode this link. We are going to go to a URL, encode and decode, paste our link, decoder link, and copy and paste the decoded link. After that, we are going to go to Power, Automate and start working on our process. I have already created a process called scrape LinkedIn, which is an empty process. And we're going to start from an empty canvas like we always do. We are going to open Google Chrome. So let's open Google Chrome by launching a new Chrome Explorer. And let's paste in the link that we got. Let's launch a new instance and less maximize the screen. So let's save this and this is going to be the first step. The next step is going to be to download all of the information that is available on that page. So now we have download the name, the profile, and maybe also the region where this person is. To do that, we can use the recorder or we can use web data extraction. Let's use web data extraction. Let's drag and drop, extract data from webpage. And this is going to open, this pain, this pain open. We have to go back to Lincoln in and select the different elements that we want to select. Now the first thing that we're going to download is going to be the name. We're going to add the name. The next thing is going to be the link to this profile. This is going to be the most important piece of information here. After that, we are going to download also the role of this person. After that, we will get there also the location of this person. We are also going to get the image of this person by selecting the image. Now that we have all of this information selected from the first profile, it is enough to select the second profile and all of the information is going to be automatically compiled and collected for us. Now as we can see, we are collecting the information from the first page. Let's click Finish. We are going to be storing all of our data in an Excel spreadsheet. For the time being, we're going to save it just in a variable, and afterwards we're going to save it into an Excel sheet. But for testing purposes to keep it simple and quick, we're just going to save it in a variable. Now, it's a good point to test our process and see if it works and pay attention. We just have only two steps so far. One is to launch Chrome and the other one is to extract the information. If this works, this is going to be great because we already have extracted can contracts. So we managed to extract all of the values except the value 34. This is probably due to a selector that is changing. So we will have fine-tune our selectors to extract these values as well. However, we're going to do that later. Right now what we need really only the link to our profile and the name of the person. So that is good enough for us right now. Let's continue with our process. At the time being. We're just extracting the information from the first page. But what we want to do is extract the information from all of these pages that we have down here. Do that. It is very simple. There is different ways that we can do it. The most straightforward way and the way that has been suggested by Microsoft Power Automate is to select a pager, meaning to go on a next button, click on the right-click and select page. Or however, after exten, extensively testing this and trying different methods, this has not proved to be reliable on Linkedin due to this. Selector changing constantly. Therefore, we have to do this in a different way. Now after some assessments, I have found that if we change this page number right here or the page from two to 345, we can then navigate to all of the different pages and extract the information from all the different pages. Usually with automation, we have to think a little bit outside of the box. So let's do right, that. That is going to be really simple. We're just going to use a loop to do that. And we are going to add a loop to our process. We're going to start our process at one, and we're going to end our process at 50. We're also going to increment our process by one and save this. We're going to move our extract data from webpage inside of this page. And we need one last thing. We need to change the page so we're going to navigate to a new page, go to a new page. So we're going to go to a webpage. We are going to paste our link in here. And right here where we have our page. We are going to cancel this number two and we're going to add a loop index. The loop index is going to be a dynamic number that is going to increment from one until 50. So right now we should go from page one until page 50. Every time we extract information from this, let's try our process and see if what we have built so far works. It has opened, managed to open LinkedIn. Now it's on the first page. Theoretically it should go to the following page, and it should be also going into the third page as well. We can see right here that we are on page two right now, and this should change to page three. There it is. It has changed page three. Now, if we go back here, here, we should be having different, different variables. So if we pause this right here, and if we test our, open, our data, we can see that these are the latest people that have been extracted. So this first part of the process is working. Now we need to add all of this information to an Excel sheet. The next thing that we have, though, is we have to create an empty Excel sheet. In this Excel sheet, we're going to be collecting all of our LinkedIn Leads information. Alright, so let's integrate Excel inside of our automation. The first thing that we have to do is we have to look for Excel. After that, we have to launch Excel and open the Excel sheet that we have just created. We can do that by selecting a document that has been already created and go into the path of that document. Once we have selected our Excel sheet, we can save this step and go to the next step. The next step is going to be to append some data onto this excel sheet. But before we do that, we have to know where in our Excel sheet we can put this information that is really simple. What does it mean? Are we going to put our information here? Are we going to put it here, here, here, or where? To do that? We use the useful function that is called get first, free column and row. We're going to drag and drop this, and we're going to save this. This is going to tell Excel where is the first free row where it can write inside of our Excel sheet. And the next step is going to be to write inside of our Excel sheet. And we're going to write the value that we have extracted. So we're going to write our data table and we are going to specify the columns that the first three row and three columns that have been, that we have identified with the previous step. So we're going to add a first free column and first three rows. However, we don't need the column, we can just add column a. This is where we're going to stop. Alright, so this should be quite enough. Let's test our process and see what we have. The process has successfully opened the first LinkedIn page, and now it has also opened the Excel sheet. Now I'm going to move the Excel sheet in view and we can see what is happening. So we have the first, the first ten rows that have been created for us. Now we have the following roles, the following 20, and now we have the other rows as well that are being created for us. So far, so good, our process is working. This sheet is a little bit unstructured and not very easy to read. I'm going to let this run for a little bit. And I'm going to come, come back and show you what we have so far. After modifying a little bit my Excel sheet and formatting it a little bit, this is what we managed to extract. So far. We managed to extract 6161 contexts. Before I stopped the process, we managed to extract the name, the LinkedIn link to the profile of the person, the role that this person has, their location, and also a link to the media. Now for some reason, the link to the media wasn't extracted for all of the profiles. I will have to investigate inside of the selector why this is not the case. However, there is different ways that we can fix this issue and we can check it out in later on. So far so good, we have created the first part of our process. Now, let's just clean up our process a little bit and make it a little bit more study. The first thing that we're gonna do that to improve our process is we're going to add a wait before extracting the information from the webpage. We're just going to wait for two seconds. This is good practice. Just wait for all of the different images and files to load before we extract the information that got fixed, probably the issue that we had previously. And also the last thing that we're going to do in this process is we're going to close the Excel sheet and we'll also going to save the file that we have just created. So we're going to save document and we're going to close the Excel sheet. And also we're going to close the browser as well. This is going to leave us with a clean instance and a clean page. So we can go on to the next process which is going to visit each one of those links, extract their e-mail address, and any other information that could be useful. All right, This was amazing. In just 11 steps we have created an amazing process that we can fine-tune and have extract information from LinkedIn. However we see fit in the last part of this video, we are going to see how we can customize this to add an input field so that we can just type in the search field that we want, such as automation, CIO, CTO, and have the link change automatically without us going in here and modifying the link to make different searches. This was super exciting. Thank you so much for watching, and I will see you in the next video. 9. Final Project: Lead Generation Bot Part 2: In this video, we are going to continue on the amazing work that we have done in the previous video. We have created an Excel sheet that contains all of the names and the LinkedIn profile and other information from all of our LinkedIn Leads. Now we created a process that can extract as many Lincoln and leads starting from a link. Now, what we wanna do is get that person's email and send them an email message automatically. In the next step, we have first part of the process that is collecting all of the leads and pulling them in an Excel sheet. And now our next process is going to go start from this Excel sheet. It is going to collect more information such as e-mail and any other information. And after that, we are going to send them an email with what we have collected. Awesome sounds, super exciting. It is super exciting. Let's start immediately. We're going to pick up things from our last process and we're going to introduce a couple of new concepts that we haven't seen previously. We're gonna be creating a subfloor. There's some flow is going to serve different purposes, but mainly is going to help us organize and structure our work in a little bit better and cleaner way. So we're going to call this get extra detail. And some flows should not have spaces between the words. So let's just call it get extra. Now what we have to do, we have to start again from this Excel file that we have collected and created in the previous example. And get all of the column information or get all of the data that is inside of the link. Now, let's see how we can extract a specific column like column B and not everything from this excel sheet that is extremely simple. All we have do is go to Excel and read from Excel worksheet. There's different ways that we can read from an Excel worksheet. So we can read a range of values we can read from a selection, or we can read all values from the worksheets. So we want to read just the values from a selection. So selection or a range of cells is going to start at column B. It is going to start at row 0 and in column B and end at row. Let's see what role we have. That is the last one and ends at row 61. So we could do this dynamically as well. However, we're trying a new method so that we can learn another method in case the first one might not work in certain examples. Alright, so we have our reading of the Excel sheet. Now, let's run this and see if it works. However, if we were to run our process right now, the main process would get executed immediately. So what we have is we have to execute first, get extra detail. Now we can do that in different ways. The easiest way would be to launch a sub-process in the beginning of our floor. So we're going to select the subprocesses that we have created. And after that we're going to add a breakpoint that is just going to stop our process. Alright, now we're going to run our process and see what happens. We're going to run it. And by adding the subfloor, some flow is going to be executed first. And we can see that something has happened. So we have the read from Excel worksheet that has created a variable that is called Excel data. If we go to the right side and we see our flow variables, and then we go inside of the Excel data. We can see that for column one, we have all of the links that are inside of our Excel sheet. So now we have all of the links that we require. Now we can create a loop, go to each one of those links, and extract as much information as possible, obviously trying to get the e-mail. So that's the next step. So let's start with that. Let's stop our process and add a for each loop. This time we're also doing things in a different order. Just to show you that creating automations can really be up to you however you want to create the automation. However, there are some guidelines, such as trying to create the shortest possible Automation, shown to always make it as simple as possible. So we're going to iterate through the Excel data variable that we created in the previous instance. This is going to go through all of the different loops that we have. After that, we have to do certain actions. We have to go on to the different links. Let's take one of these links. For example, we have to go to the different links and click on contact info and extract the email and any other information from this person. Now, there is different ways that I could also get this. So as we noticed, that when I click on contact info, there is a additional, additional parameter gets added to our link. So if I were to test and try our links that we have extracted previously, if I were to add this in the end of our link, maybe like that, we can save a couple of steps of automation. Always remember that if you can save a couple of steps of automation, it is better than just going about doing all of the automation yourself. That didn't work. I have pasted and tried to put the link with overlay contact info. However, it did not open on what I was expecting. It opened the normal profile. That means that we are going to have to. Integrate this contact info and click on this button and extract the information. Alright, let's do this really quickly. In Microsoft Power Automate, we're going to start with the recorder. Once we have the recorder open and ready, we're going to click on the contact info button. And if the markings don't appear, the red markings that highlight the different elements, just refresh the page or wait a little bit. So right now we are selecting the anchor. We can see that anchor is a link. That means that it's going to open something. So we are going to click on this. After that, we are going to click on the anchor for the email and we're going to extract the value. So we're going to extract this value, and at the same time, we're not going to extract anything else. That is pretty much everything that we need. And now we could pass on to the next link and extract the same information from the next link. Let's try this out and see if it's working so far. So we are going to remove all of the steps that were created, such as launching Chrome that we don't need. And we are going to move these steps inside of our automation. So we're going to navigate to a page instead of launching a new page because it's going to be quicker and faster. So we're going to search for gold tool. And we're going to add a go-to webpage inside the URL for our webpage, we're going to add something dynamic. So here we are going to add the current item. The current item is going to be the link that we want to visit once we open a new Chrome that is going into this fixed adjust, that's great. But the next step of that is going to take the Chrome to the address that we have inside of Excel sheet. Click on the contact info and extract the information. We need to do some stuff with this information. However, before we go any further, let's add a breakpoint here and let's test our process and see if it works so far. Alright, now we are ready to test our process and see if we have spied so far works. So launching, launching Excel has worked. We can see that we have 61 rose. Now we're going to try to launch Google Chrome. Launching Google Chrome is going to work as well. It has worked successfully and now we are going to a new link. Ideally, we should click on the contact info and we should also extract the information from this email. Now, let's go back to our Excel sheet or our automation actually see all of the variables that we have extracted. Now, let's stop our process and take a look at the flow variables that were created. So we have 61 roles that were created. This is the first link that we went through. And this is the inner text email that we managed to extract from our process. That is great. Now there's different things that I can do. I can take this information, I can pull it in an Excel sheet or I can send an email directly to that e-mail address. Now, let's see how we are going to put this information inside of them, excel sheet, and then how to send an e-mail or just keep in mind, as I always say Very often, there is different ways that we can do the same process, countless different ways that we can do the same process. So it's really up to you to choose the correct way. With experience, you're going to learn what is the correct way that is always different correct ways. Only certain wastes will result in more effort than other ways. That's why always keep an open mind and try to do different things. 10. BONUS: Exploit websites with automation: With great power comes great responsibility. Exactly. By learning automation, you're going to have the amazing skill to be able to automate pretty much anything online. In this video, we are going to be using our skills for evil, for exploiting a website for our own games. Well, good ban either, no, But this website allows for this to happen. So I'm going to show you how automation can be used for evil, our robot and our automation is going to visit this website. It is going to go to this project and then it's going to click like on this project. Now, I cannot click like on this project anymore because it has been stored that I have clicked like in the cookies of the internet Explorer. So our automation is going to clear the cookies, go to this page and click Like and it's going to repeat this until we want, until we want as many likes as we want. Alright, without further ado, let's see how we can build this amazing automation. As always, we're going to start from an empty canvas. We're going to create a new bot, and we're going to name our bot early coins. Heck, Let's create our robot and get right into it. As with most web automation, the first thing that we're going to do is launch a new Internet Explorer or Edge, whichever browser you're using. I'm doing some experimenting with edge, so I'm going to be using edge. The next thing that we have to do is add the link to the page or the project. We want to add as many likes to. So I'm going to be using the Genesis robots project. And I'm going to take this link right here. So I'm going to add this link and I'm going to maximize the screen when this opens, the next thing will be to click on this button right here. This time, I'm going to use a little bit of a different approach to automating this. I'm not going to be using the recorder. I'm going to be using and dragging and dropping an action from here. So let's drag and drop an action and see how we can automate the push of this button and the clearing of cookies. The next step is going to be clicking on the button after doing some trial and error. And I spend half an hour trying different options, we're not going to be using the press a button on a web page. We're gonna be using click UI element in a window. So you can thank me for that. And remember, when you're doing automation in form method doesn't work. Just try. Another matter. We are going to be using click UI element in a window, and let's add a UI element. So the element that we're gonna be adding is this button right here. So Control and click on this button and we're going to create this element right here. Now, let's click inside of this selector and see what is this made out of? It looks pretty complex, but everything is pretty standard until right here, the name of the project, as you can see in the name of the project, we have a number that is 10,926. Now this number is obviously going to be changing as we're going to be clicking. So if we keep this as the selector, this is not going to work. So we're going to update this and we're going to click on the last, last selector. This is going to be this one right here, and we're going to look for the name, so name right here, genesis robots and the number right here. So what we're going to do is not equals to, we are going to make it contains. So we're gonna make it contain just the name Genesis promise. We're going to click on update and that's it. Now we have created a robot that is going to go to that webpage. And just one little updated I have made in the launch new Microsoft Edge under the Advanced option, we have clear cache and clear cookies. So this is going to clear the cache and clear the cookies. So we can click on the button. Again. Amazing, so many things in just one action and we have two actions right now. So we have two actions right now that are going to, we're going to test it out right now. And if they work, we're going to make them repeat forever. So it has open the webpage and now it should, if everything works, it should try to click on the button, and it has clicked on the webpage as expected. Alright, so our process has completed this one. Click. Now, let's make this go forever. As you remember, we always like to use loops when we are trying to make things go forever. So the loops are going to be taking out the repetitive and manual tasks out of everything because that is going to give us the ability to iterate over items. So we're going to start at loop 0. We're going to end our loop at, let's say, one gazillion and we're going to increment by one. So our loop is going to be made out of these steps. Can you guess what is missing? If you can guess what is missing, we have to close Internet Explorer. So let's close Edge or Internet Explorer. I'm used calling it Internet Explorer. So let's close this window and this should do it. Now, let's play around and let's see if our automation is going to work and give us an infinite number of likes on a webpage. Now, this is just a little example on how automation can be used for evil or to exploit pages from different for different results. As you can see, the automation is working perfectly fine. We are already at 10,930 and this is going to be number one or number 32 epsilon. Our automation is working. I want to thank you so much for watching this video. If you liked this kind of videos on automation and how to learn automation in an interactive way by automating different things on webpages, different practical things that could be fun to automate and also the same time make you learn different things. In that case, checkout my latest videos, what our ultimate other really great, famous applications like Twitter and LinkedIn. Thank you so much for watching, and I will see you in the next video. 11. BONUS: You are a citizen developer: What is a citizen developer and how you can become one? That is the question and that is the answer that you will be getting in this video. As citizen developer is a person without formal training in software development who uses and develops a software using low code or no code platforms. We will learn more about these platforms later on in the video and how you can use them to become a citizen developer and gain a competitive advantage. Now, this is very important. According to Gartner, by 2023, there will be four times more citizen developers than traditional programmers in large enterprises. And that is huge and it is a main game changer. Now, why is citizen development on the rise? Now, there are two perspectives. There is a business perspective and an IT perspective. If we take a look at it from an IT perspective, we will understand that more and more organizations are opting to digitalize their operations. More and more organizations may be because of COVID or because they want a competitive advantage. More and more organizations they are trying to go digital and automate their processes. This response, the IT department needs to coordinate large efforts and large tasks to respond to the ideas and requests from the company to build all these new solutions. As a result, many IT departments are falling behind and have a huge backlog of IT solution requests. If we take a look at this from a business perspective, we know that low-code and no-code platforms enable people with a basic understanding of business needs and problem solving skills to create apps that can help the whole department and the entire enterprise. And that is the magic of citizen development. What are you using? Low code, no code, platforms and post. Now, some of the benefits of citizen development movement are the following, five, meeting the demand for us, as we discussed previously, creating apps without vocal, that is one of the powers of the citizen developer. Creating apps by dragging and dropping features into an application, having it automatically connect with different data sources. It is the power of local no-code platforms that allow citizen developers to create apps without going to the IT departments. In addition to this, since these apps are built by the end user or the person in the company, they are exactly the requirements or exactly the app that needs to be built. It is, there is no process of requirements gathering, understanding the requirements, getting those requirements to a developer, and then showing it to the client or the business user and asking them if it's okay, that whole process disappears. Now, it is the personal actually needs to solve that problem. That is, building the app for themself and that is great. This also engages the entire workforce. The entire workforce now can collaborate and can create this kind of applications. This is not something that is left to a specific group of people, just the IT department in addition, list. It also increases productivity. It increases productivity for the entire team because now team members are able to automate and digitalize different things, different steps that they were performing previously. And now they can do it better with technology by building custom apps, flows, chatbots, and so on. These companies and these people will gain a competitive advantage compared to other people that are working in a traditional manner. Now, how about the citizen development governance? It is crucial to have proper governance if citizen developers are going to rise in your organization. First of all, there has to be a vision, a vision for the team and for the citizen developers. What are they going to build, what tools to use, and so on. As to support this vision, there has to be a central hub for the citizen development governance. Meaning there has to be the team that is managing all the applications, managing the support, managing trading, and supporting the development of these applications by the series of developments. Also, proper tools have to be identified to be used. And these tools have, the citizen developers have to be trained properly on these tools. And also there has to be a very strong focus on the security as well. Right now, citizen developers are getting the ability to create apps, automations, and so on. However, sometimes they might not have the correct knowledge of securing certain obligations or certain data and information in the correct way. Therefore, it is crucial that there is a central body that governs all of the automations are created and that is there for support. Now, before we dive into the specific tools that are used by the citizen developers, it is important to understand a couple of features Of main features that characterize any citizen development platform. So for example, the platform that says the developer will use has to be cloud-based platform. It has to be a cross platform functionality, meaning that this tool works across different platforms, your cell phone, your computer, your iPad, and so on. It has to be also very easy to learn and often with training available online, easily available as well. Data centricity is a crucial part of the citizen development platforms because they have to be data centric. And the final point is security as well. Data has to be secured and enlarge organizations. This is a key, a key concept. A few words about the citizen development framework. Citizen developers should not work independently of the IT team. A team comprising full-time developers should manage the citizen developers. The full-time developers will review the requirements, design, and enforce standard of development. They will also support the citizen developers when needed. So now, what is a citizen developer? Citizen developers use low-code and no-code platforms to build business applications that optimize business processes and change how the business functions for the better. One of the main advantages of using low code, no code platforms, it is that it makes it much easier to automate and optimize business processes. There are accessibility means that people without any programming background can learn how to build and deploy applications rapidly. And that is a key concept of citizen developer being able to deploy applications rapidly. No one can disagree that decreasing the burden of the IT department has a positive impact on the organization. Nor can they argue against the ability to produce compliant sources solutions that streamline business processes rapidly.