Get multiple variable only gets one value after the Route

[Brice_Brice]

What are you trying to achieve?

Hi everyone, New make.com user, I’d like to get a little help please, here’s

1. What I want to do

2. The issue

3. The scenario

4. I set up a scenario to automatically analyse search terms from my google ads campaign, qualify them, and then tell me if they’re relevant or not by writing them down in a google sheet. I feel like I’m reaching the end but..

5. My module Get Multiple Variable only gets the variable from one Output while I want it to collect them all. Therefore when it reaches the final step (the update of the Google Sheetà, it only ads one line.

6. My scenario :

Watch for New Files (Module ID: 27): Monitors a specific folder in Google Drive for any new files added.

Routing Logic (Module ID: 30): Directs the flow based on conditions set in the subsequent modules.

Filter Rows (Module ID: 3): Filters rows from a specified Google Sheets document, specifically excluding rows that contain the term “Papernext”.

Evaluate Relevance (Module ID: 7): Sends a prompt to OpenAI’s GPT-3 to assess the relevance of search terms based on provided criteria.

Format Output (Module ID: 10): Requests GPT-3 to format the output into a structured table with columns for search terms, ad groups, campaigns, and relevance scores.

Transform Text to Structured Data (Module ID: 9): Extracts structured data from the GPT-3 response, organizing it into specific fields.

Aggregate Data (Module ID: 43): Collects the structured data into a single output.

Set Variables (Module ID: 34): Prepares the aggregated data for further processing by setting variables.

Create Spreadsheet (Module ID: 11): Creates a new Google Sheets document to store the keyword analysis report.

Set Spreadsheet Variables (Module ID: 37): Sets variables for the newly created spreadsheet ID and title for later use.

Retrieve Variables (Module ID: 36): Retrieves previously set variables for search terms, ad groups, campaigns, keywords, notes, spreadsheet ID, and sheet title.

Aggregate Retrieved Variables (Module ID: 47): Prepares the retrieved variables for insertion into the spreadsheet.

Add Row to Spreadsheet (Module ID: 29): Adds a new row to the Google Sheets document with the aggregated keyword analysis data.

Screenshots: scenario setup, module configuration, errors

[samliew]

Welcome to the Make community!

We’d love to help, however, you have not provided sufficient information to demonstrate the problem that would allow us to reproduce the scenario and any issue/s and/or error/s.

To allow others to assist you with your scenario, please provide the following:

1. All Relevant Screenshots

We need to see what you’re working with to give you the best advice. Screenshots are extremely important because Make is a visual editor — a picture provides us with more context.

It would help us identify the issue by having screenshots of:

• individual module fields,
• relevant filter settings (conditions), and
• each module’s output bundles
• any external services (spreadsheet headers, sample data, regex101.com, etc.)

2. Scenario Blueprint

Please export the scenario blueprint. Providing your scenario blueprint file will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return - this would greatly benefit you in implementing our suggestions as you can simply paste module exports back into your scenario editor!

To export your scenario blueprint, click the three dots at the bottom of the editor then choose ‘Export Blueprint’.

3. Module Output Bundles

Please provide the output bundles of your trigger modules by running the scenario (you can also get this without re-running your scenario from the History tab).

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

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.

To provide code/text using Markdown format, you can type a code fence.
Add three backticks ``` in a separate line before and after the content, like this,

```
text goes here
```

Alternatively, you can upload your file and share the public link** —
(this method is only recommended for large files exceeding the forum upload limit)

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved, and help you with mapping the raw property names from collections.

Sharing these details will make it easier for others to assist you.