Hello Make.com Community,
We are currently facing a challenge that we are hoping some of you may have experience with or advice on how to solve. Our aim is to automate the creation of individual reports for each respondent who completes one of our surveys on SurveyMonkey. The report should be generated immediately upon the survey’s completion.
What We Are Trying to Achieve:
Trigger on New Survey Completion: Automatically detect when a new survey is completed in SurveyMonkey.
Fetch Individual Response: Retrieve specific response data for the newly completed survey.
Flatten and Process Data: Process this response data into a flattened format that can be easily read and analyzed.
Generate Report: Populate this data into a pre-defined report template.
Distribute the Report: Automatically send this individualized report via email to the respondent or upload it to a specified location for further action.
Finding an efficient way to flatten and process SurveyMonkey’s deeply nested JSON responses (Maybe using Survey Monkey’s API?).
Being able to map the flattened data in a scenario
Dynamically generating a report that pulls in this processed data.
Has anyone successfully automated a similar process?
Are there any specific tools or scripts you would recommend?
How do you handle the data flattening part efficiently?
We would appreciate any insights, advice, or pointers you can provide. If you have examples or templates to share, that would be fantastic!
Thank you for taking the time to read our post. Looking forward to your responses!
The SEL Japan Team