title
UiPath Excel Automation | UiPath Excel Activities | UiPath Training Essentials | Edureka

description
** RPA Training - https://www.edureka.co/robotic-process-automation-training ** This video on "UiPath Excel Automation" will help you how to automate excel using UiPath. Below are the topics covered in this UiPath Excel Automation: 1. Why Excel Automation 2. Installing Excel Activities 3. Hand-On (Filling Google Forms using Excel) Subscribe to our channel to get video updates. Hit the subscribe button above. How it Works? 1. This is a 4 Week Instructor led Online Course, 25 hours of assignment and 20 hours of project work 2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 3. At the end of the training you will have to work on a project, based on which we will provide you a Grade and a Verifiable Certificate! - - - - - - - - - - - - - - About the Course Edureka’s RPA training makes you an expert in Robotic Process Automation. Robotic Process Automation is Automation of repetitive and rule-based tasks. In Edureka's RPA online training, you will learn about the RPA concepts and will gain in-depth knowledge on UiPath tool using which you can automate the data extraction from the internet, login process, image recognition process and many more. After completing the RPA Training, you will be able to: 1. Know about Robotic Process Automations and how it works 2. Know about the patterns and key considerations while designing a RPA solution 3. Know about the leading RPA tool i.e. UiPath 4. Gain practical knowledge on designing RPA solutions using both the tools 5. Perform Image and Text automation 6. Create RPA bots and perform data manipulation 7. Debug and handle the exceptions through the tool - - - - - - - - - - - - - - Why learn Robotic Process Automation? Robotic Process Automation (RPA) is an automation technology for making smart software by applying intelligence to do high volume and repeatable tasks that are time-consuming. RPA is automating the tasks of wide variety of industries, hence reducing the time and increasing the output. Some of facts about RPA includes: 1. A 2016 report by McKinsey and Co. predicts that the robotic process automation market could be worth $6.7 trillion by 2025 2. A major global wine business, after implementing RPA, increased the order accuracy from 98% to 99.7% while costs reduced to Rs. 5.2 Crore 3. A global dairy company used RPA to automate the processing and validation of delivery claims, reduced goodwill write-offs by Rs. 464 Million For more information, please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll-free). Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka

detail
{'title': 'UiPath Excel Automation | UiPath Excel Activities | UiPath Training Essentials | Edureka', 'heatmap': [{'end': 639.978, 'start': 594.035, 'weight': 0.722}, {'end': 741.744, 'start': 689.575, 'weight': 0.807}, {'end': 847.34, 'start': 810.58, 'weight': 0.762}], 'summary': 'Learn about uipath excel automation and automating google form with uipath, including form creation, data fetching, and process efficiency, as well as automating excel data processing for enhanced business processes and time-saving benefits.', 'chapters': [{'end': 198.07, 'segs': [{'end': 99.824, 'src': 'embed', 'start': 71.18, 'weight': 0, 'content': [{'end': 74.623, 'text': 'Excel is easy to use and is also highly popular,', 'start': 71.18, 'duration': 3.443}, {'end': 82.149, 'text': 'but it is not always user-friendly and at times it can prove to be very time-consuming and hard to integrate with other applications.', 'start': 74.623, 'duration': 7.526}, {'end': 90.536, 'text': "So, in today's environment, where everything is multi application focus, with data constantly being transferred between applications,", 'start': 82.669, 'duration': 7.867}, {'end': 95.16, 'text': 'migrating and integrating data into platforms can therefore become troublesome right?', 'start': 90.536, 'duration': 4.624}, {'end': 99.824, 'text': 'So to perform large number of tasks with good accuracy and speed,', 'start': 95.42, 'duration': 4.404}], 'summary': 'Excel is popular but not always user-friendly. migrating and integrating data can be time-consuming and troublesome in a multi-application environment.', 'duration': 28.644, 'max_score': 71.18, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf871180.jpg'}, {'end': 142.107, 'src': 'embed', 'start': 110.913, 'weight': 1, 'content': [{'end': 115.236, 'text': 'Now, how do we implement this Excel automation? Well, that is really simple.', 'start': 110.913, 'duration': 4.323}, {'end': 122.761, 'text': "You just have to implement it by using a tool, right? So here we'll be using the uipath tool to automate Excel activities.", 'start': 115.516, 'duration': 7.245}, {'end': 130.545, 'text': "So I'm assuming that all of you are well versed with the uipath interface and workflow passing variables between actions right?", 'start': 123.561, 'duration': 6.984}, {'end': 133.668, 'text': 'So these concepts will help you out throughout this tutorial.', 'start': 130.765, 'duration': 2.903}, {'end': 135.524, 'text': "So now let's get started.", 'start': 134.344, 'duration': 1.18}, {'end': 142.107, 'text': "So, as I told you before, that we'll be using the uipath tool to automate activities related to Excel,", 'start': 136.065, 'duration': 6.042}], 'summary': 'Using uipath for automating excel activities', 'duration': 31.194, 'max_score': 110.913, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8110913.jpg'}, {'end': 191.087, 'src': 'embed', 'start': 163.118, 'weight': 2, 'content': [{'end': 167.339, 'text': 'So when you open your uipath studio, you can go to this manage packages option.', 'start': 163.118, 'duration': 4.221}, {'end': 167.859, 'text': 'All right.', 'start': 167.539, 'duration': 0.32}, {'end': 175.041, 'text': 'So, when you click on this, this is where you can check if your Excel activities or any other such activities, for like the word activities,', 'start': 167.919, 'duration': 7.122}, {'end': 177.162, 'text': 'the mail activities are installed or not.', 'start': 175.041, 'duration': 2.121}, {'end': 181.383, 'text': 'So in my system, you can already see that the Excel activities are installed.', 'start': 177.542, 'duration': 3.841}, {'end': 182.043, 'text': 'All right.', 'start': 181.703, 'duration': 0.34}, {'end': 186.265, 'text': 'Just in case if Excel activities are not installed on your system,', 'start': 182.563, 'duration': 3.702}, {'end': 191.087, 'text': 'you just have to search in the search bar for Excel activities and click on the install radio button.', 'start': 186.265, 'duration': 4.822}], 'summary': 'In uipath studio, manage packages to check/install excel activities.', 'duration': 27.969, 'max_score': 163.118, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8163118.jpg'}], 'start': 7.202, 'title': 'Uipath excel automation', 'summary': 'Covers the reasons for excel automation, time-consuming and hard integration with other applications, implementing excel automation using uipath, and steps for installing excel activities in uipath studio.', 'chapters': [{'end': 198.07, 'start': 7.202, 'title': 'Uipath excel automation', 'summary': 'Covers the reasons for excel automation, such as time-consuming and hard integration with other applications, the process of implementing excel automation using uipath, and the steps for installing excel activities in uipath studio.', 'duration': 190.868, 'highlights': ['Excel is not always user-friendly and can be time-consuming and hard to integrate with other applications, leading to the need for automation. Excel is popular but not always user-friendly, time-consuming, and hard to integrate with other applications, driving the need for automation.', 'The chapter explains the process of implementing Excel automation using UiPath. The process of implementing Excel automation using UiPath is described, assuming familiarity with the UiPath interface and workflow.', "Demonstration of how to install Excel activities in UiPath Studio is provided, which involves accessing the 'Manage Packages' option and installing necessary packages. The steps for installing Excel activities in UiPath Studio are demonstrated, including accessing 'Manage Packages' and installing necessary packages."]}], 'duration': 190.868, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf87202.jpg', 'highlights': ['Excel is not always user-friendly and can be time-consuming and hard to integrate with other applications, leading to the need for automation.', 'The chapter explains the process of implementing Excel automation using UiPath.', "Demonstration of how to install Excel activities in UiPath Studio is provided, which involves accessing the 'Manage Packages' option and installing necessary packages."]}, {'end': 537.325, 'segs': [{'end': 227.004, 'src': 'embed', 'start': 198.71, 'weight': 0, 'content': [{'end': 205.373, 'text': 'Okay, so now that you know how to install the Excel activities and you know the reason why you should automate the Excel activities.', 'start': 198.71, 'duration': 6.663}, {'end': 210.876, 'text': "Let's move on to a hands-on where we'll be creating an automation to fill a form with Ui path.", 'start': 205.674, 'duration': 5.202}, {'end': 211.536, 'text': 'All right.', 'start': 211.196, 'duration': 0.34}, {'end': 220.401, 'text': "So what this automation is going to do is that we're going to have a set of details stored already in a CSV file and then we'll create a Google form.", 'start': 212.017, 'duration': 8.384}, {'end': 227.004, 'text': 'So when you run this automated task all the details are fetched from the CSV file and Google form fills automatically.', 'start': 220.701, 'duration': 6.303}], 'summary': 'Learn to automate excel tasks and fill google form using uipath.', 'duration': 28.294, 'max_score': 198.71, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8198710.jpg'}, {'end': 271.003, 'src': 'embed', 'start': 243.371, 'weight': 2, 'content': [{'end': 246.453, 'text': "So now let's just drag and drop a sequence in the workspace.", 'start': 243.371, 'duration': 3.082}, {'end': 246.933, 'text': 'All right.', 'start': 246.593, 'duration': 0.34}, {'end': 251.419, 'text': 'So basically sequence is a place where all your activities are performed.', 'start': 247.518, 'duration': 3.901}, {'end': 255.86, 'text': "So since we're dealing with the Google form here, let's first create a Google form.", 'start': 251.739, 'duration': 4.121}, {'end': 256.32, 'text': 'All right.', 'start': 256.019, 'duration': 0.301}, {'end': 258.6, 'text': "So for that, let's go back to a browser.", 'start': 256.459, 'duration': 2.141}, {'end': 261.101, 'text': "So now let's just create a Google form here.", 'start': 259.041, 'duration': 2.06}, {'end': 264.502, 'text': "So for that, let's just type in Google for Google forms.", 'start': 261.44, 'duration': 3.062}, {'end': 270.283, 'text': "Go to Google forms and then let's create a blank Google form.", 'start': 266.322, 'duration': 3.961}, {'end': 271.003, 'text': 'All right.', 'start': 270.663, 'duration': 0.34}], 'summary': 'Creating a google form by dragging a sequence and using a browser.', 'duration': 27.632, 'max_score': 243.371, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8243371.jpg'}, {'end': 332.658, 'src': 'embed', 'start': 299.146, 'weight': 1, 'content': [{'end': 302.789, 'text': "Let's add one more question which could be university name.", 'start': 299.146, 'duration': 3.643}, {'end': 308.384, 'text': 'and finally the email ID.', 'start': 306.883, 'duration': 1.501}, {'end': 315.448, 'text': 'So guys, this is a simple form where you can customize your form as you want.', 'start': 311.366, 'duration': 4.082}, {'end': 321.852, 'text': 'Now, let me just send this Google form to anybody right? So let me just send this Google form to myself.', 'start': 316.008, 'duration': 5.844}, {'end': 324.353, 'text': "So let's just type in my mail ID.", 'start': 322.312, 'duration': 2.041}, {'end': 332.658, 'text': 'All right and click on send once I click on send let me just open my mail ID.', 'start': 328.015, 'duration': 4.643}], 'summary': 'A demonstration of customizing and sending a google form, including adding university name and email, for personalization.', 'duration': 33.512, 'max_score': 299.146, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8299146.jpg'}, {'end': 395.482, 'src': 'embed', 'start': 354.406, 'weight': 6, 'content': [{'end': 361.529, 'text': "Once this is done in the URL over here, you have to specify the Google Forms link, right? So let's go back to a form copy it.", 'start': 354.406, 'duration': 7.123}, {'end': 367.438, 'text': "Let's come back to the uipath tool open double quotations and then paste it over here.", 'start': 362.253, 'duration': 5.185}, {'end': 368.258, 'text': 'All right.', 'start': 367.918, 'duration': 0.34}, {'end': 372.542, 'text': "Now, after you're done with this, in the do section of your open browser,", 'start': 368.739, 'duration': 3.803}, {'end': 377.146, 'text': 'you have to include a type into to identify the questions of the application form.', 'start': 372.542, 'duration': 4.604}, {'end': 377.907, 'text': 'All right.', 'start': 377.586, 'duration': 0.321}, {'end': 384.192, 'text': "So for that, let's just search in the activity pane for type into and then drag and drop it here.", 'start': 378.207, 'duration': 5.985}, {'end': 384.993, 'text': 'All right.', 'start': 384.672, 'duration': 0.321}, {'end': 389.757, 'text': "So if the first question is about full name, so let's just type in the text as full name.", 'start': 385.373, 'duration': 4.384}, {'end': 392.78, 'text': 'and to indicate the element in the browser.', 'start': 390.939, 'duration': 1.841}, {'end': 395.482, 'text': 'You have to first open that application form right?', 'start': 392.82, 'duration': 2.662}], 'summary': "Using uipath, automate form filling by specifying google forms link, opening browser, and identifying questions with 'type into' activity.", 'duration': 41.076, 'max_score': 354.406, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8354406.jpg'}, {'end': 442.905, 'src': 'embed', 'start': 416.807, 'weight': 4, 'content': [{'end': 422.871, 'text': "Similarly, we have to do the same for the next three inputs also, right? So let's just drag three type in twos here.", 'start': 416.807, 'duration': 6.064}, {'end': 430.977, 'text': 'And then include the text mobile number University name.', 'start': 425.593, 'duration': 5.384}, {'end': 435.08, 'text': 'And then email ID.', 'start': 433.018, 'duration': 2.062}, {'end': 439.483, 'text': 'So let me indicate the element inside the browser for mobile number.', 'start': 436.261, 'duration': 3.222}, {'end': 442.905, 'text': "So let's just open that and let me choose over here.", 'start': 439.563, 'duration': 3.342}], 'summary': 'Instruction to input mobile number, university name, and email id for three inputs.', 'duration': 26.098, 'max_score': 416.807, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8416807.jpg'}, {'end': 542.76, 'src': 'embed', 'start': 518.697, 'weight': 5, 'content': [{'end': 525.84, 'text': "So let's search in a delay activity and then let me just drag and drop it here in the properties panel of the delay activity.", 'start': 518.697, 'duration': 7.143}, {'end': 533.603, 'text': "Let's add for how many seconds do we want the delay? So let's say if I want the delay for three seconds, I'll add in this format.", 'start': 525.86, 'duration': 7.743}, {'end': 537.325, 'text': 'All right, so this would basically add a delay of three seconds.', 'start': 534.364, 'duration': 2.961}, {'end': 542.76, 'text': 'So if you observe here this complete sequence is only working for a single input.', 'start': 538.234, 'duration': 4.526}], 'summary': 'Demonstrating setting a 3-second delay in a sequence for a single input.', 'duration': 24.063, 'max_score': 518.697, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8518697.jpg'}], 'start': 198.71, 'title': 'Automating google form with uipath', 'summary': 'Covers automating the process of filling a google form using uipath, fetching details from a csv file, demonstrating form creation, using sequence workspace, identifying form elements, and adding a delay of three seconds.', 'chapters': [{'end': 332.658, 'start': 198.71, 'title': 'Automating google form with uipath', 'summary': 'Covers the automation of filling a google form using uipath, fetching details from a csv file and filling the form automatically, demonstrating the creation of a google form, and using the sequence workspace in uipath to perform activities.', 'duration': 133.948, 'highlights': ['The automation fetches details from a CSV file and automatically fills a Google form, streamlining the process and saving time. The automation demonstrated streamlines the process by fetching details from a CSV file and automatically filling a Google form, saving time and effort.', 'The creation of a Google form is explained, including customizing the form with various questions and sending the form via email. The process of creating a Google form, customizing it with different questions, and sending it via email is detailed, showcasing the versatility of the form creation process.', 'The use of the sequence workspace in UiPath to perform activities is demonstrated, providing a practical approach to utilizing the workspace for automation. The demonstration of using the sequence workspace in UiPath for performing activities provides a practical approach to utilizing the workspace for automation, enhancing understanding and application.']}, {'end': 537.325, 'start': 334.258, 'title': 'Automating form filling with uipath', 'summary': 'Covers automating the process of filling out a google forms application using uipath, including opening the browser, identifying form elements, inputting data, automating the submit button, and adding a delay of three seconds.', 'duration': 203.067, 'highlights': ['The chapter covers automating the process of filling out a Google Forms application using UiPath, including opening the browser, identifying form elements, inputting data, automating the submit button, and adding a delay of three seconds.', 'The URL for the Google Forms link needs to be specified in the open browser activity in UiPath.', "In the 'do' section of the open browser activity, a type into activity is used to identify the questions of the application form.", 'The process involves identifying form elements in the browser, such as full name, mobile number, university name, and email ID, and automatically inputting data into these fields.', 'After filling in all the details, a click activity is used to automate the submission of the form, followed by adding a delay of three seconds using a delay activity.']}], 'duration': 338.615, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8198710.jpg', 'highlights': ['The automation fetches details from a CSV file and automatically fills a Google form, streamlining the process and saving time.', 'The creation of a Google form is explained, including customizing the form with various questions and sending the form via email.', 'The use of the sequence workspace in UiPath to perform activities is demonstrated, providing a practical approach to utilizing the workspace for automation.', 'The chapter covers automating the process of filling out a Google Forms application using UiPath, including opening the browser, identifying form elements, inputting data, automating the submit button, and adding a delay of three seconds.', 'The process involves identifying form elements in the browser, such as full name, mobile number, university name, and email ID, and automatically inputting data into these fields.', 'After filling in all the details, a click activity is used to automate the submission of the form, followed by adding a delay of three seconds using a delay activity.', 'The URL for the Google Forms link needs to be specified in the open browser activity in UiPath.', "In the 'do' section of the open browser activity, a type into activity is used to identify the questions of the application form."]}, {'end': 774.999, 'segs': [{'end': 639.978, 'src': 'heatmap', 'start': 558.057, 'weight': 1, 'content': [{'end': 563.339, 'text': "What's going to happen is the Google form will start filling by itself by the input we have given, right?", 'start': 558.057, 'duration': 5.282}, {'end': 566.741, 'text': "So we have given this input and it's filling by itself after that.", 'start': 563.359, 'duration': 3.382}, {'end': 569.902, 'text': "It's clicking on the Submit button and it's going back now.", 'start': 566.861, 'duration': 3.041}, {'end': 571.403, 'text': 'This was for one input.', 'start': 570.202, 'duration': 1.201}, {'end': 576.845, 'text': 'What if we want to do it for many more records and we wanted to fetch the data from a CSV file.', 'start': 571.923, 'duration': 4.922}, {'end': 579.967, 'text': "So for that, let's just change the text here first.", 'start': 577.226, 'duration': 2.741}, {'end': 593.695, 'text': 'Now to read the data from a CSV file and to repeat this actions again and again, we have to create a flow chart.', 'start': 587.592, 'duration': 6.103}, {'end': 596.817, 'text': "So for that, let's first create a sequence again.", 'start': 594.035, 'duration': 2.782}, {'end': 605.981, 'text': "So let's just close this and then go to a new sequence and let's just say we name it as Excel demo and then let's click on create.", 'start': 596.837, 'duration': 9.144}, {'end': 614.265, 'text': "In this you have to add a flow chart, right? So let's search for a flow chart now and then let's drag and drop it here.", 'start': 607.462, 'duration': 6.803}, {'end': 622.651, 'text': "Once you drag and drop a flow chart, let's add a sequence here, right? So let's just search for a sequence and then let's add it here.", 'start': 615.021, 'duration': 7.63}, {'end': 629.799, 'text': 'Now open the sequence and then copy all the activities in this particular sequence and paste it there.', 'start': 623.351, 'duration': 6.448}, {'end': 634.225, 'text': "So let's just copy all the activities from here and then let's paste it here.", 'start': 630.24, 'duration': 3.985}, {'end': 639.978, 'text': 'So now you have copied all the actions inside this particular sequence to add them into the flow chart.', 'start': 634.972, 'duration': 5.006}], 'summary': 'Automating google form submission and data fetching from csv using flow chart and sequence.', 'duration': 47.924, 'max_score': 558.057, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8558057.jpg'}, {'end': 689.575, 'src': 'embed', 'start': 630.24, 'weight': 0, 'content': [{'end': 634.225, 'text': "So let's just copy all the activities from here and then let's paste it here.", 'start': 630.24, 'duration': 3.985}, {'end': 639.978, 'text': 'So now you have copied all the actions inside this particular sequence to add them into the flow chart.', 'start': 634.972, 'duration': 5.006}, {'end': 644.923, 'text': 'So now what we want to do is we want the Google form to fetch the data from a CSV file.', 'start': 640.338, 'duration': 4.585}, {'end': 650.309, 'text': "So let me just show you a CSV file where I've stored the data, right? So let me just open that CSV file.", 'start': 645.304, 'duration': 5.005}, {'end': 657.676, 'text': "All right, you can see that I've put in the details for full name, mobile number, email ID and university name, right?", 'start': 651.17, 'duration': 6.506}, {'end': 662.941, 'text': "So let's just see now how the Google form fetches the data from this file and fills it over there right?", 'start': 658.017, 'duration': 4.924}, {'end': 670.868, 'text': "So let's go back to the uipath tool and let's search for an activity known as read CSV, which would help us reading all the data in a CSV file.", 'start': 663.241, 'duration': 7.627}, {'end': 676.654, 'text': "All right, so let's just search for read CSV activity and then let's drag and drop it here.", 'start': 671.009, 'duration': 5.645}, {'end': 682.388, 'text': 'So once you drag and drop this activity just click over here to open this activity.', 'start': 677.523, 'duration': 4.865}, {'end': 682.908, 'text': 'All right.', 'start': 682.588, 'duration': 0.32}, {'end': 688.273, 'text': 'So, in the file path option, you have to mention the file from which it is going to fetch the data right?', 'start': 683.289, 'duration': 4.984}, {'end': 689.575, 'text': "So let's just so.", 'start': 688.374, 'duration': 1.201}], 'summary': 'Demonstrating how to fetch data from a csv file using uipath, including details for full name, mobile number, email id, and university name.', 'duration': 59.335, 'max_score': 630.24, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8630240.jpg'}, {'end': 741.744, 'src': 'heatmap', 'start': 689.575, 'weight': 0.807, 'content': [{'end': 696.281, 'text': "let's just click on this tree dots, go to desktop, choose the data CSV file and click on open.", 'start': 689.575, 'duration': 6.706}, {'end': 698.483, 'text': 'this would automatically include a file path.', 'start': 696.281, 'duration': 2.202}, {'end': 699.044, 'text': 'All right.', 'start': 698.704, 'duration': 0.34}, {'end': 704.568, 'text': 'Now our CSV file must have an output format of data table in order to be processed.', 'start': 699.705, 'duration': 4.863}, {'end': 706.91, 'text': "So for that we're going to create a variable.", 'start': 704.848, 'duration': 2.062}, {'end': 711.833, 'text': "So let's just click on create variable go to table and choose the table name.", 'start': 707.19, 'duration': 4.643}, {'end': 714.335, 'text': "Let's say I choose the table name as data table.", 'start': 711.973, 'duration': 2.362}, {'end': 718.718, 'text': 'and then click on OK once this is done in the variable section.', 'start': 715.035, 'duration': 3.683}, {'end': 721.58, 'text': 'You can see that the variable data table is created.', 'start': 718.818, 'duration': 2.762}, {'end': 722.261, 'text': 'All right.', 'start': 721.6, 'duration': 0.661}, {'end': 727.745, 'text': 'So now in the property section, you have to mention the data table variable in the output field.', 'start': 722.781, 'duration': 4.964}, {'end': 734.913, 'text': "All right, so let's just mention the data table variable Now, let's go back to a main sequence and see what's happening.", 'start': 728.226, 'duration': 6.687}, {'end': 741.744, 'text': 'So we know that the start node has to be connected to the read CSV activity, since the data has to be fetched from here right?', 'start': 735.174, 'duration': 6.57}], 'summary': 'Creating a data table variable and connecting it to the csv file for processing.', 'duration': 52.169, 'max_score': 689.575, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8689575.jpg'}], 'start': 538.234, 'title': 'Automating google form and uipath', 'summary': 'Demonstrates automating google form for multiple records with csv data and using uipath for reading data from a csv file and creating a flow chart, aiming to automate processes for efficiency in data input and flow chart creation.', 'chapters': [{'end': 576.845, 'start': 538.234, 'title': 'Automating google form with csv data', 'summary': 'Demonstrates the process of automating the google form to fill in multiple records and fetch data from a csv file, highlighting the manual process for a single input and the goal to automate for multiple records.', 'duration': 38.611, 'highlights': ['The Google form will start filling by itself with the given input, click on the Submit button, and then go back, illustrating the automation process for a single input.', 'The demonstration emphasizes the need to automate the process for multiple records and fetch data from a CSV file to streamline the input process.']}, {'end': 774.999, 'start': 577.226, 'title': 'Uipath: reading csv and creating flow chart', 'summary': 'Demonstrates the process of reading data from a csv file using uipath, creating a flow chart and configuring the read csv activity, with the aim of fetching data for one time.', 'duration': 197.773, 'highlights': ['The chapter demonstrates the process of reading data from a CSV file using UIPath. The speaker discusses the process of reading data from a CSV file using UIPath to fetch information.', 'Creating a flow chart and configuring the read CSV activity. The chapter explains the creation of a flow chart and the configuration of the read CSV activity within UIPath.', 'Configuring the read CSV activity to the file pathway from where data has to be fetched. The demonstration includes configuring the read CSV activity to fetch data from a specific file pathway.']}], 'duration': 236.765, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8538234.jpg', 'highlights': ['Demonstrates automating Google form for multiple records with CSV data and using UIPath for reading data from a CSV file and creating a flow chart.', 'The Google form will start filling by itself with the given input, click on the Submit button, and then go back, illustrating the automation process for a single input.', 'The demonstration emphasizes the need to automate the process for multiple records and fetch data from a CSV file to streamline the input process.', 'The chapter demonstrates the process of reading data from a CSV file using UIPath.', 'Creating a flow chart and configuring the read CSV activity within UIPath.', 'Configuring the read CSV activity to the file pathway from where data has to be fetched.']}, {'end': 1080.815, 'segs': [{'end': 847.34, 'src': 'heatmap', 'start': 810.58, 'weight': 0.762, 'content': [{'end': 812.581, 'text': 'That is the Excel demo over here.', 'start': 810.58, 'duration': 2.001}, {'end': 816.383, 'text': "Let's just right click on this activity and then cut this activity.", 'start': 812.781, 'duration': 3.602}, {'end': 819.244, 'text': 'All right, and then open the sequence activity.', 'start': 816.703, 'duration': 2.541}, {'end': 826.707, 'text': 'Once you open the sequence activity in the do section of the open browser, you have to include the for each row activity right?', 'start': 819.944, 'duration': 6.763}, {'end': 828.748, 'text': "So let's just paste this activity here.", 'start': 826.747, 'duration': 2.001}, {'end': 832.38, 'text': 'in the body section of the for each activity.', 'start': 830.217, 'duration': 2.163}, {'end': 835.164, 'text': "So let's just drag and drop everything that's beneath it.", 'start': 832.801, 'duration': 2.363}, {'end': 838.027, 'text': 'So let me just drag and drop it here one by one.', 'start': 835.524, 'duration': 2.503}, {'end': 847.34, 'text': 'And then let me just delete this body section.', 'start': 845.157, 'duration': 2.183}], 'summary': 'Demonstration of excel automation with sequence and for each activities.', 'duration': 36.76, 'max_score': 810.58, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8810580.jpg'}, {'end': 884.894, 'src': 'embed', 'start': 861.204, 'weight': 2, 'content': [{'end': 867.625, 'text': 'So, in the do section of its body we have mentioned that for each row in the data table, that is, from the each row in the Excel file.', 'start': 861.204, 'duration': 6.421}, {'end': 871.286, 'text': "We're going to read data and then give it as input to the Google Forms.", 'start': 867.865, 'duration': 3.421}, {'end': 873.366, 'text': "All right, so that's what's happening.", 'start': 871.906, 'duration': 1.46}, {'end': 882.432, 'text': "So now let's go back to our main workflow and then let's connect the read CSV activity to the sequence so that the data can be fetched from the Excel file right?", 'start': 873.968, 'duration': 8.464}, {'end': 884.894, 'text': "So let's just connect this activity now.", 'start': 882.913, 'duration': 1.981}], 'summary': 'Using uipath, data from each row in an excel file is read and inputted into google forms.', 'duration': 23.69, 'max_score': 861.204, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8861204.jpg'}, {'end': 1022.617, 'src': 'embed', 'start': 978.246, 'weight': 0, 'content': [{'end': 985.521, 'text': 'So when you run this program, You can see that all the fields are filled automatically in the Google form.', 'start': 978.246, 'duration': 7.275}, {'end': 987.465, 'text': "right?. It's not just happening once.", 'start': 985.521, 'duration': 1.944}, {'end': 991.353, 'text': "it's happening until the time it's able to fetch the details from the Excel file, right?", 'start': 987.465, 'duration': 3.888}, {'end': 1022.617, 'text': 'So after the project has run successfully, it will return back to the uipath tool.', 'start': 1018.712, 'duration': 3.905}], 'summary': 'Automated program fills google form fields from excel until completion.', 'duration': 44.371, 'max_score': 978.246, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8978246.jpg'}, {'end': 1065.785, 'src': 'embed', 'start': 1042.823, 'weight': 1, 'content': [{'end': 1050.625, 'text': 'you can implement this at a large scale industry where many hyper growth companies are using it to automate the task, to save time,', 'start': 1042.823, 'duration': 7.802}, {'end': 1053.886, 'text': 'money and also get the task done with high accuracy right?', 'start': 1050.625, 'duration': 3.261}, {'end': 1058.867, 'text': "So that's how automation will help you to enhance your businesses in the scaling industry.", 'start': 1054.326, 'duration': 4.541}, {'end': 1060.708, 'text': 'I hope you like this session.', 'start': 1059.407, 'duration': 1.301}, {'end': 1062.468, 'text': 'Thank you and have a great day.', 'start': 1061.008, 'duration': 1.46}, {'end': 1065.785, 'text': 'I hope you have enjoyed listening to this video.', 'start': 1063.664, 'duration': 2.121}], 'summary': 'Automation can save time, money, and improve accuracy for hyper growth companies.', 'duration': 22.962, 'max_score': 1042.823, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf81042823.jpg'}], 'start': 775.552, 'title': 'Automating excel data processing with uipath', 'summary': 'Demonstrates the process of automating data input from an excel file into google forms using uipath, enhancing business processes and saving time and money.', 'chapters': [{'end': 1080.815, 'start': 775.552, 'title': 'Automating excel data processing with uipath', 'summary': 'Demonstrates the process of automating the iteration and input of data from an excel file into google forms using uipath, highlighting the efficiency and scalability of automation in enhancing business processes and saving time and money.', 'duration': 305.263, 'highlights': ['Automating the iteration and input of data from an Excel file into Google Forms The process involves using UiPath to iterate through records in an Excel file and inputting the data into Google Forms, demonstrating the automation of manual tasks.', 'Efficiency and scalability of automation in enhancing business processes The demonstration showcases how automation can enhance business processes by saving time, money, and ensuring high accuracy, making it suitable for implementation in large-scale industries.', "Demonstration of automation's ability to save time and money The automation of tasks using UiPath is highlighted as a means to save time and money, aligning with the needs of hyper growth companies and scaling industries."]}], 'duration': 305.263, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/tjg4rFQejf8/pics/tjg4rFQejf8775552.jpg', 'highlights': ['Demonstrates the process of automating data input from an excel file into google forms using uipath, enhancing business processes and saving time and money.', 'Efficiency and scalability of automation in enhancing business processes The demonstration showcases how automation can enhance business processes by saving time, money, and ensuring high accuracy, making it suitable for implementation in large-scale industries.', 'Automating the iteration and input of data from an Excel file into Google Forms The process involves using UiPath to iterate through records in an Excel file and inputting the data into Google Forms, demonstrating the automation of manual tasks.', "Demonstration of automation's ability to save time and money The automation of tasks using UiPath is highlighted as a means to save time and money, aligning with the needs of hyper growth companies and scaling industries."]}], 'highlights': ['The automation fetches details from a CSV file and automatically fills a Google form, streamlining the process and saving time.', 'Demonstrates the process of automating data input from an excel file into google forms using uipath, enhancing business processes and saving time and money.', "Demonstration of automation's ability to save time and money The automation of tasks using UiPath is highlighted as a means to save time and money, aligning with the needs of hyper growth companies and scaling industries.", 'The chapter covers automating the process of filling out a Google Forms application using UiPath, including opening the browser, identifying form elements, inputting data, automating the submit button, and adding a delay of three seconds.']}