Robotic Process Automation (RPA) with OpenRPA

Explore open rpa in depth, learn basics like variables, recorder, and snippets, and navigate the open rpa interface—settings, projects, permissions, imports, exports, and run controls.

Explore the toolbox and activities in Open RPA, drag actions such as open application and read excel into your workflow, and use the properties panel to configure mandatory arguments.

Explore how to use snippets in OpenRPA by dragging dialog form and simple FA snippets into a workflow, then run it to see notifications and a submitted form.

Learn how to use arguments to pass values between Open RPA workflows, including in, out, and in out directions, by invoking workflows and echoing results in logs.

Explore how to view and manage RPA execution logs in OpenRPA, switching log types between output, activity, and network, clearing logs, and analyzing activity start and end.

Explore how automation reads an Excel file, extracts data, opens a browser, and submits each row’s name, email, age, and city into a web form using OpenRPA.

Create a new OpenRPA workflow and use the Read Excel activity to load data from an Excel file into a data set, using the header row and closing the file.

Learn how to automate a browser with OpenRPA by installing the Google Chrome extension, launching Chrome to a web form, and preparing to loop through an Excel file.

Automate filling form fields in OpenRPA by reading Excel rows, selecting fields, and assigning values with sign activities for name, email, age, and city.

Develop an automation that reads each row from an Excel file, opens the web form in Chrome, fills the fields, and submits the form.

Design a robot that reads unread Outlook emails, moves them to folders by subject keywords (Microsoft, Amazon, Apple), and replies, then sends a final email to end the automation.

Loop through each email using the get mails activity inside the loop to extract data. Access subject, sender, and body to test and verify the robot's data retrieval.

Learn to automate email routing with OpenRPA by using if conditions to move emails to Microsoft, Amazon, Apple, or the folder others based on subject keywords, with case-insensitive checks.

Learn to reply to each email using the OpenRPA activity reply mail, configuring body variables and selecting reply and send options for automated responses.

Develop an OpenRPA robot that retrieves emails, sets the subject, recipient, and body, and uses the New mail item to send messages after processing all emails.

Develop a robot to scrape book names and prices across a multi-page bookstore and export the data to an Excel file.

Learn to scrape every listed book on a page by configuring selectors for chrome, targeting multiple items, and preparing to extract each book’s name and price.

Build an OpenRPA robot to scrape each listed book's name and price. Use get helmet and open selector, and capture full titles from the title attribute across pages.

Learn to scrape books data across multiple pages using a do while loop in OpenRPA, extracting titles and prices while navigating next page buttons and counting pages with a variable.

Drag the create data table activity from the toolbox before the open while activity. Create a data_books variable of type data table and define two columns, title and price.

Learn how to use OpenRPA's add row activity to populate a data_table_books with book title and price from extracted data, preparing to export to Excel.

Build robots that extract invoice data from a folder, processing each invoice to capture the invoice number, date, and grand total, and export the results to an Excel file.

Learn to extract text from invoice PDFs with OpenRPA using the read PDF activity, create an invoice text variable, and verify output.

Extract invoice number, date, and grand total using pattern-based regular expressions from a shared template. Test expressions on an online tester, then implement extraction in OpenRPA.

Learn to tackle the RPA challenge by building a workflow that inputs spreadsheet data into dynamically positioned form fields, handles submission, and tracks time and success rate.

Create a workflow named robot six for the RPA challenge, open Chrome with open vial, download the Excel file, wait for download, then read the Excel data.

Automate end-to-end loan processing with OpenRPA: read an Excel file, loop through rows, fill a web form, submit applications, extract APR when approved, and record statuses back to Excel.

Develop a workflow in OpenRPA that reads an Excel file, loops through rows, fills and submits loan forms, and verifies approval to extract rate and APR.

This solution teaches how to verify loan approval in an OpenRPA workflow by detecting an on-screen loan approval label, extracting the loan rate and ID, and logging results to Excel.

Log into open flow to explore dark mode, high-density robots, files, resources, forms, and entities. View analytics dashboards, monitor top workflows, and observe work item queues and node red access.

Execute OpenRPA workflows from Open Flow by selecting the robot, setting the timeout, and starting the robot to run the six RPA Challenge and web data scraping workflows.

Learn to add credentials in open flow and retrieve them in an open RPA workflow using the get credential activity, with a credentials test name and username and password outputs.

Explore how OpenRPA and OpenFlow link tools, hardware devices, APIs, and online services through a backend process flow designer integrator; learn to create a Node-RED instance and access its documentation.