Consolidated FSR report for 3 bots

Hi, i have a scenario where we have 3 Bots & Bot will provide summary report for all 3. But the challenge is we get some output values from 1st Bot, some from 2nd Bot & some values from 3rd Bot… we have to send email with Consolidated output of all 3 bots…

Have a template ready and then try to consolidate accordingly @Kb_N

Hii @Kb_N

Each of the three bots should save their respective outputs to a common location, such as a shared folder, a database, or an orchestrator queue. Make sure the output data from each bot is stored in a structured format.
Ensure that the bots run in a coordinated manner. You can use UiPath Orchestrator or other scheduling mechanisms to orchestrate the execution of these bots so that they run one after the other.
Create a separate UiPath bot (Bot 4) that is responsible for generating the consolidated summary report. This bot will read data from the outputs of Bots 1, 2, and 3 and compile it into the desired format.
-Use the “Read Range” activity
-Merge or concatenate the data as needed to create the consolidated report.

Use UiPath to create an email with the report attached. You can use the “Send Outlook Mail Message” activity or other email-related activities to send the email.
Schedule the fourth bot to run after the first three have completed their tasks. You can use UiPath Orchestrator to schedule and coordinate the bots.

Thanks & Cheers