Video shows an example of Zappy automation created to obtain a list of companies’ stock prices from London Stock Exchange (LSE) website.
User creates an excel sheet with desired company codes and respective price columns need to be updated from LSE.
Step 1: Right click on Zappy icon select Start learning .
Step 2: User has to manually copy the company code from second row, first column of the excel sheet and enter in search box of LSE. Click on search to see the results.
Step 3: Copy the price of searched Company Code and paste it in Price Column (Column 2, Row 2) of the Excel sheet. Place cursor on the second company code (Column1, Row 3).
Step 4: Right click on Zappy icon select Stop learning .
Step 5: Click on Z icon that appears on top of Excel window
Select all learned activities. From drop down list select how many times you want to run the task & Click on Run.
Step 6: After running Learned activities, you will see Custom Activity displayed in Zappy Context menu.Select all custom activities.
Then click on Open On Task Editor Icon.Task editor will opens.
Step 7: When you select CustomActivity, Zappy automatically adds For Loop Start & For Loop End actions. Now you can change For Loop Initial & Final Value as per your requirement by clicking on For Loop Start.
Step 8: Now click on Execute button .Zappy will automatically search each company code and enter the price in Excel sheet.
Step 9: Once the task is executed, Zappy gives “Successfully Executed Task” message on Right hand corner of your window.
In this way zappy has extracted data from Web & entered it in excel.