Hi,
I have a couple of type forms filled with user data. The output is constantly updated on Google sheets as soon as someone fill the form. Fine, but I want to use Typeform module instead of the Google sheet module on Make.
So what I would like to do exactly is to start by listing the responses from the Typeform module, and then for each column filled with the data of all the users, get insights from ChatGPT.
How can I connect the dots?
Do I need to use an iterator? An array aggregator?
Simply linking the Typeform module to a ChatGPT module does not seem to work.
I thought about pasting each insight, divided per column (question/topic), onto a Google Doc and then ask ChatGPT to look into the doc to extract insights, but I think there could be a faster an easier way.
Thanks for helping.
Well well well, I have actually tried to use a Google Sheets instead of a connection with Typeform. I have also introduced array aggregator and iterator.
Still, I cannot make it work.
Two issues:
- First, I can only retrieve one column at a time; specifically, I am retrieving a column filled with information about the role of the users; there are many columns, but I thought to start with just one; then if I want more, should I enable them in the array aggregator, or use a router and creator for each column an aggregator?
- Secondly, despite using the aggregator and iterator, it seems that ChatGPT can only find one answer, instead of two, meaning just one role (I limited to the first two rows for simplicity).
See attached. How can I solve this? Meanint, how can I analyze each column, and for each column all the data inside each row?
