I am retrieving the page content of a Notion database item using the “List Page Contents” module. Since Notion returns the content as multiple blocks, my goal is to combine all blocks into a single text so I can process the full content with ChatGPT.
Currently, my scenario processes the Notion page content in multiple steps:
1. The “List Page Contents” module retrieves all blocks of a page.
2. Since some Notion text blocks are very long, Notion splits them into multiple rich_text bundles.
3. Using an Iterator, I successfully merge these rich_text bundles into complete paragraphs with a Text Aggregator.
The issue is that I still end up with multiple operations instead of a single combined text output. Even though I merge rich_text fragments into full paragraphs, my scenario continues to execute multiple operations (one per block), and I cannot merge them into a single operation.
What makes this case different from similar questions is that Notion sometimes splits long text blocks into multiple rich_text elements. I have successfully used the Text Aggregator to merge these fragments into full paragraphs, but I still need a way to combine all blocks into a single operation.
What I’ve tried:
• Using Text Aggregator to merge rich_text fragments
• Using Array Aggregator to collect all paragraph texts
• Experimenting with Set Variable to store and update the combined text
• Searching the community, but most solutions do not consider the issue of long Notion text blocks being split into multiple rich_text elements
How can I merge all Notion page blocks into a single text output within one operation?
