Lead scoring variables calculated in Tools are not appearing in Google Sheets and Telegram outputs

Questions
, , , , ,
1

:bullseye: What is your goal?

I want to build a lead qualification (lead scoring) scenario in Make where scores are calculated in Tools modules and then correctly written as plain text into Google Sheets and sent as readable text in a Telegram message.

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

I have redesigned my scenario and now it contains multiple Routers and many Tools – Set variable modules used to calculate lead scoring values (budget, urgency, company type).

Scenario structure (simplified):
Google Forms – Watch responses
→ Router (Budget logic)
→ multiple Tools – Set variable
→ Router (Urgency logic)
→ multiple Tools – Set variable
→ Router (Company logic)
→ multiple Tools – Set variable
→ Tools – Set multiple variables (scoreTotal, categoria)
→ Router (Lead calda / tiepida / fredda)
→ Google Sheets – Add a row
→ Telegram – Send a message

Each router branch sets partial score variables (e.g. scoreBudget, scoreUrgenza, scoreAzienda).
At the end, a Tools – Set multiple variables module calculates:

  • scoreTotal (sum of the partial scores)
  • categoria (HOT / WARM / COLD)

Problem:
The final score variables (scoreBudget, scoreUrgenza, scoreAzienda, scoreTotal, categoria) are NOT appearing in Google Sheets and Telegram.
The columns in Google Sheets remain empty and the Telegram message shows labels but no values.

The scenario runs without errors.

I suspect this is related to variable scope across Routers or to variables being set in different branches.
What is the correct and reliable way to calculate lead scoring across multiple routers and then persist the final values so they can be used in Google Sheets and Telegram?

:link: Create public scenario page

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

Screenshot 2026-01-31 203440.png
Screenshot 2026-01-31 203440.png1743×616 92.9 KB

1 Like
3

Hey there,

you can’t directly map items from other routes. In your case you need a Get Multiple variables to retrieve them.

But do you though? All of those routers and filters can be written as formulas directly inside the google sheets module.

1 Like
4

Welcome to the Make community!

Alternatively, you could avoid using routers and just chain as many Set Multiple Variables modules as you need together. Routers are usually used when you have more than one bundle to process, e.g. from an iterated array or search module. Right now you are processing individual form submissions from the trigger module.

If you need further assistance,

Please provide the output bundles of the trigger module by getting the bundle from a previous run from the Scenario “History” tab.

Providing the bundles from a scenario run will allow others to replicate what is going on, especially if there are complex data structures (nested arrays and collections) and external services. This helps mapping the correct raw variable names from collections (instead of the label/display name).

Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.

A. Upload a Text File

Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.

  • You can upload files and images to this forum by clicking on the upload button:

    Uploading an attachment here will look like this:
    module1-input.txt (1.2 KB), module1-output.txt (3.4 KB)

B. Insert a Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly.

:warning: Formatting IS Important! :warning:

Here are some ways to provide text content in a way that it won’t be modified by the forum.

  • Method 1: Type code fence manually —
    Manually type three backticks ``` in a separate line before and after the content, like this,

    ```
text goes here
```

  • Method 2: Highlight the pasted content, then click the preformatted text/code button —

  • Method 3: Upload your file elsewhere and share the public link —
    This method is only advised for large files exceeding the forum upload limit.

This will allow others to better assist you. Thanks!

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!