Create Page from Database with Notion API

Pipedream makes it easy to connect APIs for Notion and 2,400+ other apps remarkably fast.

Trigger workflow on

HTTP requests, schedules and app events

Next, do this

Create Page from Database with the Notion API

No credit card required

Overview#

The Notion Create Page from Database action allows you to add pages to a Notion Database.

This action features easy to use dropdowns that automatically populate your databases as well as your database's properties, also known as columns.

This action interacts with the Notion create a Page API endpoint. The Database selected in the Parent Database ID is used as the parent_id parameter to that endpoint so the page is added to your databaset .

Getting Started#

Follow this short 4 minute guide to connect your Notion account and add new Database pages

Props

When using the Create Page from Database action, there are several props to define:

Notion Account - see the Accounts section below.
Parent Database ID - the database to add a page to.
Meta Types - an icon or cover to add to the new page (optional).
Property Types - one or more properties to add to the new page that correspond with columns in the database.
Page Content - the content of the page that appears when it's opened in a side view.

Each selected Property Type will also add a new prop for that given column.

Accounts

Visit https://pipedream.com/accounts.
Click on the Click Here To Connect An App button in the top-right.
Search for "Notion" among the list of apps, and select it.
This will open a new window asking you to allow Pipedream access to your Notion workspaces and pages. Choose which workspaces and pages you'd like to use in Pipedream, then click Allow.
That's it! You can now use this Notion account in any actions, or link it to any code step.

Within a workflow

Create a new workflow.
Select your trigger (HTTP, Cron, etc.).
Click on the + button below the trigger step, and search for "Notion".
Select the Create Page from Database action.
Click the Connect Account button near the top of the step. This will prompt you to select any existing Notion accounts you've previously authenticated with Pipedream, or you can select a New account. Clicking New opens a new window asking you to allow Pipedream access to your Notion workspaces and pages. Choose the workspaces and pages where you'd like to install the app, then click Allow.
That's it! You can now connect to the Notion API using any of the Slack actions within a Pipedream workflow.

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Integrations#

Create Page from Database with Notion API on Exchange Rate Updated from CurrencyScoop API

CurrencyScoop + Notion

Try it

Create Page from Database with Notion API on New Board Event from Pinterest API

Pinterest + Notion

Try it

Create Page from Database with Notion API on New Email from Email API

Email + Notion

Try it

Create Page from Database with Notion API on New File Created from OpenAI (ChatGPT) API

OpenAI (ChatGPT) + Notion

Try it

Create Page from Database with Notion API on New Message In Channels from Slack API

Slack + Notion

Try it

Details#

This is a pre-built, source-available component from Pipedream's GitHub repo. The component is developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Create Page from Database on Notion

Description:Creates a page from a database. [See the docs](https://developers.notion.com/reference/post-page)

Version:0.1.14

Key:notion-create-page-from-database

View on GitHub

Code#

import notion from "../../notion.app.mjs";
import base from "../common/base-page-builder.mjs";
import pick from "lodash-es/pick.js";

export default {
  ...base,
  key: "notion-create-page-from-database",
  name: "Create Page from Database",
  description: "Creates a page from a database. [See the docs](https://developers.notion.com/reference/post-page)",
  version: "0.1.14",
  type: "action",
  props: {
    notion,
    parent: {
      propDefinition: [
        notion,
        "databaseId",
      ],
      label: "Parent Database ID",
      description: "The identifier for a Notion parent page",
      reloadProps: true,
    },
    metaTypes: {
      propDefinition: [
        notion,
        "metaTypes",
      ],
    },
    propertyTypes: {
      propDefinition: [
        notion,
        "propertyTypes",
        (c) => ({
          parentId: c.parent,
          parentType: "database",
        }),
      ],
      reloadProps: true,
    },
    alert: {
      type: "alert",
      alertType: "info",
      content: "This action will create an empty page by default. To add content, use the `pageContent` prop below.",
    },
    pageContent: {
      type: "string",
      label: "Page Content",
      description: "Content of the page. You can use Markdown syntax [See docs](https://www.notion.so/help/writing-and-editing-basics#markdown-&-shortcuts)",
      optional: true,
    },
  },
  async additionalProps() {
    const { properties } = await this.notion.retrieveDatabase(this.parent);
    const selectedProperties = pick(properties, this.propertyTypes);
    return this.buildAdditionalProps({
      properties: selectedProperties,
      meta: this.metaTypes,
    });
  },
  methods: {
    ...base.methods,
    /**
     * Builds a page from a parent database
     * @param parentDatabase - the parent database
     * @returns the constructed page in Notion format
     */
    buildPage(parentDatabase) {
      const meta = this.buildDatabaseMeta(parentDatabase);
      const properties = this.buildPageProperties(parentDatabase.properties);
      const children = this.createBlocks(this.pageContent);
      return {
        ...meta,
        properties,
        children,
      };
    },
  },
  async run({ $ }) {
    const MAX_BLOCKS = 100;
    const parentPage = await this.notion.retrieveDatabase(this.parent);
    const {
      children, ...page
    } = this.buildPage(parentPage);
    const response = await this.notion.createPage({
      ...page,
      children: children.slice(0, MAX_BLOCKS),
    });
    let remainingBlocks = children.slice(MAX_BLOCKS);
    while (remainingBlocks.length > 0) {
      await this.notion.appendBlock(response.id, remainingBlocks.slice(0, MAX_BLOCKS));
      remainingBlocks = remainingBlocks.slice(MAX_BLOCKS);
    }
    $.export("$summary", "Created page successfully");
    return response;
  },
};

Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Notion	`notion`	`app`	This component uses the Notion app.
Parent Database ID	`parent`	`string`	Select a value from the drop down menu.
Meta Types	`metaTypes`	`string[]`	Select a value from the drop down menu:`iconcover`
Property Types	`propertyTypes`	`string[]`	Select a value from the drop down menu.
Page Content	`pageContent`	`string`	Content of the page. You can use Markdown syntax See docs

Troubleshooting#

If your database doesn't appear under the options, try deleting your Notion account connection and reconnecting.

There's an issue with Notion Databases not appearing in the options if the Database was created after you connected your Notion account to Pipedream.

Authentication#

Notion uses OAuth authentication. When you connect your Notion account, Pipedream will open a popup window where you can sign into Notion and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Notion API.

Pipedream requests the following authorization scopes when you connect your account: