ElectroNeek Documentation

Cheat Sheet

Definitions of all Studio Pro activities.


Easley AI

Activity Definition
Ask AI Interact with Artificial Intelligence, ask questions and retrieve answers in seconds
Edit Text Manipulate text in your workflows easily with the assistance of Artificial Intelligence

General

Logic

Activity Definition
If... then Apply business logic and define conditions to perform actions
Do-while loop Build repetitive operations using the while loop programming concept
Assign value to variable Create and modify variables
Delay Define a timeout to execute the next step of the workflow
Subprogram Trigger another workflow from the current one
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
Input dialog Allow users to add text to a variable via dialog window or to add a preset message
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

Block Input

Activity Definition
Block Input Disable a specific input from mouse or keyboard
Unblock Input Cancel the effect of "Block Input"

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

OS Automation

Files & Folders

Activity Definition
Append to file Insert text to a specific file
Read text file Add block to read a text 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
List FTP directory Retrieve the content of an FTP directory
Download File/Folder from FTP Download files or folders from an FTP server
Upload File/Folder to FTP Upload files or folders to an FTP server
Delete FTP File/Folder Remove files or folders from an FTP server

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
Command Prompt Execute a process using the terminal in the background
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
Shutdown computer Log off, restart, or turn off the computer

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 file 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
Duplicate Sheet Create an exact copy of a worksheet in Excel
Remove Sheet Delete a worksheet from the Excel workbook
Clear Range Remove the contents from a specified range of cells
Rename Sheet Change the name of a worksheet in Excel
Copy/Paste Range Duplicate and transfer data between ranges in Excel
Format Cells Adjust the appearance and formatting of selected cells
Get Cell Formula Retrieve the formula used in a specific cell
Locate Cell Find the position of a particular cell within a worksheet
Remove Duplicate Rows Delete duplicate rows from a dataset in Excel
Autofill Formula Automatically extend a formula across a range of cells
Format Data Type Cells Set the data format for selected cells in Excel

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

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 hotkey Simulate pressing a hotkey or a key combination

UI

Activity Definition
Get element property Reads attributes of a specified element
Set element property Sets a certain property of the 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
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

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

These activities have the same functionality as the Machine Vision 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

Programming

Activity Definition
Execute JS code Run JavaScript code in Studio Pro
Execute Python Run Python code in Studio Pro

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

Email

Outlook

Activity Definition
Read emails Read emails received in the Outlook mail service
Send email Send an email using the Outlook mail service

These activities have the same functionality as the MS Outlook 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

These activities have the same functionality as the Office 365 activities in the "MS Office" section.

Others

Activity Definition
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
For each email Work with one email at a time

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

Document Processing

IntelliDocs

Activity Definition
Extract Document Data Apply Intelligent Document Processing (IDP) in your workflow with just a few clicks, using ElectroNeek's IntelliDocs engine

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

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