Automating Individual Respondent Reports with SurveyMonkey Data

Hello 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!

Best regards,
The SEL Japan Team

How does the JSON look like; could you share an example?

How do you want to map it? Can you give it a try and then get back to us if you get stuck?

How do you want the report to be generated, in what format, and with which preferred services? Can you provide an example template you want to use?

When you have a scenario, do share the blueprint here so we can provide suggestions on how you can further optimise the flow.

If the external service has a Developer API Reference/Documentation, then yes, you should be able to integrate the endpoints in Make using the generic HTTP “Make a request” module.

You can also suggest for it to be made in the Idea exchange. Don’t forget to search for it first, in case someone already suggested it!