Marketing Assessment Dashboard · Automate Your Business

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?

4 comments