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


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 :slight_smile:

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:
Screenshot 2023-10-22 184450
Hope that helps :slight_smile:


Thank you, it works :slight_smile: