Examples of RPA Express recordings

rpaexpress
rparecorder

#1

Hi Everyone :grinning:

Do you have automation scripts that you would like to share with the community?

Feel free to post them it in this topic!
net-resizeimage%20(1)

HOW TO SHARE:

Zip the folder with your RPA Express recording and post here with a short description of what the script does.

BEFORE YOU SHARE:

  • make sure you don’t post any sensitive information
  • store login/passwords in Secrets Vault
  • if other users have to change some action to make the script work - add comments to the action
  • attach sample files (Excel, txt, etc) that the script uses and add comments where to use them

It doesn’t matter if it is a small custom action or a large script automating several applications.
If you feel it can be helpful to other users - feel free to share!


Custom script for multiple If conditions
#6

Here is my simple script: outlook-new-email.zip (12.2 KB)

This recording shows how to send bulk emails taken from a spreadsheet.

See the emails.xlsx in the recording folder.

Notes:

  • Your Outlook should be launched.
  • The recording may not work on non-English interfaces.

image


Number of Keystrokes limited to two?
#7

Don’t forget to change the path to the file in ${path_to_excel} variable.


#8

Here is a KB page around a Craigslist Bot demo that the SC team uses: https://kb.workfusion.com/display/RPAe/Craigslist+Bot

Craigslist Bot RPAe File: craigslist-bot.zip (10.6 KB)
Craigslist Bot Execution Video: https://www.dropbox.com/s/rhqn2eoi6n3drpo/Craigslist%20Bot.mp4?dl=0

Negative News Search Bot RPAe File: negative-news-search-bot.zip (17.2 KB)
Negative News Search Bot Execution Video: https://www.dropbox.com/s/5aweadxyheblgas/Negative%20News%20Search%20Bot.mp4?dl=0


#10

Hello everyone. Please see my script delete_row_Excel.zip (7.2 KB)

It shows how to delete row in Excel and shift all other rows up 1 row above.
See sample Excel file in the archive - Book1.xlsx. Pay attention that you need to change path to this file in variable ${file_path}.


Excel delete row option in Actions library [Vote]
#12

Here is a sample script with a custom action:

  • the bot reads a table from an excel file
  • it checks if there are empty cells in one of the columns
  • if the cell is empty - the custom action puts a value (current date) in the cell
  • the bot saves the table back in the excel file.

It helps you to put/change the values right in the Table variable using only 1 action.

write-to-table.zip (1.1 KB)

Note: you need to provide the path to the Excel file in the variable.


#13

Here is my script which shows how to write time to Excel cell: write_time_to_excel.zip (6.3 KB)
Sample Excel file in the archive. Before running script you need to change path to this file in the variable ${file_path}.