I am trying to recreate a scenario I have on Make, but I’ve reached a roadblock.
The scenario is triggered each time a new row is added to a Google spreadsheet and sends an email using a pre-se email address.
For example, if column A says John, send an email to [email protected], if it is Tony, send the email to [email protected] and so on.
Column A allows the selection among 40+ people, each having a unique email address.
In Make i can create a local variable (only for that scenario) using the node Tools → Set Multiple Variables, which allows me to name the variable and to assign multiple options using the switch case:
The scenario in N8N is relatively short, but i am afraid that without a node allowing me to store multiple variables, i have to use multiple Switch and If constructs, eventually becoming very long:
Could you share your workflow? It would be interesting to see what your Gsheet data looks like.
Tip for sharing your workflow in the forum
Pasting your n8n workflow
Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.
```
<your workflow>
```
Make sure that you’ve removed any sensitive information from your workflow and include dummy data or pinned data as much as you can!
From what I understood, there are a few ways you can do in n8n that might be able to achieve the same result as what you have in make:
You can use the Edit Fields node to set a variable and use conditionals in expressions if you only have a few cases to switch between:
You can also use the Code node to map user name to email like so:
