Separate data from Notion node (array)

Describe the problem/error/question

I use the n8n in queue mode with the following settings:
1 main
1 postgresql
1 redis
1 rabbitmq
2 workers
Nginx Proxy Manager (reverse proxy)

What is the error message (if any)?

I use Notion to document my infrastructure, with various information.
I want to create a flow that goes through the entire playbook and takes only the text and writes it to a database.
I’m using the Notion node to get some information.
It is returning me a single JSON but with the “blocks” separated.

This is the return of the Notion node.
object list
has_more false
request_id 28abea4c-c391-4bba-be4b-569aa2edd428

Inside each “results” of these “results[0], results[1], results[2], results[3]” is the data that I want to access individually. I want to get the block ID and use it in the next Notion node to extract the text.
I tried using the loop node, but it sends all the “results” instead of one by one.
How do I resolve this?

If I’m going down the wrong path, please let me know.

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.31.2
  • Database (default: SQLite): PostgreSQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main): queue
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: Ubuntu 22.04.4 (Jammy Jellyfish)

hello @sidney27

You need a Split Out node before the Loop node, that will be set to split the results into separate items.

1 Like

That worked. Thanks!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.