Google sheet : can't convert google form response into text in sheet

[ROMAIN_Charles]

Hi,

I’m a beginner in Make…

I’m trying to get google form responses to put them in a google sheet. In my case, I have 3 differents google form from different campaign, that’s why I want to put them in common in a google sheet.

So I try to get every new reponse in one google form with this :

After, I put all the datas in the good fields :

But I have an error with sheet when I run the scenario with the following statement :

I precise that all the responses in the form are well parameters with text response :

What can I do ? Should I convert the response into text before putting them in sheets ?

Thanks

[Lauren_Moineau]

Hi
Your error says you’re trying to map a Collection (Name, Surname, etc.) to a text field.
So, for each collection, you want to look inside and find the text item to match the Google sheet field, which is value here:

Hope that helps

[ROMAIN_Charles]

Thank you, it works