Confluence Cloud: create multiple pages using a n external list or spreadsheet

[Kathy Hart]

We use Confluence for documentation and one thing we do is a data dictionary with a separate page for each element. Each page contains a Page Property Macro with details about the data element, then there is a summary page that uses a Page Properties Report to pull the list together. 

When we get a new data asset that needs to be added, we usually receive a spreadsheet with the data element info. One element per line. Some of these data assets have 100 or more data elements. Our longest one had 400. That's a lot of pages to manually create.

What we want to do is use that spreadsheet with some programming and confluence api access to automatically create the page for each data element using a Confluence Template (already in existence).  We want to pull text from each spreadsheet cell to populate the table within the Page Property Macro.

Has anybody done that? 

One of our database programmers tried it, but the api gave him fits, and other projects took priority so he was unable to finish it. Our work via the Jira api seems to go fine, but Confluence is more finicky, I guess.