How to Send Notion Database Alerts to Slack with Pipedream

pipedream.com > Workflows > New Workflow

Create a new Pipedream Workflow

Go to pipedream.com and sign in. Click 'New Workflow' in the top-right corner of the dashboard. You'll land on a blank canvas with a trigger slot at the top. Give the workflow a name like 'Notion DB → Slack Alerts' in the name field at the top — this keeps your list readable when you have dozens of workflows.

1. 1Click 'New Workflow' in the top-right of the Pipedream dashboard
2. 2Click the workflow name field at the top and type 'Notion DB → Slack Alerts'
3. 3Click 'Save' or press Enter to confirm the name

Workflow Canvas > Add Trigger > Notion > New or Updated Database Item

Add the Notion trigger

Click 'Add Trigger' in the trigger slot. Search for 'Notion' in the app search box. Select the 'New or Updated Database Item' trigger from the list — this is the correct trigger for catching both new rows and edits to existing ones. Pipedream will poll Notion on a schedule you set in the next step.

1. 1Click the 'Add Trigger' slot at the top of the workflow canvas
2. 2Type 'Notion' in the search box
3. 3Click 'Notion' in the app results
4. 4Select 'New or Updated Database Item' from the trigger list

Trigger Panel > Account > Connect Account > Notion OAuth

Connect your Notion account

In the trigger configuration panel, click 'Connect Account' under the Notion account field. A popup opens asking you to authorize Pipedream to access Notion. Notion's OAuth flow will ask you to select which pages or databases to share — you must explicitly grant access to the specific database you want to monitor. Do not skip the database selection step or the trigger will have nothing to poll.

1. 1Click 'Connect Account' in the Notion trigger panel
2. 2Click 'Connect Notion Account' in the popup
3. 3In the Notion OAuth screen, click 'Select Pages'
4. 4Check the box next to the specific database you want to monitor
5. 5Click 'Allow Access'

Trigger Panel > Database > [Select DB] > Timer > Polling Interval

Select your Notion database and set polling interval

In the 'Database' dropdown, select the Notion database you want to monitor. Then scroll down to the timer/polling settings. Set the polling interval — Pipedream defaults to 15 minutes. For active sprint boards, 5 minutes is a reasonable balance between responsiveness and credit usage. For lower-urgency content databases, 15 minutes is fine.

1. 1Click the 'Database' dropdown and select your target Notion database
2. 2Scroll to the 'Timer' or 'Polling Interval' section in the trigger panel
3. 3Set the interval to '5 minutes' or your preferred frequency
4. 4Click 'Save and Continue'

Workflow Canvas > Trigger Step > Output > JSON Preview

Inspect the Notion event payload

After generating a test event, click the trigger step in the workflow to expand its output. You'll see the raw JSON Notion returns for a database row. Notion wraps field values in type objects — for example, a text field appears as properties.Task.title[0].plain_text, not just properties.Task. Take 2 minutes to locate the exact paths for the fields you want in your Slack message: task name, status, assignee, and URL. You'll reference these paths in the code step.

1. 1Click the trigger step in the workflow canvas to expand its output
2. 2Click the 'Results' or 'Output' tab in the right panel
3. 3Expand the 'properties' object to find your database fields
4. 4Note the full path to each field you want: e.g., steps.trigger.event.properties.Status.select.name

Workflow Canvas > + > Run Node.js Code

Add a Node.js code step to build the Slack payload

Click the '+' button below the trigger step and choose 'Run Node.js code'. This is where you extract the relevant fields from the Notion event and format them into a clean Slack Block Kit message. Write the extraction logic here rather than relying on Pipedream's built-in field picker — Notion's nested property structure makes manual field wiring error-prone. Paste the code from the pro tip section below into this step.

1. 1Click the '+' button below the trigger step
2. 2Click 'Run Node.js code' from the step type list
3. 3Paste your message-building code into the code editor
4. 4Click 'Test' to run the step against the test event

This code goes in the Node.js code step (Step 6). It extracts Notion fields safely using optional chaining, formats the due date, and builds a Slack Block Kit payload so your message has bold headers, labeled fields, and a clickable Notion link instead of a wall of plain text.

