Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Connect AA to ChatGPT
This bot connects AA to ChatGPT. The output is an Excel file containing the responses generated using the API Key that is provided by ChatGPT
Top Benefits
- Use both ChatGPT and Automation Anywhere to automate real-time customer care and support interactions
- Conversational AI system that can increase process efficiency and customer experience
Tasks
- Excel Advanced : Open action to open an Excel file
- Loops throught an Excel file using get single cell action to get questions ChatGPT will answer for using the API
- Use the REST Web Services: Post method action to make requests
- JSON: Get node value to get the response, then store it in a variable
- Excel Advanced : Set cell action to put the response of each question in the appropriate cell of the EXCEL file
* The bot connects Automation Anywhere to ChatGPT.
* The input is an Excel file that contains a variety of requests ChatGPT is supposed to respond to
* The bot then:
-Opens the Excel file, loops through each row of the worksheet, gets the query
-Uses an API key generated from OpenAI to request a query and get the response
* The output is fetched responses that are then stored in the same EXCEL file