Creating Etsy listing from Notion DB Item

Hello! I have been working at this for the last 3 nights and I’m about to call it quits.

I have a Notion database with items that I would like to make into Etsy listings however I am struggling to actually work with my content in Notion.

This is my flow, the other half of the router is generating the content with an openAI flow, which does work as I intend:

My issue is 2 fold;

  1. The first is that I’m getting an error from the Etsy “Create a Listing” module. I am getting a “Missing value for required parameter ‘description’” error even though I have it mapped:
    image

  2. If I have more than one paragraph block, it seems like I can only access the last one. To solve this I’ve tried an iterator, array aggregator, and a text iterator but I wasn’t able to get them to work.

Below is the output from “List page contents”. I can SEE the data but I just can’t seem to figure out how to actually work with it.

[
    {
        "object": "block",
        "id": "0e55a52a-63b6-4b2e-8286-4c48b33fb924",
        "parent": {
            "type": "page_id",
            "page_id": "058ed617-9a6b-4af6-a677-b68c19f12f40"
        },
        "created_time": "2024-03-07T01:57:00.000Z",
        "last_edited_time": "2024-03-07T01:57:00.000Z",
        "created_by": {
            "object": "user",
            "id": "ad4c2c3a-e372-4d37-81c8-5f193b4d6540"
        },
        "last_edited_by": {
            "object": "user",
            "id": "ad4c2c3a-e372-4d37-81c8-5f193b4d6540"
        },
        "has_children": false,
        "archived": false,
        "type": "heading_3",
        "heading_3": {
            "rich_text": [
                {
                    "type": "text",
                    "text": {
                        "content": "Magical Brewster Cauldron Mug | Holds up to 350ml",
                        "link": null
                    },
                    "annotations": {
                        "bold": false,
                        "italic": false,
                        "strikethrough": false,
                        "underline": false,
                        "code": false,
                        "color": "default"
                    },
                    "plain_text": "Magical Brewster Cauldron Mug | Holds up to 350ml",
                    "href": null
                }
            ],
            "is_toggleable": false,
            "color": "default"
        },
        "__IMTLENGTH__": 2,
        "__IMTINDEX__": 1
    },
    {
        "object": "block",
        "id": "d93098e7-bb37-479c-9b03-8f3946c8dec0",
        "parent": {
            "type": "page_id",
            "page_id": "058ed617-9a6b-4af6-a677-b68c19f12f40"
        },
        "created_time": "2024-03-07T01:57:00.000Z",
        "last_edited_time": "2024-03-07T03:40:00.000Z",
        "created_by": {
            "object": "user",
            "id": "ad4c2c3a-e372-4d37-81c8-5f193b4d6540"
        },
        "last_edited_by": {
            "object": "user",
            "id": "090b34af-d3ea-4b88-9cfb-f1d5fb14d080"
        },
        "has_children": false,
        "archived": false,
        "type": "paragraph",
        "paragraph": {
            "rich_text": [
                {
                    "type": "text",
                    "text": {
                        "content": "Brew your morning potion in style with this enchanting cauldron mug! Its exterior shimmers like a night sky with sparkling black, and a magical cascade of blue, green, and yellow glaze drips from the rim, casting an entrancing spell. The interior boasts a bewitching yellow-green, ensuring every sip is steeped in mystery and delight.\n\nCapacity: 350ml\nWidth: 10cm\nWidth including handle: 13cm\nHeight: 10cm\nWeight: 400g",
                        "link": null
                    },
                    "annotations": {
                        "bold": false,
                        "italic": false,
                        "strikethrough": false,
                        "underline": false,
                        "code": false,
                        "color": "default"
                    },
                    "plain_text": "Brew your morning potion in style with this enchanting cauldron mug! Its exterior shimmers like a night sky with sparkling black, and a magical cascade of blue, green, and yellow glaze drips from the rim, casting an entrancing spell. The interior boasts a bewitching yellow-green, ensuring every sip is steeped in mystery and delight.\n\nCapacity: 350ml\nWidth: 10cm\nWidth including handle: 13cm\nHeight: 10cm\nWeight: 400g",
                    "href": null
                }
            ],
            "color": "default"
        },
        "__IMTLENGTH__": 2,
        "__IMTINDEX__": 2
    }
]

Yeah I don’t work with notion just because of this. Every single thing is a separate block, including formatting.

It is a pita to insert, and then later when you want to extract/export. Try not to get locked into their ecosystem when you could be using something more suitable like Google Docs or Sheets.