Missing Values While Processing Google Forms Data

[Jonas2]

Problem with Processing Google Forms Data in Make (Integromat)

Background:

I created a survey in Google Forms that exclusively uses a Likert scale (0-4). The responses should be processed automatically using Make. I am encountering issues with directly processing the data from Google Forms. I want to send those forms results to my OpenAI Assistant for further modification.

Issues:

1. Questions as Question IDs:
   In Make, the questions appear as Question IDs instead of text. This complicates mapping the responses.

2. Data Processing in Make:

• Although the data (e.g., email address) are visible in the output of the Google Forms module, they are not correctly transferred to the Email module.
• When trying to map e.g. the email address in the Email module, the value is not correctly recognized or processed.

The strange thing is that it worked perfectly in a previous version of the project until I changed the form. Since then, nothing works anymore.

Here you can see: The data is there! Values of 3 & 4 in this example.

Now, i want to get this to OpenAI (including a few prompt words):

Now, trying to run the OpenAI Module, this one asks me for the values.

I already tried to use Sheets and watch for a new row instead if this. but i had the same issue there. I created a new scenario an a ne form. nothing changed.
The “QuestonIDs”-issue is not that bad, i coukd handle this, but the missing values are a mess

PS: This is a project-part for my masters thesis. please help me

[Henk-Operative]

Hi @Jonas2,

You are executing the module by ‘Run this module only’. That means that only the module itself is run, but there is no input taken from previous modules. Therefore, you will need to provide an input for the mappings that you made manually.

Cheers,
Henk

[Jonas2]

Wow thank you! I fell kinda stupid but I’m glad this works now