Examples of building bots

Use these example tasks to become familiar with the features and learn to build bots in Automation 360.

Common automation tasks and examples
This document lists common automation tasks and examples for the tasks.
Example of entering data into a web form from a spreadsheet
Build a bot that reads multiple rows of data from an XLSX sheet and enters it into a web form. Use actions from the Excel advanced, Loop, and Recorder packages to build the bot.
Example of passing a value between bots
Learn how to pass a value from one Task Bot to another by using a dictionary variable.
Example of using a conditional statement
In this example, you build a bot that prints a message based on whether a cell has a value or is empty. Use the actions from the Excel basic or Excel advanced, If, and Message Box packages.
Example of using Python script to join a list
Build a bot that uses a Python function to print the message Go Be Great!, the Automation Anywhere version of Hello World. In this example, the bot combines a list of string values and prints them to a message box.
Example of using the DLL package
Build a very simple DLL that will generate a message. Create a bot to run the DLL.
Example of transferring data from CSV file to Excel worksheet
Build a bot that reads data from a CSV file and updates the data in an Excel worksheet, using actions from the CSV/TXT, Excel advanced, IF/ELSE, and Loop packages.
Run TaskBot to merge Excel sheets
Download and run sample Task Bot from the Bot Store to merge two spreadsheets.
Example of migrating data from Excel to a database
In this example, you build a bot to transfer values from an Excel spreadsheet to a database using actions from the Database, Excel advanced, and Loop packages.
Example of reading data from a spreadsheet
Build a bot that reads data from one Excel worksheet and writes it to another worksheet.
Example of using the Run action
The Run action from the Task Bot package enables you to run and pass values to one or more child bots. In this example, you use the Run action to pass two values from a parent bot to the child bot; the child bot adds the values and passes the sum back to the parent bot.
Example of using the SOAP web service action
Use the SOAP web service action to pass two numeric values and return the sum from an online calculator application.
Example of using Get structure command from SAP BAPI package
Using the SAP BAPI package, build a bot that inputs a structure to get data.
Example of writing data to SAP using SAP BAPI package
Using the SAP BAPI package, build a bot that writes data to the SAP database.
Example of using Run standard workflow from SAP BAPI package
Using the Run standard workflow action from the SAP BAPI package, build a bot that retrieves data from SAP systems.
Example of using the VBScript package in a resilient bot
Build a bot that executes a Microsoft Visual Basic script. Use the Try/Catch package to gracefully end the bot if it fails, making it resilient to crashes. A resilient bot allows scheduled and queued bots to continue even if the current bot encounters an error.
Build a Bot Insight dashboard bot
In this example, you build a bot that retrieves data from a website to create visualizations in Bot Insight.
Example of using multiple analyze actions in a task
Build a bot that uses multiple Open and Close Analyze actions in a task to analyze and compare the sales data for each quarter of XYZ Company, and create visualizations in Bot Insight.
Example of updating default package version across bots
This example shows how to perform a bulk update of multiple bots in the Control Room repository and use the default version of the Excel advanced and Message Box packages.
Example of using remote function call in SAP
This example describes how to build a bot that will create a document in SAP using the remote function call method.
Example of using JSON package actions in a bot
Build a bot that runs a JSON script with multiple records. In this example, we use a JSON file that contains a list of feeds from a blog, and the bot extracts the required information from the JSON file and prints it to a message box.
Example using Email actions in a bot
In this example, we use email actions to perform email-related operations using Outlook Client.
Example using user account actions from Active Directory package
This example shows how to use actions to automate user account management tasks, such as: Create, Delete, Get property, Remove, Rename, and Set property.
Example of using Custom column option in Data Table package
In this example, you will build a bot to read a CSV file, assign it to a data table variable, and then modify the table by adding a new column. Use the Custom column option in the Data Table package to insert columns at a specified index.
Example of using a file variable
Learn to use file variables in bots. There can be instances where a bot needs to access a file multiple times based on the task it performs. You can store file references in file variables and use the file variables in bots instead of adding direct file paths.
Example of using Custom selection option in Log variables to file action
In this example, you will use the Custom selection option to log user-defined variables to an existing log file and then modify the values of the variables and log the appended data into a file.
Create dictionary type variables
Use Automation 360 to create dictionary type variables using different dictionary subtypes and key value type parameters.

Parent topic: Build automations