Google Forms to Slack with IF-THEN routing

A RouteForms rule reads like a sentence: IF this field, this comparison, this value, THEN send to this channel. The dashboard renders it that way, and the delivery log records it that way too, so anyone on your team can predict what will happen without learning a rules engine.

IF  Budget         greater than or equal  50000     THEN send to  #hot-leads
IF  Property Type  contains               Commercial THEN send to  #commercial-desk
IF  City           equals                 Austin     THEN send to  #austin-team
ELSE (default)                                       send to  #all-enquiries

That's the whole language. Add rows in the dashboard until your routing matches how your team works.

• equals / does not equal — case-insensitive, whitespace-trimmed. Best for dropdowns and multiple-choice questions.
• contains / does not contain — case-insensitive substring. Best for free-text answers and checkbox questions (Google Forms joins checked options with commas, so contains matches any of them).
• greater than / greater than or equal — numeric. Strips ₹, $, , and trailing units like k usd before comparing.
• less than / less than or equal — numeric, same normalisation. Useful for routing low-rating NPS to a follow-up channel.
• is empty / is not empty — no value field. Catches respondents who skipped an optional question (great for file-upload fields).

Each block is one Google Form, with its rules in the order they'd be evaluated.

• No fan-out. Only the first matching rule fires. If you need two channels to see a response, set up two rules pointing at it — but the default is the safer one, since fan-out turns into Slack noise fast.
• No AND / OR inside one IF. Today each IF clause is a single condition. You compose AND by stacking rules and OR by repeating the same THEN. Most teams find this easier to debug than a nested expression.
• No regex. contains is a plain case-insensitive substring match. It covers the common cases without the foot-guns of writing regex against form responses.
• No silent drops.Anything that doesn't match a rule goes to the default Slack channel. If you haven't set one, RouteForms records the submission as Skipped instead of dropping it.

1. 1
   Connect the form and set a default Slack channel

   Paste a default Slack webhook on the Slack tab and install the Apps Script trigger from Extensions → Apps Script. Until you add rules, every submission goes to the default — that's your safety net.
2. 2
   Open the Routing rules tab

   Available on Solo (10 rules per form) and Agency (unlimited). Click Add rule and fill the IF row: field name, operator, value.
3. 3
   Paste the destination Slack webhook (the THEN)

   Each rule has its own destination webhook, so one form can post to channels across multiple Slack workspaces.
4. 4
   Reorder so specific rules come first

   First-match-wins. Put 'Budget ≥ 100000 → #vip' above 'Budget ≥ 50000 → #hot' or the general rule will eat the specific one.
5. 5
   Simulate, then watch the delivery log

   Use the simulator with your latest real submission to confirm the right rule fires. Once live, the Delivery logs tab shows the matched rule and Slack's HTTP response for every post.