How to Route NPS Survey Responses from Typeform to Notion with N8n

Notion Workspace > + New > Database

Create Notion Database Structure

Set up your Notion database with proper fields for NPS data. You need columns for response text, score, customer info, and automated tags.

1. 1Open Notion and click '+ New page' then select 'Database - Full page'
2. 2Create text property 'Customer Name' and email property 'Email'
3. 3Add number property 'NPS Score' with number format
4. 4Create select property 'Category' with options: Promoter, Passive, Detractor
5. 5Add text property 'Comments' for open-ended feedback
6. 6Create checkbox property 'Follow-up Required'

notion.so/my-integrations

Get Notion Integration Token

N8n needs an internal integration token to write to your Notion database. This is different from the public API and requires specific permissions.

1. 1Go to notion.so/my-integrations in your browser
2. 2Click '+ New integration' button
3. 3Name it 'N8n NPS Integration' and select your workspace
4. 4Copy the Internal Integration Token that appears
5. 5Go back to your database page and click 'Share' in top right
6. 6Click 'Invite' and search for your integration name to grant access

Typeform > Connect > Webhooks

Configure Typeform Webhook

Set up Typeform to send NPS responses directly to N8n when submitted. This creates real-time data flow instead of polling.

1. 1Open your Typeform and go to the Connect panel
2. 2Click 'Webhooks' in the integrations list
3. 3Click 'Add webhook' button
4. 4Enter your N8n webhook URL (you'll get this in the next step)
5. 5Select 'Complete responses' as the trigger event
6. 6Click 'Save webhook'

N8n > New Workflow > + Node > Webhook

Create N8n Webhook Trigger

Start your N8n workflow with a webhook that receives Typeform submissions. This node listens for incoming HTTP requests from Typeform.

1. 1Create new workflow in N8n dashboard
2. 2Click the '+' to add first node and select 'Webhook'
3. 3Set HTTP Method to 'POST'
4. 4Leave Path field blank for default webhook URL
5. 5Click 'Listen for Test Event'
6. 6Copy the webhook URL that appears

Typeform Preview > Submit > N8n Webhook Node

Test Data Capture

Submit a test NPS response through your Typeform to capture the actual data structure N8n will receive. This ensures proper field mapping.

1. 1Go back to your Typeform preview and submit a test response
2. 2Include a numeric NPS score (0-10) and some comment text
3. 3Return to N8n webhook node and check for incoming data
4. 4Click 'Use Workflow' once you see the test data appear
5. 5Expand the data tree to see field names like 'answers' and 'form_response'

+ Node > Code > Run Once for All Items

Add NPS Score Extraction

Extract the numeric NPS score from Typeform's nested response data and categorize it. Typeform wraps answers in arrays that need proper parsing.

1. 1Add Code node after the webhook
2. 2Set Mode to 'Run Once for All Items'
3. 3Paste code to extract NPS score from items[0].json.form_response.answers
4. 4Add logic to categorize: 9-10 = Promoter, 7-8 = Passive, 0-6 = Detractor
5. 5Return structured object with score, category, and other response fields

+ Node > Notion > Database > Create

Configure Notion Node

Add the Notion node to write categorized NPS data to your database. This requires the database ID and proper field mapping.

1. 1Add 'Notion' node after the Code node
2. 2Select 'Database' resource and 'Create' operation
3. 3Paste your Notion integration token in credentials
4. 4Enter your database ID (found in the database URL)
5. 5Map Code node outputs to Notion fields
6. 6Set 'NPS Score' field to {{$json.nps_score}}
7. 7Set 'Category' field to {{$json.category}}

+ Node > IF > Condition

Add Conditional Follow-up Logic

Create branching logic to assign follow-up tasks based on NPS category. Detractors need immediate attention while Promoters get different treatment.

1. 1Add 'IF' node after Notion node
2. 2Set condition: {{$json.category}} equals 'Detractor'
3. 3Connect 'true' output to another Notion node for task creation
4. 4Set this second Notion node to your tasks database
5. 5Map detractor info to create urgent follow-up task
6. 6Connect 'false' output to merge node for other categories

Workflow Settings > Error Handling

Set Up Error Handling

Add error handling to catch failed Notion writes or API timeouts. Without this, one bad response breaks the entire workflow.

1. 1Click workflow settings (gear icon)
2. 2Enable 'Continue on Failure' for Notion nodes
3. 3Add 'HTTP Request' node for error notifications
4. 4Set it to POST to a Slack webhook or email service
5. 5Configure error message with failed response details
6. 6Connect all error outputs to this notification node

Typeform > Submit > N8n Execution Log > Notion Database

Test Complete Workflow

Run end-to-end test with a real NPS response to verify all data flows correctly. Check that scores categorize properly and follow-up tasks generate.

1. 1Submit new test response through your live Typeform
2. 2Watch each node execute in N8n workflow panel
3. 3Verify new row appears in Notion NPS database with correct category
4. 4Check if Detractor responses create tasks in your tasks database
5. 5Review any error messages in node output panels
6. 6Test with different NPS scores (2, 7, 10) to verify all categories

Workflow > Toggle Active > Settings

Activate Workflow

Enable the workflow for production use and set up monitoring. Once active, it will process all incoming NPS responses automatically.

1. 1Click the workflow toggle to 'Active' state
2. 2Set execution log retention to 7 days minimum
3. 3Add workflow to a folder for organization
4. 4Test webhook URL is still responding with curl or Postman
5. 5Document the webhook URL for your team
6. 6Set up monitoring alerts for failed executions

Drop this into an n8n Code node.

// Enhanced NPS categorization with custom thresholds
const score = parseInt(items[0].json.form_response.answers.find(a => a.field.ref === 'nps_score').number);
const email = items[0].json.form_response.answers.find(a => a.field.type === 'email')?.email || '';

// Enhanced NPS categorization with custom thresholds
const score = parseInt(items[0].json.form_response.answers.find(a => a.field.ref === 'nps_score').number);
const email = items[0].json.form_response.answers.find(a => a.field.type === 'email')?.email || '';

// Custom scoring for enterprise customers
const isEnterprise = email.includes('@enterprise-domain.com');
const promoterThreshold = isEnterprise ? 8 : 9; // Lower bar for enterprise

let category;
if (score >= promoterThreshold) category = 'Promoter';
else if (score >= 7) category = 'Passive';
else category = 'Detractor';

return [{
  nps_score: score,
  category: category,
  priority: (category === 'Detractor' && isEnterprise) ? 'Urgent' : 'Normal',
  email: email
}];