Google Forms to Slack with Priority Routing

Who it's for

Support teams, agencies, and small businesses that use Google Forms for intake, contact requests, or lead capture and need smarter Slack alerts — not just a flat notification for every row.

What it does

This workflow watches the Google Sheet linked to your form for new responses, scores each submission using keyword rules and optional urgency fields, checks an audit log to prevent duplicate alerts, routes messages to different Slack channels by priority, and logs every processed submission.

Urgent requests go to an escalation channel. High-intent leads (pricing, demo, enterprise) go to a sales channel. Standard submissions go to your default alerts channel. Spam or test submissions are logged without flooding Slack.

How it works

1. Google Sheets Form Trigger polls the form response sheet for new rows
2. Configure Form Alert Settings sets sheet IDs, Slack channels, keyword lists, and field names
3. Extract and Score Form Response parses answers, calculates a priority score, and builds the Slack message
4. Read Alert Audit Log loads previously processed submissions from an Alert Log tab
5. Check for Duplicate Submission compares row number and submitter details to prevent repeat alerts
6. Is New Submission continues only for new rows with usable data
7. Route by Priority Level branches to urgent, high, standard, or log-only paths
8. Send Slack Alert posts to the channel chosen for that priority level
9. Log Submission Alert to Sheets appends priority metadata to the audit log

Setup steps

1. Import the workflow JSON into n8n
2. In Google Forms, link responses to a Google Sheet (default tab: Form Responses 1)
3. Create a second tab named Alert Log with columns: Processed At, Row Number, Submitter Email, Priority Score, Route, Slack Sent, Form Title, Summary
4. Open Google Sheets Form Trigger and set your spreadsheet ID and response sheet name
5. Open Configure Form Alert Settings and set GOOGLE_SHEET_ID, Slack channel names, and keyword lists
6. Connect Google Sheets OAuth2 on the trigger, Read Alert Audit Log, and Log Submission Alert to Sheets
7. Connect Slack OAuth2 on Send Slack Alert
8. Submit test responses (urgent, sales, and standard) to verify routing, then activate the workflow

Requirements (optional form fields — add one line each)

n8n Cloud or self-hosted n8n instance Google account with OAuth2 credentials configured in n8n Slack workspace with OAuth2 credentials configured in n8n A Google Form linked to a Google Sheet with an Alert Log tab

Customization (optional form fields — add one line each)

Edit URGENT_KEYWORDS, HIGH_KEYWORDS, and SPAM_KEYWORDS in Configure Form Alert Settings Change Slack channel names for urgent, sales, and standard routes Map your form's urgency and email column names via PRIORITY_FIELD_NAMES and EMAIL_FIELD_NAMES Adjust scoring thresholds in Extract and Score Form Response Add more Switch outputs in Route by Priority Level for custom routing rules

Additional info (optional — paste as one block)

Google Forms does not trigger n8n directly. This workflow uses the linked response spreadsheet, which is the standard and most reliable approach. Unlike a basic form-to-Slack notifier, it adds priority scoring, multi-channel routing, duplicate protection, and an audit log so teams can triage intake faster without alert fatigue.

Ideas to extend

• Add an OpenAI node to classify free-text answers before routing
• Send a Gmail auto-reply to the submitter for urgent requests
• Post a daily rollup of form volume by priority to Slack
• Sync high-intent leads into a CRM after the Slack alert