Rovo agent to send emails

[Marcos Pino Flores]

Hello, I hope you're all doing well.

I'm working on a project to automate account creation in Jira. I have a Jira Service Management space where a ticket is created and an Excel file must be attached. Therefore, I need a Rovo agent that can read the attached file, which will always have the same structure and contain information for each row. I need Rovo to read this and, for each row, send an email with the corresponding information.

I'm hoping someone who has done something similar can offer some guidance.

Thanks

[Martin Runge]

Hi @Marcos Pino Flores

That's an interesting workflow, but I would question the use of an Excel attachment here. Although Rovo is improving daily, extracting individual rows from a spreadsheet to trigger separate emails is complex for automation and increases the risk of formatting errors.

Have you considered using Jira Service Management Forms instead?
Instead of an attachment, you can provide a structured Form to the requester. If the data is captured directly in form fields (or even in an Assets object for bulk data), Jira Automation can handle the emails natively, without needing Rovo to "scrape" a file.

This provides you with structured data, enabling the use of basic email automation and validation processes.

If using an "Excel" file is necessary due to data originating from an external system, consider that Jira Assets or third-party tools like ScriptRunner may offer more reliable file parsing than a Rovo agent for this particular task.

[Marcos Pino Flores]

Hi @Martin Runge!

Thank you so much for your reply. I decided against using a form because user creation is usually done in bulk (sometimes adding or removing up to 50 users). Therefore, the idea with the Excel option is to have one collaborator per row.

Anyway, I'll see if I can find an alternative using ScriptRunner.

Regards