// Pipedream Node.js code step
// Place this in the 'Run Node.js code' step between your Notion trigger and Slack step
export default defineComponent({

// Pipedream Node.js code step
// Place this in the 'Run Node.js code' step between your Notion trigger and Slack step

export default defineComponent({
  async run({ steps, $ }) {
    const page = steps.trigger.event;
    const props = page.properties;

    // Extract fields safely — Notion's nested structure breaks without optional chaining
    const taskName = props?.Name?.title?.[0]?.plain_text ?? 'Untitled Task';
    const status = props?.Status?.select?.name ?? 'No Status';
    const assignee = props?.Assignee?.people?.[0]?.name ?? 'Unassigned';
    const priority = props?.Priority?.select?.name ?? 'None';
    const notionUrl = page.url;
    const lastEdited = page.last_edited_time;

    // Format due date from ISO string to readable label
    let dueLabel = 'Not set';
    const rawDue = props?.Due?.date?.start;
    if (rawDue) {
      const due = new Date(rawDue);
      dueLabel = due.toLocaleDateString('en-US', { month: 'short', day: 'numeric' });
    }

    // Format last edited time
    const editedAt = new Date(lastEdited).toLocaleString('en-US', {
      month: 'short', day: 'numeric', hour: '2-digit', minute: '2-digit'
    });

    // Pick an emoji based on status
    const statusEmoji = {
      'Blocked': '🔴',
      'In Progress': '🟡',
      'Done': '✅',
      'In Review': '🔵',
    }[status] ?? '⚪';

    // Build Slack Block Kit payload
    const blocks = [
      {
        type: 'header',
        text: {
          type: 'plain_text',
          text: `${statusEmoji} ${taskName}`,
          emoji: true
        }
      },
      {
        type: 'section',
        fields: [
          { type: 'mrkdwn', text: `*Status:*\n${status}` },
          { type: 'mrkdwn', text: `*Assignee:*\n${assignee}` },
          { type: 'mrkdwn', text: `*Priority:*\n${priority}` },
          { type: 'mrkdwn', text: `*Due:*\n${dueLabel}` }
        ]
      },
      {
        type: 'section',
        text: {
          type: 'mrkdwn',
          text: `<${notionUrl}|Open in Notion>  •  Updated ${editedAt}`
        }
      },
      { type: 'divider' }
    ];

    // Return the payload — reference this in the Slack step as steps.nodejs.$return_value
    return {
      text: `${statusEmoji} *${taskName}* is now ${status} — assigned to ${assignee}`,
      blocks
    };
  }
});

Workflow Canvas > + > Slack > Send Message to a Channel > Connect Account

Connect your Slack account

Click the '+' button below the code step and search for 'Slack'. Select the 'Send Message to a Channel' action. Click 'Connect Account' and go through Slack's OAuth flow. You'll be asked to choose a Slack workspace and approve the bot permissions. Pipedream's Slack app needs chat:write and chat:write.public scopes to post to channels it hasn't been invited to.

1. 1Click '+' below the code step
2. 2Search for 'Slack' and click it
3. 3Select 'Send Message to a Channel'
4. 4Click 'Connect Account' and authorize Pipedream in your Slack workspace
5. 5Confirm the workspace and click 'Allow'

Slack Step Panel > Channel > Message Text > Blocks

Configure the Slack message fields

In the Slack step configuration, set the Channel field to your target channel (e.g., #project-updates). For the Message Text field, reference the output from your Node.js code step using the expression {{steps.nodejs.$return_value.text}}. For the Blocks field (which enables rich formatting), reference {{steps.nodejs.$return_value.blocks}}. If you skip the Blocks field, Slack will display only plain text — no bold, no links, no emojis.

1. 1Click the 'Channel' field and type or select your target Slack channel
2. 2Click the 'Message Text' field and enter {{steps.nodejs.$return_value.text}}
3. 3Scroll to the 'Blocks' field and enter {{steps.nodejs.$return_value.blocks}}
4. 4Leave other fields at their defaults unless you need username or icon overrides

Workflow Canvas > Test Workflow > Check Each Step Output

Test the full workflow end to end

Click 'Test Workflow' at the top of the canvas. Pipedream will run all steps sequentially using the test event you captured earlier. Watch for green checkmarks on each step. Then open your Slack channel and confirm the message arrived with the correct content: task name, status, assignee name, and the Notion page URL as a clickable link. If the message looks right, you're ready to deploy.

1. 1Click 'Test Workflow' at the top of the workflow canvas
2. 2Watch each step for a green checkmark or red error indicator
3. 3Open your target Slack channel and verify the notification message
4. 4Check that the Notion page link opens the correct record

Workflow Canvas > Deploy (top right)

Deploy the workflow

Click the 'Deploy' button in the top-right of the workflow canvas. Pipedream activates the polling schedule immediately. The workflow will now check your Notion database at your configured interval and fire the Slack step for any new or changed rows it hasn't seen before. Pipedream tracks seen records internally using the page ID — you don't need to build deduplication logic yourself.

1. 1Click the 'Deploy' button in the top-right corner
2. 2Confirm the deployment in the dialog that appears
3. 3Click 'View Workflow' to see the live run history panel

Workflow > Runs Tab | Settings > Notifications

Monitor runs and set up error alerts

Go to the workflow's 'Runs' tab in the left sidebar. Each poll that produces an event shows as a successful run with step-by-step logs. Runs where Notion returns no new rows are not logged as errors — they simply produce no events. To get notified if something breaks, go to Settings > Notifications and enable 'Email on workflow error'. This fires an email if any step throws an uncaught exception.

1. 1Click the 'Runs' tab in the left sidebar of your workflow
2. 2Review recent run logs to confirm step outputs look correct
3. 3Click 'Settings' in the left sidebar
4. 4Toggle on 'Email me when this workflow throws an error'