Notion – Database record

Estimated reading time: 4 min

What your automation will do…

A connection to your Notion account is needed so we can sync it with our platform.
Refer to Notion – create a connection.

You can include between 1 and 255 Methods to build complex Flows.

Create Database Record Copy Link

This Method is used to create a database record (database row).

● In Notion, every database row is actually a page inside the database.

See Notion Create a page API reference.

Configuration Table:

Input Options:

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: You can specify a fixed attribute.

Name*	Create Database Record
Connection*	Select your connection or create one.

MAP FIELDS

Database ID*:

Select the database in which you want to create a record (row).

Fields*:

Available fields from the database properties, to fill in and create a new record (row).

(*) required field

Delete Database Record Copy Link

This Method is used to create a database record (database row).

● In Notion, every database row is actually a page inside the database.

See Notion Create a page API reference.

Configuration Table:

Input Options:

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: You can specify a fixed attribute.

Name*	Delete Database Record
Connection*	Select your connection or create one.

MAP FIELDS

Database ID*:

Select the database in which you want to delete a record (row).

Database Record ID*:

Select the record to delete (Row Title).

(*) required field

Response sample

Find Database Record Copy Link

This Method is used to find a database record. Additional conditions can be set if not found.
See Notion Query a database API reference.

Configuration Table:

Input Options:

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: You can specify a fixed attribute.

Name*	Find Database Record
Connection*	Select your connection or create one.

MAP FIELDS + Add Field
Select additional fields to configure the “Find Database Record” Method.

if not Found Consider as::

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the workflow.

Failed – Wiresk treats this as an error or failure. The workflow stops or takes a predefined failure action.

Parent Database ID*:

Select the parent database that contain the database record.

Database Name*:

Enter the database name (row title).

(*) required field

Response sample

{
  "object": "database",
  "id": "1c341eaa-28f8-81e5-9872-e108325da9bb",
  "cover": null,
  "icon": {
    "type": "emoji",
    "emoji": "☑️"
  },
  "created_time": "2025-03-27T07:57:00.000Z",
  "created_by": {
    "object": "user",
    "id": "f889d775-ecb7-4b23-81e9-ebdbcef2e915"
  },
  "last_edited_by": {
    "object": "user",
    "id": "f889d775-ecb7-4b23-81e9-ebdbcef2e915"
  },
  "last_edited_time": "2025-04-02T08:08:00.000Z",
  "title": [
    {
      "type": "text",
      "text": {
        "content": "new database final",
        "link": null
      },
      "annotations": {
        "bold": false,
        "italic": false,
        "strikethrough": false,
        "underline": false,
        "code": false,
        "color": "default"
      },
      "plain_text": "new database final",
      "href": null
    }
  ],
  "description": [
    {
      "type": "text",
      "text": {
        "content": "testing database creation",
        "link": null
      },
      "annotations": {
        "bold": false,
        "italic": false,
        "strikethrough": false,
        "underline": false,
        "code": false,
        "color": "default"
      },
      "plain_text": "testing database creation",
      "href": null
    }
  ],
  "is_inline": false,
  "properties": {
    "choice list": {
      "id": "%3DLrM",
      "name": "choice list",
      "type": "select",
      "select": {
        "options": [
          {
            "id": "981c97bb-0074-4e30-b39a-284c4ac053ad",
            "name": "option select1",
            "color": "brown",
            "description": null
          },
          {
            "id": "1e8d390b-c074-4a89-ab79-3ef92935ce8c",
            "name": "option select2",
            "color": "yellow",
            "description": null
          }
        ]
      }
    },
    "email": {
      "id": "FJCy",
      "name": "email",
      "type": "email",
      "email": []
    },
    "contacted": {
      "id": "M%3C%7D%5C",
      "name": "contacted",
      "type": "checkbox",
      "checkbox": []
    },
    "url": {
      "id": "OE%3BH",
      "name": "url",
      "type": "url",
      "url": []
    },
    "owner": {
      "id": "Qqwf",
      "name": "owner",
      "type": "people",
      "people": []
    },
    "description 2": {
      "id": "T%3Ad%3C",
      "name": "description 2",
      "type": "rich_text",
      "rich_text": []
    },
    "date": {
      "id": "WINq",
      "name": "date",
      "type": "date",
      "date": []
    },
    "Phone": {
      "id": "_C%7Dc",
      "name": "Phone",
      "type": "phone_number",
      "phone_number": []
    },
    "number": {
      "id": "albt",
      "name": "number",
      "type": "number",
      "number": {
        "format": "number"
      }
    },
    "choices": {
      "id": "d%3Bs%7C",
      "name": "choices",
      "type": "multi_select",
      "multi_select": {
        "options": [
          {
            "id": "1d31fc76-71e6-4552-acae-20c42d7f91bb",
            "name": "test1",
            "color": "blue",
            "description": null
          },
          {
            "id": "ada00402-fea3-49b1-9fc5-fa70bb436181",
            "name": "test2",
            "color": "orange",
            "description": null
          }
        ]
      }
    },
    "description": {
      "id": "dLEp",
      "name": "description",
      "type": "rich_text",
      "rich_text": []
    },
    "files": {
      "id": "%7CHh%3F",
      "name": "files",
      "type": "files",
      "files": []
    },
    "Wiresk clients": {
      "id": "title",
      "name": "Wiresk clients",
      "type": "title",
      "title": []
    }
  },
  "parent": {
    "type": "page_id",
    "page_id": "1c141eaa-28f8-8106-8dfb-ca8e8503c793"
  },
  "url": "https://www.notion.so/1c341eaa28f881e59872e108325da9bb",
  "public_url": null,
  "archived": false,
  "in_trash": false,
  "request_id": "be600f85-2032-4d7b-90d9-460fcb282065"
}

Expand

Get a Database Record Copy Link

This Method is used to retrieve information about a database record. Additional conditions can be set if not found.
See Notion Query a database API reference.

Configuration Table:

Input Options:

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: You can specify a fixed attribute.

Name*	Get a Database Record
Connection*	Select your connection or create one.

MAP FIELDS + Add Field
Select additional fields to configure the “Find Database Record” Method.

if not Found Consider as::

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the workflow.

Failed – Wiresk treats this as an error or failure. The workflow stops or takes a predefined failure action.

Parent Database ID*:

Select the parent database that contain the database record.

Database record ID*:

Select the database record (row title) or enter it ID.

(*) required field

Response sample

{
  "object": "page",
  "id": "17341eaa-28f8-810f-8391-ea4d80e95cc0",
  "created_time": "2025-01-06T02:12:00.000Z",
  "last_edited_time": "2025-04-02T02:42:00.000Z",
  "created_by": {
    "object": "user",
    "id": "4981eebd-51b9-4af6-9e28-9b11d6ab6a7e"
  },
  "last_edited_by": {
    "object": "user",
    "id": "f889d775-ecb7-4b23-81e9-ebdbcef2e915"
  },
  "cover": null,
  "icon": null,
  "parent": {
    "type": "database_id",
    "database_id": "17341eaa-28f8-8084-9cdc-cd2b5f71a2ac"
  },
  "archived": false,
  "in_trash": false,
  "properties": {
    "Customer Type": {
      "id": "_jtV",
      "type": "rich_text",
      "rich_text": [
        {
          "type": "text",
          "text": {
            "content": "Regular",
            "link": null
          },
          "annotations": {
            "bold": false,
            "italic": false,
            "strikethrough": false,
            "underline": false,
            "code": false,
            "color": "default"
          },
          "plain_text": "Regular",
          "href": null
        }
      ]
    },
    "Phone Number": {
      "id": "c%3AMF",
      "type": "rich_text",
      "rich_text": [
        {
          "type": "text",
          "text": {
            "content": "987-654-3210",
            "link": null
          },
          "annotations": {
            "bold": false,
            "italic": false,
            "strikethrough": false,
            "underline": false,
            "code": false,
            "color": "default"
          },
          "plain_text": "987-654-3210",
          "href": null
        }
      ]
    },
    "Email": {
      "id": "d~s%7D",
      "type": "email",
      "email": "bob@example.com"
    },
    "Notes": {
      "id": "j%60Ud",
      "type": "rich_text",
      "rich_text": [
        {
          "type": "text",
          "text": {
            "content": "Requested a follow-up call",
            "link": null
          },
          "annotations": {
            "bold": false,
            "italic": false,
            "strikethrough": false,
            "underline": false,
            "code": false,
            "color": "default"
          },
          "plain_text": "Requested a follow-up call",
          "href": null
        }
      ]
    },
    "Last Interaction": {
      "id": "y%5Dx%5B",
      "type": "date",
      "date": {
        "start": "2023-12-25",
        "end": null,
        "time_zone": null
      }
    },
    "Customer Name": {
      "id": "title",
      "type": "title",
      "title": [
        {
          "type": "text",
          "text": {
            "content": "Bob Smith",
            "link": null
          },
          "annotations": {
            "bold": false,
            "italic": false,
            "strikethrough": false,
            "underline": false,
            "code": false,
            "color": "default"
          },
          "plain_text": "Bob Smith",
          "href": null
        }
      ]
    }
  },
  "url": "https://www.notion.so/Bob-Smith-17341eaa28f8810f8391ea4d80e95cc0",
  "public_url": null,
  "request_id": "7e5eb0fc-fe2c-4925-a0cf-da21e0ddeb91"
}

Expand

Update Database record Copy Link

This Method is used to update the row of a database record.
See Notion Update page properties API reference.

Configuration Table:

Input Options:

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: You can specify a fixed attribute.

Name*	Update Database record
Connection*	Select your connection or create one.

MAP FIELDS

Database ID*:

Select the Database that contain the properties to rename.

Database record ID*:

Select the database record (row Title of a database) or enter it ID.

Fields:

Set of available fields for updating the record.

(*) required field

Test run or automate your Flow Copy Link

After setting up your Flow, you can choose to:

“Run once”, your Flow will run only a single time. You can use this function to test your Flow. Refer to how to set up an HTTP Trigger, in the “Create a Flow” step.
“Run Scheduler” will automate your Flows with the recurrence rule you previously defined.

For more details, refer to How to run a Flow tutorial in our Help Center.

If you are using a Webhook Trigger, the Flow will initiate automatically when a webhook is received from your connected apps. This means that the Flow is automated without a scheduler and will run until you deactivate the Flow manually. Refer to Webhook documentation in our Help Center.

Learn more about Wiresk, explore our user guide.

Let us know if you need an integration that’s not in Wiresk, and we’ll work hard to add it for you.