I’m working on an automated workflow in Make.com to process an Emotional Intelligence (EQ) assessment form hosted on GitHub Pages and submitted via a direct webhook. The goal is to:
- Collect responses from a 45-question form across five domains (Know Yourself, Stay Steady, Own It, Connect with Others, Connect & Influence) using a Likert scale (1-5) and scenario-based multiple-choice questions.
- Use a “Set Multiple Variables” module to calculate individual domain scores (each out of 45) by mapping user responses to numeric values, summing them into a Total_Score (out of 225), and computing an overallPercentage.
- Generate tailored feedback for each domain and the overall score based on thresholds (e.g., <30, <45, >=45).
- Send an HTML email via Mailjet with the scores, percentage, and feedback.
The workflow includes a Webhook (Custom Webhook1), a “Set Multiple Variables” module (Calculate EQ Scores), and a Mailjet module (EQ Scoring Mailing). However, I’m running into these issues:
- Scoring Error in Set Multiple Variables:
- The module fails with the error: "Failed to map ‘0.value’: Function ‘map’ finished with error! ‘Strongly Disagree’ is not a valid array.”
- This seems to occur because the map() function isn’t correctly resolving webhook field values (e.g., 1.field_name``) and misinterprets response options like “Strongly Disagree” as the input instead of the mapping key. The syntax in the variable values (e.g., map(1.field_name; “Strongly Disagree”; 1; 2; 2;…)) may be incorrect, possibly due to missing semicolons or improper field references.
- Mailjet Module Reference Error:
- Initially, I got “Module references non-existing module ‘13’” after deleting and recreating the “Set Multiple Variables” module, suggesting Mailjet was still pointing to an old module ID. I updated it to reference module 14 (the new “Set Multiple Variables”), but the workflow fails before reaching Mailjet due to the scoring error.
I’ve tried:
- Rebuilding the “Set Multiple Variables” module with corrected map() syntax using quotes (e.g., map({{1.“field_name”}}; “Strongly Disagree”, 1;…)).
- Manually mapping dynamic pills and rechecking field names against the webhook data.
- Adjusting the Mailjet module to reference the correct module ID.
The latest log (Run ID: 506a48e1b0134f69b7ab9878af9656ae, from July 03, 2025) shows the failure in the “Calculate EQ Scores - Set multiple variables14” module. I’d appreciate guidance on:
- Ensuring the map() function correctly processes webhook responses.
- Confirming the proper syntax for field references and mapping pairs.
- Resolving any lingering module reference issues in Mailjet.
Thanks for any help!