Send excel file when ticket is created.

Question

Hello,

Is it possible to send an excel file with all the custom fields data as an email to a user.

Example:-

if a jira ticket is created an email should be sent to me with an attachment of an excel sheet with all custom field name and its data.

Regards,

Sunil

Jordan Hauser · Answer

Just looked into these suggestions, the 'Better Excel Automation for Jira' is indeed free, but it has dependencies from the 'Better Excel Exporter' which as you said is not free, which makes the first one actually not a free option

Levente Szabo [Midori] · Answer

@G Sunil Kumar

As Ravi Mentioned, you can use a dedicated solution to automatically generate and email (or attach, save to local filesystem) a native Excel file from Jira.

The combination of Better Excel Exporter and Better Excel Automation for Jira provides a no-code option for this, as the app adds new actions to Automation for Jira, which includes "Send Excel".

Watch this short tutorial that shows how you can make it work: https://www.youtube.com/watch?v=vdDAoCTdJNc&t=32s

(Please note that Better Excel Automation for Jira is free, while Better Excel Exporter is a paid and supported app and I'm part of the team developing both apps.)

Ravi Sagar _Sparxsys_ · Answer

Hi Sunil,

It is very simple to generate a simple csv. In Groovy you have methods to create a file on disk and write on it.

File file = new File(/tmp/tmp.csv)

file.write("name,age,number")

In this case it is just one line but you can build your csv with multiple lines as well.

Ravi