Before
Security teams had to distribute awareness questionnaires manually, collect responses through separate channels, and grade each answer individually. They also had to update a spreadsheet with participant results and issue certificates through separate administrative steps.
How it works
- The webhook identifies the participant and sends a personalized Slack notification with a button to start the questionnaire.
- Questions are delivered one at a time, responses are checked against the correct answers, and each result is written to a central spreadsheet.
- The completed score is evaluated against the passing condition, after which the participant receives a Slack outcome and successful participants receive an emailed certificate.
Workflow details
- Initiation and identity: A secure webhook receives the participant information and questionnaire content, then looks up the participant by email so the questionnaire can be delivered directly to their Slack account. The participant receives a personalized notification that the questionnaire is ready, with a Start button to begin.
- Question delivery: The workflow processes each question individually and presents the available response options in Slack. It waits for the participant's selection before continuing to the next question.
- Answer validation and logging: Each selected answer is compared with the configured correct answer. The Slack message is updated with a success or failure indicator, and every question, response, correct answer, and result is appended to a central spreadsheet together with the participant's email address.
- Final evaluation: After the questions are completed, the workflow reads the participant's recorded responses, calculates the number and percentage of correct answers, and applies the configured passing condition of at least 12 correct answers. The participant-facing message describes the passing threshold as 80% of good answers.
- Completion and recognition: Participants who pass receive their score in Slack and an HTML cybersecurity awareness certificate by email, including their name, date, result, badge, and unique certification ID. Participants who do not pass receive their score in Slack along with a message explaining that a specific training module will be provided to help them improve.
What changed
The complete questionnaire cycle now runs from a single trigger: participant identification, question delivery, answer validation, spreadsheet logging, score calculation, Slack notification, and certificate delivery happen automatically. Human administrators no longer need to coordinate the quiz or manually decide which successful participants should receive certificates.
Work removed
Manually sending questionnaire invitations and questions, collecting and grading individual responses, updating result spreadsheets, calculating scores, notifying participants, and issuing certificates.
Expected outcome
An estimated 10–20 minutes of administrative work can be removed per participant session, with consistent scoring, centralized response records, and automatic certificate delivery for participants who pass.
