LOW / CODEBlueprints
hrai

AI Employee Feedback Sentiment Analyzer

Collect anonymous employee feedback via Typeform, then let Claude AI analyze sentiment, identify recurring themes, assess urgency levels, and post a structured summary to Slack. All responses and analysis are logged in Google Sheets.

Intermediate~20 minn8nMake.com 308 downloads 639 views

Setup Instructions

1. Get your Claude API key from console.anthropic.com and store it as a credential. 2. Create a Typeform survey with anonymous feedback questions: overall satisfaction (1-5), what's going well (open text), what could improve (open text), and any urgent concerns (open text). 3. Create a Google Sheet with columns: Submission Date, Satisfaction Score, Positive Feedback, Improvement Areas, Urgent Concerns, Sentiment (positive/neutral/negative), Key Themes (comma-separated), Urgency Level (low/medium/high/critical), and AI Summary. 4. Set up a Typeform trigger that fires on each new submission. Map the responses to the raw feedback columns in Google Sheets. 5. Add an HTTP Request node to call the Claude API (POST https://api.anthropic.com/v1/messages) with model "claude-sonnet-4-20250514". Send all three open-text responses and the satisfaction score. Ask Claude to return JSON with: sentiment (positive/neutral/negative), themes (array of strings), urgencyLevel (low/medium/high/critical), summary (2-3 sentences), and actionItems (array of strings). 6. Parse the Claude response and update the same Google Sheets row with the analysis columns. 7. Add a Slack node that posts a formatted summary to your HR or leadership channel. Include the sentiment, key themes, urgency level, and any action items. Do not include identifiable information — keep it anonymous. 8. For batch analysis, add a scheduled trigger (e.g., weekly) that reads all new rows, sends them to Claude as a batch, and posts a weekly trends report to Slack.
Troubleshooting
**Typeform trigger not firing:** Verify the Typeform webhook is configured correctly in both Typeform settings and your automation tool. Test with a manual form submission. Some plans require the webhook add-on. **Claude sentiment analysis seems inaccurate:** Provide Claude with context about your organization's communication style. Some teams use casual language that might read as negative. Add calibration examples in the system prompt showing sample feedback and expected sentiment ratings. **Google Sheets row update overwrites wrong row:** When updating an existing row with analysis, use the Typeform response ID or submission timestamp as a unique key to find the correct row. Avoid relying on row numbers, which shift as new data is added. **Slack report reveals too much identifying info:** Review the Claude prompt to explicitly instruct it to remove any names, teams, or identifying details from the summary. Add a post-processing step that strips email addresses and proper nouns before posting to Slack.

Need a custom version?

We can build a tailored automation workflow for your specific needs.

New blueprints weekly

Get notified when we publish new automation workflows.