How to route emails to different Gmail accounts based on department using Router?

:bullseye: What is your goal?

Hi Makers,

I have a scenario set up like this:

Webhook β†’ Google Sheets β†’ Router β†’ 3 Gmail modules

Each Gmail module should send an email to a different department (Housing, Food, Senior Services) based on a department or call_intent field coming from the webhook.

My questions:

What is the best way to configure the Router filters so only ONE Gmail module triggers per call?

Should I use separate Gmail connections for each department?

Or is it better practice to use ONE Gmail module and dynamically map the β€œTo” field based on department?

I want to make sure the routing is clean and that emails only go to the correct department.

Thank you!

:thinking: What is the problem & what have you tried?

I am trying to route incoming webhook data to different Gmail modules based on a department or call_intent field.

My scenario:

Webhook β†’ Google Sheets β†’ Router β†’ 3 Gmail modules (Housing, Food, Senior Services)

The issue is:

β€’ I want to make sure only ONE Gmail module triggers per call
β€’ I am unsure if I should use separate Gmail connections or one Gmail module with a dynamic β€œTo” field
β€’ I am not fully confident my Router filters are set up correctly

Right now I am using Router filters with conditions like:

department = Housing
department = Food
department = Senior Services

But I am not sure if I should be using β€œcontains” instead of β€œequals,” or combining filters with OR conditions for better reliability.

I have not received an error, but I want to confirm best practice before deploying this live.

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Hey there,

Is it the same email but only the recipient being different? If that is the case, then I would just use a switch() function in the field to get the correct one and not bother with router and different modules.

1 Like

Hi,

Thank you β€” that makes perfect sense.

Yes, it’s the same email content and only the recipient changes based on department. Using the switch() function in the β€œTo” field is a much cleaner solution than using a Router with multiple Gmail modules.

I appreciate the guidance. I’ll simplify the scenario and implement it that way.

Thanks again for the help!