What is your goal?
I want to build an automated market analysis tool for competitors. It should conduct research once a week according to predefined criteria, then compile the information into a clear analysis and send it to my email inbox.
My idea was to build it as shown in the pictures:
With the help of five separate module branches, I want to ensure that the AI does not interpret, mix topics, and research cleanly according to each defined category. This results in the branch: Make AI Web Search → Iterator → Google Sheets. Each category is entered in the same Google Sheet document, but in different tabs (see screenshot).
Once all categories have been successfully researched, the content in the various tabs is summarized using ChatGPT. Here, too, I have already formulated a detailed prompt that provides me with the desired summary in the appropriate form. The Gmail module then sends me the summary by email.
What is the problem & what have you tried?
So what is going wrong now?
In step 2, the summary for ChatGPT, something is going wrong or my structure is definitely wrong. ChatGPT informs me that my Google Sheet is not linked and that it cannot provide me with any output without data (which is logical). So I am doing something wrong in the way I am trying to summarize the 5 tabs as a Google Sheet module at the bottom to collect the data. I had already tried to create an array agg after all 5 sheets. Also without success.
Now to my question:
How can I collect data from 5 Google Sheet modules (one file, but 5 different tabs) and pass it on to ChatGPT so that it can create my summary?
And now for question 2: Is this structure completely overpowered and pointless, and is there a much better, more efficient solution to achieve my goal?
Thank you very much for your help. Today is my first day on Make, but I am very motivated to see what the tool can do. Best regards!
Screenshots (scenario flow, module settings, errors)
