Need help with automating confluence page creation

[Neeraj Kumar]

In my project I need to create multiple (Approx 250) confluence pages having same template. We want to automate this process so that we can pass values in .csv file and those values will get populated in confluence page automatically. That .csv file will have header so values from 2nd row will get populated in 1st confluence page and values from 3rd row will get populated in 2nd confluence page and so on.
Kindly let me know if this is possible. If yes then how we can proceed for that.
If No then only manual page creation is possible?

[Fabio Racobaldo _Herzum_]

Hi @Neeraj Kumar ,

as said by @Alex Koxaras _Relational_ it can't be put in place using builtin features. You need to develop something custom for that.

Fabio

[Neeraj Kumar]

Hi Fabio,

I totally agree that one need to develop customize code which might need to connect with different tools and features for this task.

[Alex Koxaras _Relational_]

Hi @Neeraj Kumar and welcome to the community,

Don't think that it is possible to import csv as pages in Confluence. You can use a word file to import a page, but not a csv.

The only workaround I can think of is to write a script which will call the confluence cloud rest api and then create the pages with populated content.

[Alex Koxaras _Relational_]

In order to populate the pages based on a template, you could also create a Jira automation rule, but you will not be able to update the page content. That you have to do it afterwards with your script.

Finally,

• you can always export the confluence template on a word file
• Make this file suitable for "mailing" and connect it to your csv
• Export the pages in word
• Import them back to confluence

I haven't try the above solution, but it has good possibility of success.

[Neeraj Kumar]

Hi Alex,

Thanks for your prompt response.

I would like to go with solution of writing script and then calling confluence could rest API. It will be helpful if you can help in this approach like in which language I should write that script and how to link that with rest API of confluence cloud.