Route Feedback by Sentiment Using Typeform, GCP Natural Language, Notion & Trello

Feedback Sentiment Workflow (Typeform → GCP → Notion/Slack/Trello)

This template ingests feedback from Typeform, runs Google Cloud Natural Language sentiment analysis, routes based on sentiment, and then creates a Notion database page and posts a Slack notification for positive items, or creates a Trello card for negative items.
The flow is designed for quick setup and safe sharing using placeholders for IDs and credentials.

How it Works

Typeform Trigger
Captures each new submission and exposes answers like Name and the long-text Feedback field.

Google Cloud Natural Language
Analyzes the feedback text and returns a sentiment score in:
documentSentiment.score

Check Sentiment Score (IF)
True branch: Score > 0 → Positive
False branch: Score ≤ 0 → Non-positive

Add Feedback to Notion (True branch)
Creates a new page in a Notion database with mapped properties.

Notify Slack (after Notion)
Posts the feedback, author, and score to a Slack channel for visibility.

Create Trello Card (False branch)
Logs non-positive items to a Trello list for follow-up.

Required Accounts

Google Cloud Natural Language API** enabled (OAuth2 or service credentials).
Notion integration** with database access to create pages.
Slack app/bot token** with permission to post to the target channel.
Typeform account** with a form including:
Long Text feedback question
Name field

Notion Database Columns

Name (title):** Person name or responder label
Feedback (rich_text):** Full feedback text
Sentiment Score (number):** Numeric score from GCP ∈ [-1, 1]
Source (select/text):** "Typeform" for provenance
Submitted At (date):** Timestamp from the trigger

Customization Options

Sentiment Threshold:** Adjust IF condition (e.g., ≥ 0.25) for stricter positivity.
Slack Routing:** Change channel, add blocks/attachments for richer summaries.
Trello Path:** Point to a triage list and include labels for priority.
Field Mapping:** Update the expression for feedback question to match Typeform label.
Database Schema:** Add tags, product area, or customer tier for reporting.

Setup Steps

Connect credentials: Typeform, GCP Natural Language, Notion, Slack, Trello.
Replace placeholders in workflow JSON:
Form ID
Database ID
Slack Channel
Trello List ID
Map fields: Set Feedback + Name expressions from Typeform Trigger output into Notion and Slack.
Adjust IF threshold for your definition of "positive".
Test with a sample response and confirm:
Notion page creation
Slack notification
Trello card logging