Cheat Sheet
Studio Pro activities definition.
General
Logic
Activity | Definition |
---|---|
Assign value to variable | Create and modify variables |
If... then | Apply business logic and define conditions to perform actions |
Do-while loop | Build repetitive operations using the while loop programming concept |
Subprogram | Trigger another workflow from the current one |
Delay | Define a timeout to execute the next step of the workflow |
Log | Save written data from the workflow in a text file |
Console log | Print a message to the Studio Pro console |
Open Application | Select a desktop application to be opened by the workflow |
TODO | Add an informative text block to your workflow |
Human in the loop
Activity | Definition |
---|---|
User notification | Set up a pop-up window with a custom message |
Select file or folder | Ask users for a path to access a file or folder |
Input dialog | Allow users to add text to a variable via dialog window or to add a preset message |
Block input
Activity | Definition |
---|---|
Block input | Disable a specific input from mouse or keyboard |
Unblock input | Cancel the effect of "Block input" |
AI Activities
OS Automation
File&Folders
Activity | Definition |
---|---|
Read text file | Add block to read a text file |
Append to file | Insert text to a specific file |
Copy file | Copy a file from a directory |
Create file | Create a new file in a specific directory |
Delete file | Select a specific file to be deleted |
File found? | Set the bot to perform an action in case a specific file exists |
File information | Extract information from a file |
Move file | Move a file to a specific directory |
Overwrite file | Delete content from a file and write a new text to it |
List directory files | Extract names of all files from a directory and stores them in an array |
Create directory | Create a folder in a specific directory |
Zip files | Compress a file or folder and add it to an archive |
Unzip files | Extract files from a compacted archive |
File trigger | Monitor a folder to execute an action in case a specific file appears |
Credentials
Activity | Definition |
---|---|
Get password | Import password from one of your accounts in Studio Pro Settings and use them to log in to a web service (e.g. Gmail) |
Get username | Import credentials from one of your accounts in Studio Pro Settings and use them to log in to a web service (e.g. Gmail) |
Clipboard
Activity | Definition |
---|---|
Read clipboard | Save the content from clipboard to a file |
Clear clipboard | Erase all content from clipboard |
Copy to clipboard | Copy values to clipboard |
System
Activity | Definition |
---|---|
Shutdown computer | Log off, restart, or turn off the computer |
Process found? | Execute an action in case a specific process is running — and another action in case it is not |
Kill process | Stop a specific process |
Command Prompt | Execute a process using the terminal in the background |
GUI Automation
Mouse
Activity | Definition |
---|---|
Click on element | Choose a desktop element to click on it |
Click on coordinate | Click on a specific point in the screen |
Read checkbox state | Get the value from a specific checkbox |
Set checkbox state | Set the state of a specific checkbox |
Select list item | Choose an item from a drop-down list |
Keyboard
Activity | Definition |
---|---|
Input to desktop app | Type a text into a desktop app |
Send hotkey | Simulate pressing a hotkey or a key combination |
UI
Activity | Definition |
---|---|
Get element property | Select an item to extract its value |
Get element value | Choose an element to obtain its value |
Get position | Choose an element to obtain its size and coordinates |
Set element value | Change the value of a given element |
Element found? | Check if a specific element exists — and trigger an action if it does |
Wait for element | Execute an action if an element appears after a given amount of time |
Wait for vanishing | Execute an action if an element disappears after a given amount of time |
App Window
Activity | Definition |
---|---|
Maximize element | Set an application window to its maximum size |
Minimize element | Minimize all application windows |
Activate element | Bring a specific element to the foreground |
Close window | Close a specific application |
Machine vision
Activity | Definition |
---|---|
Click on image | Find an image on the screen and click on it |
Find image | Find an image on the screen and get its coordinate |
Take a screenshot | Capture the image of the entire screen |
Wait for image | Define a time limit to wait for a specific image to appear on the screen |
Web Automation
Web Browser
Activity | Definition |
---|---|
Open URL | Open a new web browser window |
Close browser | Close the browser opened |
Find iframe | HTML element that is able to load another HTML element |
Execute JavaScript | Execute separately written JavaScript code |
Scrape structured data | Extract data according to a given structure |
Mouse
Activity | Definition |
---|---|
Click on element | Simulates clicking a specific browser element |
Hover over element | Hovers the mouse cursor over the specified element |
Drag and drop element | Simulates drag and drop of a web page element |
Select List Item | Select a specific item in a dropdown list |
Keyboard
Activity | Definition |
---|---|
Input to browser | Input some text into browser elements |
Send Hotkeys | Simulate pressing a hotkey or a key combination |
UI
Activity | Definition |
---|---|
Get Element Property | Reads attributes of a specified element |
Get Element Value | Reads the value attribute or the text between tags |
Set Element Value | Sets the 'value' attribute of the specified element |
Set Element Property | Sets a certain property of the specified element |
Element found? | Checks whether the element exists |
Wait for element | Wait until the element is loaded |
Wait for vanishing | Waits for web element to disappear for specified amount of time |
Programming
Strings
Activity | Definition |
---|---|
Text found? | Searches through a text and check if it contains a string |
Extract text | Extract portions of text placed between the specified words |
Dates and time
Activity | Definition |
---|---|
Get current date | Get the current date according to the system time |
Calculate date | Calculates a date and time using given date and a delta |
Calculate difference | Calculates the difference between two dates |
Export to format | Convert date and time into a specific format |
Time trigger | Execute further steps of the workflow when a certain time arrives |
API
Activity | Definition |
---|---|
HTTP request | Sends an HTTP request with the specified parameters |
Get OAuth token | Performs an OAuth 2.0 authorization |
Databases
Activity | Definition |
---|---|
Connect to Database | Establish the connection to DBMS |
Execute query | Executes a database query |
Others
Activity | Definition |
---|---|
Execute JS code | Run JavaScript code in Studio Pro |
Execute Python | Run Python code in Studio Pro |
Spreadsheets
Tables
Activity | Definition |
---|---|
Read table | Read the contents of a specified table |
For each row | Apply a set of actions to each row in the specified table |
Remove empty rows | Removes all empty rows from a table |
Save table | Save the table in Excel, Google Sheets or CSV format |
Google Sheets
Activity | Definition |
---|---|
Get values | Reads a content of a Google Sheets table in a specified range |
Update values | Changes a content of cells within the specified range |
Append values | Adds values to the first completely empty line in a table |
MS Office
MS Word
Activity | Definition |
---|---|
Read Word file | Reads the content of a Word file |
Write Word file | Overwrites the content of a Word document |
Append to Word | Appends data to a Word document |
Replace Words in Template | Replace words in a Word file with the desired values |
MS Excel
Activity | Definition |
---|---|
Read Excel File | Read the contents of an Excel table |
Write Excel File | Write specified values to a specified range in an Excel file |
Append row to Excel file | Add a row to the end of an Excel sheet |
Insert/Delete Rows | Insert or delete a row in an existing Excel document |
Read Excel Range | Get the value of the range from the Excel file |
Write Excel Range | Write specified values to a specified range in an Excel file |
Read Excel Row | Get a particular row value from the Excel file |
Update Excel Row | Updates particular row values in the Excel file |
Read Excel Cell | Reads the value of a specified cell in an Excel document |
Update Excel Cell | Updates the content of specified cells in an Excel document |
Execute Macro | Execute a .vbs-macro in the selected Excel file |
Insert/Delete Columns | Insert or delete a column in an existing Excel document |
Read Column | Read data from a selected column in an Excel document and save it to a variable |
Append Column | Insert a column at the end of the selected Excel document |
Update Column | Overwrite data in a certain column of an Excel document |
Sort Range | Sort the range of data in the Excel file by column |
AutoFill Formula | Automatically extend a formula across a range of cells |
MS Outlook
Activity | Definition |
---|---|
Read Emails | Read emails received in the Outlook mail service |
Send email | Send an email using the Outlook mail service |
Office 365
Activity | Definition |
---|---|
Read emails | Read emails stored in your Microsoft account |
Send email | Sends an email using a Microsoft account |
Email
Outlook
Activity | Definition |
---|---|
Read Emails | Read emails received in the Outlook mail service |
Send email | Send an email using the Outlook mail service |
This activities copy the functionality of the same activities in the "MS Office" section.
Office 365
Activity | Definition |
---|---|
Read emails | Read emails stored in your Microsoft account |
Send email | Sends an email using a Microsoft account |
This activities copy the functionality of the same activities in the "MS Office" section.
Others
Activity | Definition |
---|---|
For each email | Work with one email at a time |
Read emails | Read emails from a specified date |
Send email | Sends a message via an email |
Email trigger | Trigger other activities when an email appears |
Document Processing
IntelliDocs
Activity | Definition |
---|---|
Extract Document Data | Apply Intelligent Document Processing (IDP) in your workflow with just a few clicks |
OCR Engines
Activity | Definition |
---|---|
Microsoft Cloud OCR | Recognizes an image text using Microsoft OCR technology |
Google Cloud OCR | Recognizes an image text using Google OCR technology |
ABBYY Cloud OCR | Recognizes an image text using the ABBYY Cloud OCR technology |
Recognition template | Specify a document that will be used as the recognition template |
Data Extraction
Activity | Definition |
---|---|
Klippa OCR | Recognize text using the Klippa OCR service |
Nanonets OCR | Recognize the text using the Nanonets OCR service |
Microsoft Form Recognizer OCR | Recognize text using the Microsoft Form Recognizer service |
Amazon Textract OCR | Recognize text from image using the Amazon Textract OCR service |
CaptureFast OCR | Recognize text from image using the CaptureFast OCR service |
PDF
Activity | Definition |
---|---|
Read Text | Extract the text layer from a PDF file |
Convert to Image | Convert a PDF file to an image |
Extract Page Range | Extract selected pages from the PDF file to a new PDF file |
Get PDF Page Count | Count the number of pages in a PDF file |
Combine to PDF | Combine multiple files into a single multi-page PDF |
Citrix & RDP
Surface Automation
Activity | Definition |
---|---|
Click on image | Find an image on the screen and click on it |
Find image | Find an image on the screen and get its coordinate |
Take a screenshot | Capture the image of the entire screen |
Wait for image | Define a time limit to wait for a specific image to appear on the screen |
This activities copy the functionality of the same activities in the "GUI Automation" section.
Terminals
Activity | Definition |
---|---|
Input from keyboard | Input text to a specified field or terminal area |
Read text from area | Reads the content of a specified terminal area |
Wait for text | Waits for a text in a specified terminal area |
Connectors
Google Drive
Activity | Definition |
---|---|
Download File | Download a file from your Google Drive |
Upload file | Upload a file from your computer to your Google Drive |
Create directory | Create a new folder in your Google Drive |
Updated about 1 year ago