How to Route NPS Surveys to Notion with Pipedream

Pipedream > New > Start with a trigger

Create New Pipedream Workflow

Navigate to pipedream.com and click the purple 'New' button in the top navigation. Select 'Start with a trigger' from the dropdown. You'll land on the trigger selection page where you can search for apps or browse categories.

1. 1Click 'New' in the top navigation bar
2. 2Select 'Start with a trigger' from the dropdown
3. 3Type 'Typeform' in the app search box
4. 4Click the Typeform tile when it appears

Workflows > Typeform > New Response

Configure Typeform New Response Trigger

Select 'New Response' as your trigger type. This fires instantly when someone submits your survey. You'll need to connect your Typeform account by clicking 'Connect Account' and completing the OAuth flow in the popup window.

1. 1Click 'New Response' from the trigger list
2. 2Click 'Connect Account' button
3. 3Complete OAuth login in the popup window
4. 4Click 'Allow' to grant Pipedream access

Trigger Configuration > Form Selection

Select Your NPS Survey Form

Choose the specific Typeform containing your NPS question from the dropdown. Pipedream will load all forms from your account. If you have many forms, use the search box to find your NPS survey quickly.

1. 1Click the 'Form' dropdown menu
2. 2Search for your NPS survey by name
3. 3Select the correct form from the list
4. 4Click 'Continue' to save the trigger

Trigger > Generate Test Event

Test the Typeform Trigger

Click 'Generate Test Event' to pull a recent response from your form. If no recent responses exist, submit a test response to your Typeform first. This test data will be used to configure the rest of your workflow steps.

1. 1Click 'Generate Test Event' button
2. 2Wait for Pipedream to fetch recent data
3. 3Review the response structure in the preview panel
4. 4Click 'Continue' to move to the next step

Workflow > Add Step > Code > Node.js

Add Code Step for NPS Classification

Click the '+' button below your trigger to add a new step. Search for 'Code' and select 'Run Node.js Code'. This step will analyze the NPS score and assign the appropriate category tag (Promoter, Passive, or Detractor) based on standard NPS methodology.

1. 1Click the '+' button below the trigger
2. 2Type 'code' in the step search box
3. 3Select 'Run Node.js Code'
4. 4Name the step 'Classify NPS Score'

This Node.js code analyzes NPS scores and adds follow-up flags for detractors. Paste it into your classification code step, replacing the default async function.

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

export default defineComponent({
  async run({ steps, $ }) {
    const response = steps.trigger.event;
    const answers = response.form_response.answers;
    
    // Find the NPS score field
    const npsAnswer = answers.find(answer => 
      answer.field.title.toLowerCase().includes('recommend')
    );
    
    if (!npsAnswer || !npsAnswer.number) {
      throw new Error('NPS score not found in response');
    }
    
    const score = npsAnswer.number;
    let category, followUpRequired;
    
    if (score >= 9) {
      category = 'Promoter';
      followUpRequired = false;
    } else if (score >= 7) {
      category = 'Passive'; 
      followUpRequired = false;
    } else {
      category = 'Detractor';
      followUpRequired = true;
    }
    
    return {
      score: score,
      category: category,
      follow_up_required: followUpRequired,
      response_id: response.form_response.token,
      submitted_at: response.form_response.submitted_at
    };
  }
});

Code Step > Editor

Configure NPS Classification Logic

Replace the default code with NPS classification logic. The code will read the score from your Typeform response and return the appropriate category. Standard NPS methodology classifies 0-6 as Detractors, 7-8 as Passives, and 9-10 as Promoters.

1. 1Clear the existing code in the editor
2. 2Paste the NPS classification code from the pro tip
3. 3Update the field reference to match your form's score field
4. 4Click 'Test' to verify the logic works

Workflow > Add Step > Notion > Create Page in Database

Add Notion Database Step

Click '+' again to add another step. Search for 'Notion' and select 'Create Page in Database'. This action will create new rows in your feedback database. You'll need to connect your Notion account and grant access to the specific database.

1. 1Click the '+' button below the code step
2. 2Search for 'Notion' in the apps list
3. 3Select 'Create Page in Database'
4. 4Click 'Connect Account' for Notion

Notion Step > Database Selection

Select Target Notion Database

Choose your feedback tracking database from the dropdown. Only databases you granted access to during OAuth will appear here. If you don't see your database, disconnect and reconnect your Notion account with broader permissions.

1. 1Click the 'Database' dropdown
2. 2Select your customer feedback database
3. 3Wait for Pipedream to load the database schema
4. 4Verify the correct properties appear below

Notion Step > Property Mapping

Map Typeform Fields to Notion Properties

Configure each Notion database property using data from your Typeform response and code step. Map the customer email, NPS score, comments, and the calculated category tag. Use the variable picker to reference data from previous steps.

1. 1Click in the 'Customer Email' field
2. 2Select the email field from Typeform data
3. 3Map NPS Score to the score property
4. 4Set Category to the classification from your code step
5. 5Map any comment fields to rich text properties

Workflow > Test

Test Complete Workflow

Click 'Test' at the bottom of the Notion step to run the entire workflow with your test data. This will create an actual row in your Notion database using the sample Typeform response. Check your database to verify the row was created correctly.

1. 1Click the 'Test' button on the Notion step
2. 2Wait for the test to complete
3. 3Check the success/error status in Pipedream
4. 4Navigate to your Notion database to verify the new row

Workflow > Deploy

Deploy Workflow

Click 'Deploy' in the top right to activate your workflow. Once deployed, every new Typeform response will automatically create a Notion row within 30 seconds. The workflow will continue running until you pause or delete it.

1. 1Click the 'Deploy' button in the top navigation
2. 2Confirm deployment in the modal dialog
3. 3Wait for the green 'Active' status indicator
4. 4Submit a test response to your Typeform to verify