Hey @knockoff,
Cool idea! While I’ve never build a workflow exactly like this, I think I have a few recommendations:
Presuming that SurveyMonkey and Qualtrics are not giving you the dashboard / visuals you need to compile the report, I might recommend exploring the analytics, documents & dashboards apps that integrate with Zapier:
Getting the charts auto-added into a report might be the trickiest part of this goal, but it’s possible that one the apps mentioned at those links can handle that in a seamless & automated way.
If you can’t find a tool from there, you can string together a steps to perhaps accomplish the goal with free tools. Though it might be quite challenging to perfect! Here are some recommendations:
For handling the averages, if wanting to avoid using custom code to do so, you can consider doing that in the Zap directly with the Formatter > Number action step. It has a “spreadsheet style function” feature among some other more basic math options that can allow you to do arithmetic in the Zap.
Or you could send the data to a Google Sheet. If needing to do some manipulation of the data in Google Sheets, I would recommend using two sheets: Sheet A that you send the raw data to and don’t edit, and Sheet B that pulls in that raw data so you can use GSheets’ formulas like IMPORTRANGE
and QUERY
for handling the visuals, finding a way to get an automatic chart without any human interference feels like the trickiest part to automate.
The only free tool I can think of would be Google Sheets combined with Google Slides. If you are able to set up the chart manually in Google Sheets, you can then use Google Slides to pull in that chart every time you have new quiz data to chart. There’s a GSlides > Refresh Charts step that will tell your slide to refresh to render the chart based on your updated data (updated quiz submission).
Best of luck, and looking forward to seeing if others have reccs too!