Create XML from Google Sheets in a certain xml format

Questions & Answers
1

Hello everyone,

I have the following issue. I want to supply an AI with information through a Google Sheets and have it generate a text. This sheet is structured like a data feed. The generation of texts and their association with IDs works well.

However, I am now faced with the problem of generating an XML file from the spreadsheet where the output is located, following a specific XML format.

For clarification, I have 2 workflows. The first for generating the text and to get it into another sheets tab. The second should generate the xml.

My current workflows looks like this:
First workflow:

image
image1054×324 27.6 KB

Second workflow:

image
image1242×311 37.8 KB

However, it only creates the aggregated text and not the XML.

Here is how the XML should look in the end:

image
image850×316 6.63 KB

And here is how make generates the xml output right now:

image
image538×502 6.28 KB

2

Hello again,
after a bit of trying and finding some help in the community I changed the workflow a bit. I’m using now a Aggregator to JSON and a JSON to XML converter.

image
image1242×324 40.7 KB

image

This seems to work better but i still don’t have the right data structure. I’m no developer and have only very rudimentary skills in editing xmls. I also tried to recreate the needed data structure from scratch but there i have the problem that i can’t use “:” or other characters in the name of an array.

So maybe someone can help me to create the right data structure.