Project Description
We need a Make.com automation that receives WhatsApp attendance messages from facilitators,
uses the Claude AI API to parse them, logs the data to Google Sheets, and sends a confirmation reply.# Module What it does
1 Twilio — Watch Messages Trigger: fires when a WhatsApp message is received on the
Client Twilio number.
2 HTTP — Claude API call Sends the raw message text to the Claude API
(claude-haiku-4-5-20251001). Claude parses it and returns
structured JSON: present[], absent[], session_name, date.
3 Google Sheets — Search
Rows
Looks up each learner name/ID in the Learner Register sheet
to retrieve their current cumulative attendance totals.
4 Google Sheets — Add Row
(loop)
Logs each learner’s attendance entry to the Session Log
sheet: date, session, facilitator, learner ID, learner name,
present/absent.
5 Router — At-risk check If any learner’s updated attendance % falls below 80%, branch
to send an alert email. Otherwise skip to confirmation.
May 2026 |
| WhatsApp Attendance Automation —
# Module What it does
5a Gmail — Send Alert (if
triggered)
Sends an alert email to the project coordinator listing the at-risk
learner name, current attendance %, and session details.
6 Twilio — Send Message Replies to the facilitator on WhatsApp confirming attendance
was logged, with a summary and any flags raised.