Aug '24 • ⚙️ Automations
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?
2
4 comments
Marketing Assessment Dashboard
powered by
skool.com/automate-7175
Welcome to the Automate Your Business Community! Our mission is to teach you how to systematize and automate your business for higher profit margins!
Suggested communities
Powered by