bcaeda78-0fb6-49c2-804b-c30a20490d4b.png

This workflow is constructed for Excel.

In Excel we have multiple lines of data in each cell for a particular column. By using this workflow we can transpose the data from each cell into a column.

Transpose multiple rows of data from an Excel cell into a column.

**Steps to connect APIs in UiPath Orchestrator**

- Open  in browser.
- Click on Integration Service in UiPath Orchestrator.
- Search for OpenAI in Connectors tab.
- Click on OpenAI  and then click Connect to OpenAI.
- Add the API and click connect in browser.
- The connection will be created in Integration Service.
- To create the connection with OpenAI and UiPath Studio, the system has to be connected with the same mail_id.

**Connection in UiPath Studio:**

- Drag and drop Generate Chat Completion activity, and click on Add New Connection.
- Establish the connection in Integration Service.
- This makes the connection with the API key.

If any changes occur or a new connection needs to be added, click on Manage Connections in UiPath Studio.

This automation helps create emails using ChatGPT.