Combine multiple notion databases into JSON

How To
, , ,
1

I’m trying to automate a workflow that pulls data from four different Notion databases, combines them grouped by student name, and exports the final result to Google Docs or JSON. The goal is to generate one unified document per student containing their records from all sources.

image
image1105×352 29 KB

What I’ve tried:

  • Called each Notion database, aggregated the necessary data, and grouped it by student name.
  • However, the automation was calling the same users multiple times, which resulted in duplicate entries in the final output.
  • I’m looking for a clean, automated process that can be triggered manually or scheduled to run regularly.

The end result would be JSON with this type of format.

{
  "Student A": {
    "Database 1": [
      "log_day_1",
      "log_day_2",
      "log_day_3",
      "log_day_4"
    ],
    "Database 2": [
      "journal_day_1",
      "journal_day_2",
      "journal_day_3",
      "journal_day_4"
    ],
    "Database3": [
      "task_1",
      "task_2",
      "task_3",
      "task_4"
    ],
    "Database 4": [
      "grade_check_that_week"
    ]
  }
}

Has anyone successfully:

  • Combined multiple Notion databases
  • Aggregated the data into a single structure by string of the students name
  • Exported it into Google Docs or JSON without duplication?

Any advice or architecture that actually would be appreciated!