Skip to content
Nappai Documentation

Notion Database Query

This component lets you pull specific information from your Notion database into your Nappai automation workflows. Think of it as a way to easily access and use your Notion data without leaving the Nappai dashboard.

Relationship with Notion API

This component connects directly to your Notion database using the Notion API. You’ll need to provide Nappai with the necessary credentials to access your data securely. This ensures that your data remains private and only accessible through Nappai.

Inputs

  • Database ID: This is a unique identifier for your Notion database. You can find this ID in the Notion workspace URL of your database. It looks something like abcdef1234567890.
  • Database query (JSON): This is an optional field. Here you can use a special code (JSON) to filter and sort the data from your Notion database. For example, you can specify that you only want pages created after a certain date, or sorted alphabetically by a specific property. If you leave this blank, the component will return all pages from the specified database.
  • Credential: This is where you’ll select the pre-configured Notion API credentials you’ve set up within Nappai. This ensures secure access to your Notion data.

Outputs

The component produces a list of items, each representing a page from your Notion database. Each item includes details like the page’s ID, URL, creation date, last updated date, and the values of its properties. You can then use this information in other parts of your Nappai workflow. For example, you could use this data to automatically update a spreadsheet, send an email, or trigger another action based on the information retrieved from Notion.

Usage Example

Let’s say you have a Notion database tracking project tasks. You can use this component to:

  1. Input the Database ID: Enter the ID of your “Project Tasks” Notion database.
  2. (Optional) Input the Database query (JSON): You might add a JSON query to only retrieve tasks marked as “Incomplete” and order them by due date.
  3. Select Credential: Choose the appropriate Notion API credential you’ve set up in Nappai.
  4. Run the component: Nappai will fetch the relevant tasks from Notion.
  5. Use the output: The output (a list of tasks) can be used by other Nappai components to, for example, send email reminders about overdue tasks.

Templates

[List of templates where the component is used will be added here once available.]

  • [Link to OpenAI Function Agent]: This component can process the data retrieved from Notion to generate summaries or other text-based outputs.
  • [Link to other relevant components]: [Add links to other components that logically follow this one in a workflow, e.g., components that process or display the Notion data.]

Tips and Best Practices

  • Test your JSON query: Before using a complex JSON query, test it separately in your Notion database to ensure it returns the expected results.
  • Use clear and descriptive names: When configuring this component, use clear and descriptive names for your inputs and outputs to improve workflow readability.
  • Error Handling: Review the output carefully. If there’s an error, the component will provide a message to help you troubleshoot.

Security Considerations

  • Protect your Notion API credentials: Never share your Notion API credentials with anyone. Nappai uses secure methods to store and manage these credentials.
  • Review Notion API permissions: Ensure that your Notion integration only has the necessary permissions to access the data required by your Nappai workflow. Avoid granting unnecessary permissions.