LOW / CODEBlueprints
hr

Anonymous Feedback Survey Pipeline

Collect anonymous employee feedback via Typeform, log responses in Google Sheets for trend analysis, and notify HR in Slack when new feedback arrives — all without revealing who submitted it.

Beginner~15 minn8nMake.com 355 downloads 1226 views

Setup Instructions

1. Create a Typeform with anonymous settings enabled (no email collection, no tracking). Include fields: Department (dropdown), Rating (1-5 scale), Category (select: Culture, Management, Workload, Growth, Other), and Open Feedback (long text). 2. Create a Google Sheet with columns: Response ID, Timestamp, Department, Rating, Category, Feedback Text, and Sentiment. 3. In n8n/Make, add a Typeform trigger that fires on new responses. 4. Add a Set/Transform node to strip any accidentally included PII (names, emails) from the open feedback text using a regex replacement. 5. Add a Google Sheets node to append the sanitized response with a generated Response ID and timestamp. 6. Add a filter/condition node: if Rating is 1 or 2, route to an urgent Slack alert sent to the HR channel with the department, category, and feedback text. 7. For ratings 3-5, let them accumulate. Optionally set up a separate scheduled workflow that sends a weekly digest summary to Slack with average ratings and category breakdowns.
Troubleshooting
**Typeform responses not anonymous:** Double-check that "Collect email addresses" is OFF in Typeform settings. Also ensure your form does not include a Name or Email field. The Typeform response metadata may still include a respondent token — do not log it. **PII slipping through:** The regex sanitization is a best-effort approach. Common patterns to strip: email addresses (\S+@\S+), phone numbers, and @-mentions. For stricter compliance, consider adding a manual review step. **Slack alerts too frequent:** If you receive many low-rating responses, add a throttle node that batches alerts into 15-minute windows instead of sending one per response. **Google Sheets hitting row limits:** Google Sheets supports 10 million cells. For high-volume feedback, archive older responses quarterly to a separate sheet or export to a database.

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.