Marketing Assessment Dashboard
Hey there all. I'm running into a couple of things that drive me nuts in Make.com. Maybe someone here can help me along. I am trying to get a form response using GetFormly. They do not have a webhook option, only a Google Sheet connection. So I am getting my first trigger from a new row from Google sheets. It pulls in all the answers to the questions in the form. Next, I am bringing those answers into a ChatGPT module and asking it to give me a couple of scores. *Since the form asks about five questions per Category (and I have seven categories for things like General Marketing, Video Marketing, Branding, etc.). I want Chat GPT to score the results in percentages, and write small explanations and add the results back into another sheet. But this is where I am having trouble - I can't separate the categories and after watching many tutorials on JSON and aggregators and iterators I have almost given up. The end results will be pulled into a Looker Studio Dashboard and then turned into a PDF that I send by mail. (Hopefully, this will work, but first, this part needs to be done right.) Does anyone know what I can do to get this to work?