Notion Advanced

Full-featured Notion node with exhaustive block and formatting support using existing credentials

Actions16

Overview

The node provides advanced integration with Notion, a popular productivity and note-taking platform. Specifically, for the Database - Get operation, it retrieves detailed information about a specific Notion database by its ID.

This operation is useful when you want to fetch metadata or schema details of a Notion database, such as its properties, title, and configuration. For example, you might use this to dynamically understand the structure of a database before querying or updating its contents in an automated workflow.

Practical examples:

  • Fetching a database schema to generate dynamic forms.
  • Retrieving database details to display in dashboards.
  • Validating database existence and structure before performing queries or updates.

Properties

Name Meaning
Database ID The unique identifier of the Notion database to retrieve.
Additional Fields (Not applicable for this operation)

Output

The output JSON contains the full response from the Notion API for the requested database. This includes:

  • object: The type of object returned (should be "database").
  • id: The database's unique ID.
  • created_time, last_edited_time: Timestamps for creation and last modification.
  • title: The database title as rich text.
  • properties: An object describing each property (column) in the database, including types and configurations.
  • Other metadata fields as provided by the Notion API.

The output does not include binary data.

Example output snippet (simplified):

{
  "object": "database",
  "id": "some-database-id",
  "created_time": "2023-01-01T00:00:00.000Z",
  "last_edited_time": "2023-01-02T00:00:00.000Z",
  "title": [
    {
      "type": "text",
      "text": {
        "content": "My Database"
      }
    }
  ],
  "properties": {
    "Name": {
      "id": "title",
      "type": "title",
      "title": {}
    },
    "Status": {
      "id": "status",
      "type": "select",
      "select": {
        "options": [
          { "name": "To Do", "color": "red" },
          { "name": "Done", "color": "green" }
        ]
      }
    }
  }
}

Dependencies

  • Requires valid Notion API credentials configured in n8n.
  • Uses the Notion REST API endpoint /databases/{database_id} with GET method.
  • No additional external dependencies beyond the Notion API.

Troubleshooting

  • Invalid Notion API credentials: The node checks credentials at runtime and will throw an error if they are invalid. Ensure your API key/token is correct and has access to the target database.
  • Invalid or missing Database ID: If the provided database ID is incorrect or inaccessible, the API call will fail. Verify the ID and permissions.
  • API rate limits: Frequent calls may hit Notion API rate limits; consider adding delays or error handling for rate limit responses.
  • Network issues: Connectivity problems can cause request failures; check network status and proxy settings if applicable.

Links and References

Discussion