Copy data from a chatgpt module to a google sheet via the add a row function

[Youenn_Siviniant]

What are you trying to achieve?

Hi everyone,

I’m starting as a new user and need your help I wanted to extract data and rework them with chatgpt then copy the reworked data to a google sheet via the add a row function. The problem is that the output data from chatgpt are in bundles, if i copy them directly to google sheets then i don’t get the data but “collection”. Ive been on the forum and i believe i need to use an agregator or a text agregator ? I’ve been trying to mess around with these two for two days now but can’t really get this to work…Please help

Screenshots: scenario setup, module configuration, errors

[samliew]

Welcome to the Make community!

You’ll need to select the sub-variables (properties of the collection) to map instead of the top-level collection variable.

If you cannot select it, you can always manually type it in using the raw name of the variable, e.g.:

{{ 64.Nom_Prenom.Nom }}
{{ 64.Nom_Prenom.prenom }}
{{ 64.Nom_Prenom.civilite }}
{{ 64.Email.email }}

etc.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.