Course materials

Course resources

• Copy Files Loop Template

  The bots in this section introduce and provide templates for looping through various activities. This bot copies files from one location to another. This example introduces a loop structure for copying files across directories, adding a suffix with the letters bk and timestamp in yyyyMMdd format. Repository snapshot; original classroom version unverified.

  Open Copy Files Loop Template

• Process Excel Rows Loop Template

  The bots in this section introduce and provide templates for looping through various activities. This bot processes rows in an Excel file. This example demonstrates a starter process for how to loop through rows in an Excel file and perform conditional statements this example prints to the console log. Repository snapshot; original classroom version unverified.

  Open Process Excel Rows Loop Template

• For Each Email Loop Template

  The bots in this section introduce and provide templates for looping through various activities. This bot processes each email in an inbox by displaying the from and subject in the console log. This example shows how to loop through emails in an inbox as a starter template to perform actions such as reading or categorizing email. Repository snapshot; original classroom version unverified.

  Open For Each Email Loop Template

• Conditional Loops Template

  The bots in this section introduce and provide templates for looping through various activities. This bot demonstrates conditional looping logic. This example shows how to implement conditional loops using if statements in UiPath. Historical download unavailable.

• Example Join Template

  The bots in this section introduce and provide templates for joining data from various sources. This bot demonstrates how to join data from two spreadsheet sources. This example shows how to join data from two spreadsheet sources in UiPath. Historical download unavailable.

• Merge PDFs Template

  The bots in this section introduce and provide templates for joining data from various sources. This bot demonstrates how to merge multiple PDF files into a single document. This example shows how to merge multiple PDF files into a single document in UiPath. Historical download unavailable.

• Example Web Table scraping Template

  The bots in this section introduce and provide templates for scraping data from websites. This bot demonstrates how to scrape data from a web table. This example shows how to scrape data from a web table in UiPath targeting the S&P 500 constituents. Historical download unavailable.

• Scrape Population data with Conditional Loops Template

  The bots in this section introduce and provide templates for scraping data from websites. This bot demonstrates webscraping a table with conditional looping logic. This example shows how to implement conditional loops using if statements in UiPath. Historical download unavailable.

• Email LLM Integration Template

  The bots in this section introduce and provide templates for adding LLMs to your UiPath workflows. This bot demonstrates integrating an LLM for email processing. This example shows how to integrate an LLM for processing emails in UiPath. Repository snapshot; original classroom version unverified.

  Open Email LLM Integration Template

• Extract PDF Text Template

  The bots in this section provide templates for various other UiPath automation tasks. This bot demonstrates how to extract text from PDF files. This example shows how to extract text from PDF files in UiPath. Historical download unavailable.

• Log using assign to a text variable that outputs one line of log per entry.

  The bots in this section provide templates for logging in UiPath and routing those logs to a saved location. This bot demonstrates how to save a log to a google document. This bot demonstrates how to save a log to a google document.. Historical download unavailable.

• UiPath Robot Library

  Downloadable templates and examples for UiPath-based automation projects. Below is a browsable list of UiPath bot templates and examples. Click on the folders below to access them. Each bot includes a description of its functionality and a download link for the .uip file that can be opened in UiPath Web Studio. For Desktop Studio files, you can either browse the GitHub repository directly or download the complete repository using git clone (if you have Git installed) or by using curl in the command prompt. To download the full repository using Git: git clone https://github.com/ashercurtis/robots.io.git To download the repository as a ZIP file using curl: curl -L -o robots_io.zip https://github.com/ashercurtis/robots.io/archive/refs/heads/main.zip After downloading, unzip the file and open the desired folder in UiPath Studio.

  Open UiPath Robot Library

Class 1: Course Introduction and Set-up

Class 2: Introduction to Automation Essentials

Class 3: Data Tables and Spreadsheet Automation

Class 4: Processing Data and Data Objects using Loops and Variables

Class 5: Individual RPA Workshop

Class 6: Automation Design Concepts

Class 7: Mini-Cases in Automation: Part 1

Class 8: Mini-Cases in Automation: Part 2

Class 9: Individual RPA Workshop

Class 10: The Data Validator Challenge

Class 11: Introduction to Agentic Workflows

Class 12: Cases in Agentic Automation

Class 15: Advanced Topics in Automation and RPA, 1