
Closed
Posted
Paid on delivery
We need a [login to view URL] 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.
Project ID: 40443332
157 proposals
Remote project
Active 4 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
157 freelancers are bidding on average $144 USD for this job

I read through your plan for the Twilio and Claude AI automation. Processing unstructured WhatsApp messages is tricky because facilitators often type names differently. I have built similar workflows where we use LLMs like Claude Haiku to turn messy text into clean JSON. It saves so much time compared to manual entry. My focus is making sure your router logic for that 80 percent attendance threshold is rock solid so you never miss a student at risk. We can set up the Google Sheets search to handle those lookups quickly before the Gmail alert fires. I have handled automated data pipelines before and you can see my past work here: https://www.freelancer.com/u/microlent. Want a 2-min screen recording of how I would build Claude-driven unstructured text parsing? Just say the word. ~ Rajesh
$140 USD in 7 days
9.7
9.7

Hello, With my years of experience, I have become proficient in various programming languages like C# and PHP, giving me the versatility your project requires. I have a deep understanding of Google Sheets and can ensure smooth data logging as well as pulling data from learner registers. Additionally, I am adept with Twilio and can particularly help with the task of sending attendance confirmation replies to facilitators on WhatsApp. My knowledge extends beyond the technical aspect of your project. As a web service provider, I understand that user experience is crucial. I ensure not just efficient data management but also clear and concise messages communicated between the system and the users within the limitations of WhatsApp capacity. In conclusion, choosing our team for this project guarantees access to not only highly-skilled individuals but also professionals committed to putting a 'WOW' factor into your work. Choosing us would be an investment you make towards reaching new heights for your business. I am excited about this opportunity and would be thrilled to get started! Thanks!
$130 USD in 2 days
8.6
8.6

Hi, this WhatsApp attendance automation project is a clear fit for AI-driven orchestration and workflow integration, which I have extensive experience with. The main engineering risk lies in orchestrating reliable message ingestion and data synchronization across Twilio, Claude API, and Google Sheets while ensuring low-latency confirmation. I usually design systems with clear separation between ingestion triggers, AI parsing, and data persistence layers to isolate failure points and simplify debugging. I've built similar end-to-end AI automation pipelines, notably in the AI-Driven Marketing Suite Development project where I integrated AI modules with external APIs and managed real-time workflows. For LLM reliability, I recommend implementing confidence thresholds and fallback logic to catch parsing inconsistencies from Claude API. This ensures data quality before logging attendance. Systems like this benefit from production-grade error handling and monitoring to support long-term operation and reduce manual intervention. I can start by outlining the retrieval pipeline and mapping the agent flow to ensure robust message processing and confirmation. Thanks, Hercules
$140 USD in 7 days
7.0
7.0

Hi, this WhatsApp attendance automation project is a clear fit for AI-driven orchestration and workflow integration, which I have extensive experience with. The main engineering risk lies in orchestrating reliable message ingestion and data synchronization across Twilio, Claude API, and Google Sheets while ensuring low-latency confirmation. I usually design systems with clear separation between ingestion triggers, AI parsing, and data persistence layers to isolate failure points and simplify debugging. I've built similar end-to-end AI automation pipelines, notably in the AI-Driven Marketing Suite Development project where I integrated AI modules with external APIs and managed real-time workflows. For LLM reliability, I recommend implementing confidence thresholds and fallback logic to catch parsing inconsistencies from Claude API. This ensures data quality before logging attendance. Systems like this benefit from production-grade error handling and monitoring to support long-term operation and reduce manual intervention. I can start by outlining the retrieval pipeline and mapping the agent flow to ensure robust message processing and confirmation
$140 USD in 7 days
6.7
6.7

With my profound experience of over 10 years in the IT industry, I possess the requisite skills to meet your requirements. As a Full Stack Developer with a specialty in AI Solutions and Automation, this project is a fit tailor-made for me. I have diversified skills in using APIs and developing integrations across various platforms like Twilio, Google Sheets, Gmail - all of which are key components for this project. My proficiency in C# programming will be handy while working with the Claude AI API. Lastly, my forte in end-to-end app development aligns with your expectations. I am not just offering you code, but a solution with scalability and long-term support. So, put your project in hands you can trust - let's work together and turn your vision into reality!
$190 USD in 7 days
6.4
6.4

Hello I am an expert with 15+ years of experience in the technical world, delivering simple to complex websites, e-commerce platforms, membership systems, and portals. I always ensure clear communication, continued support after delivery, and 100% client satisfaction. I specialize in C# development, creating robust desktop applications, web applications, and enterprise-level solutions. With expertise in .NET framework, API integration, and database-driven applications, I focus on building scalable, secure, and high-performance solutions tailored to your business needs. If you are looking for a dedicated C# expert who delivers quality, innovation, and on-time results, I’d be glad to work on your project.
$100 USD in 7 days
6.0
6.0

Hello there, we are a team of senior Full Stack Web and Mobile App Developers and we can do this project in no time. Thanks Ashish Kumar.
$140 USD in 7 days
5.8
5.8

✋ Hi There!!! ✋ The Goal of the project:- To automate WhatsApp attendance logging using Claude AI, Google Sheets, and Twilio with real-time confirmation and alerts. I have carefully read and understood your requirement for receiving WhatsApp messages, parsing them with Claude API, logging attendance to Google Sheets, and sending confirmation or alert messages. I am the best fit for this project because I have 9+ years experience as a full stack developer building automation and API-integrated workflows. I will implement Twilio WhatsApp triggers, Claude API parsing, and Google Sheets logging. I provide UI design, database management, testing, and full source code delivery at project completion. I have successfully developed similar automation systems for attendance and data tracking with real-time notifications. Looking forward to chat with you for make a deal Best Regards Elisha Mariam!
$99 USD in 9 days
5.5
5.5

As an experienced full stack web developer with a strong background in PHP, I am poised to deliver an outstanding solution for your attendance automation needs. Over the past 8 years, I have developed numerous backend systems that have utilized REST APIs, made third-party API integrations, and utilized technologies such as Google Sheets and Twilio - all of which are directly applicable to your project. My achievements in building e-commerce platforms and inventory management systems demonstrate that I am capable of delivering robust solutions for data logging purposes. I have also successfully completed projects involving inter-platform data integration which included using Google Sheets APIs. So the combination of these experiences makes me well equipped to handle the processing and logging requirements of your WhatsApp attendance automation project. Moreover, my communication skills are rapid and precise, ensuring a smooth flow of information throughout the development cycle. My prompt response times, punctuality in delivering high-quality code, commitment to client satisfaction, and my long-term support approach make me the ideal choice for your project. Choosing me means you gain a seasoned professional committed to turning every idea into a business-growth-oriented reality. Let's discuss further how I can actualize this vision for you!
$100 USD in 4 days
5.2
5.2

As a seasoned full-stack developer, I bring a wealth of experience in C# programming, Google Sheets and PHP, all of which align perfectly with the requirements of your Whatsapp attendance automation project. My proficiency in API design and integration will ensure seamless communication between Twilio, Claude API, Google Sheets, and Router among others in your system. Moreover, my understanding of database management and optimization will contribute to the smooth logging of attendance data into session logs for your team access. On top of my technical proficiencies, I am renowned for my commitment to client success through efficient project handling from front-end to back-end. In this project, this means that I'll take care of every part of the system ensuring that they work well together without any glitches. I would also leverage on my proactive communication style and fast response rate to guarantee minimal back-and-forth interactions for optimal time efficiency. Finally, given that you expect prompt delivery without compromising quality; I have a reassuring track record for timely completion without undermining the delivery value. My clean, scalable and maintainable coding approach resonates with your desire for an efficient long-term solution. Look no further than Nutan Kumar to automate your attendance system meticulously and effectively while ensuring a pleasant working relationship throughout the process.
$80 USD in 7 days
5.1
5.1

I can build your automation that processes WhatsApp attendance messages from facilitators using Twilio, parses them with Claude AI into structured data, logs attendance into Google Sheets, and sends real-time confirmation messages back via WhatsApp. The workflow will also include learner lookup, session logging, automatic attendance percentage tracking, and an at-risk alert system that emails the coordinator when attendance drops below 80%, ensuring a fully automated and reliable attendance monitoring system. regards, Shawana
$30 USD in 7 days
4.2
4.2

Hello, I have experience with Twilio for messaging, Google Sheets for data management, and API integrations, having implemented automated systems that log user interactions and send notifications in real-time. For your project, I can build an automation that captures WhatsApp messages via Twilio, processes them through the Claude AI API to extract attendance details, and updates Google Sheets accordingly. A key scenario could involve setting up an automated error handling mechanism for API responses to ensure data integrity. Let's discuss!
$150 USD in 3 days
4.1
4.1

Hello Dear! Good Day! Hope you are doing fine. This is Ruhul Ajom Sagor. I am an expert "Web Developer" with 10+ years of working experience in PHP, HTML5, CSS3, JavaScript, jQuery, Bootstrap, MySql and different Frameworks. I have completed my B.S.C Engineering in Computer Science and Engineering (CSE) from BUET. Hire me and you don't have to worry about your website problems again! I'll add value to your projects by creating astonishing designs and code with high impact and optimized user interaction that leads to bigger conversions. WHAT PROBLEMS CAN I HELP YOU SOLVE? • Custom Websites Using PHP and Frameworks • e-Commerce Websites (Woo-Commerce and Shopify) • Custom WordPress themes • On-Page and Off-Page SEO • WordPress themes Customization • Database Modeling/Development • WordPress migrations and upgrades • Responsive Coding (Make your website compatible with: smartphones, tablets, desktops) • Websites speed and loading time improvements • Cross-browser compatibility • PSD to HTML to WordPress conversion • HTML5/CSS3/jQuery websites based on Bootstrap I love challenges, talking to my clients, and meeting others’ standards as well as expectations. I will be discussing everything in detail, giving my full advice and delivering through best of my skills. You are cordially welcome to discuss your project. Thank You! Best Regards, Ruhul Ajom
$50 USD in 2 days
5.6
5.6

As a seasoned developer with expertise in PHP, Node.js, Vue.js, and C# programming and proficiency in Web Development, Automation, and Data extraction. I believe I'm the perfect match for your project on WhatsApp Attendance Automation. My knowledge and experience align perfectly with the technical requirements of your project. Over the years, I have developed several applications similar to what you are asking for here; utilizing various APIs like Twilio to interact with WhatsApp messages and integrating Google Sheets and Gmail API to automate data storage, retrieval, and email alerts. Furthermore, I've worked extensively with third-party APIs like Claude API to parse structured data from raw text - another amazing feature your project. These skills contribute significantly to making me the best fit for this job. My commitment to delivering quality codes combined with a results-driven approach that prioritizes efficiency and scalability makes me an ideal candidate. Working on this project would allow me to showcase my expertise while providing you with an effective automation solution that gives accurate attendance records via WhatsApp and offers reliable email notifications using Google Sheets or Gmail where required. Partnering with me is partnering for the best possible outcome in your project.
$140 USD in 3 days
4.1
4.1

With my diverse skillset, encompassing Google Sheets and substantial experience in software architecture, I am fully equipped to provide you with a high-quality solution for your WhatsApp Attendance Automation project. Harnessing the power of Python-based Claude API and Google Sheets, I will create an efficient workflow that extracts crucial data from facilitators' attendance messages, parses it using the Claude AI API, fetches learner details from the Learner Register sheet, and securely logs them into the Session Log sheet. As a data scientist and automation specialist, I excel in tailoring functional workflows that optimize operations. My in-depth knowledge of Google Sheets allows me to skillfully employ functionalities like searching rows and adding rows repeatedly for individual learners. This neatly aligns with your requirements of adding attendance dates, facilitators, learner IDs, names, present/absent status in the Session Log sheet. This analytical capacity will aid me in executing task 5a of your project diligently- identifying at-risk learners whose attendance percentage falls below 80%, if triggered. Given the critical nature of user data involved here, my adherence to strict privacy standards ensures that all confidential information is kept secure. Let us work together to automate and facilitate your attendance-tracking process efficiently.
$140 USD in 7 days
3.9
3.9

Hi — your module outline maps cleanly to Make: inbound WhatsApp, structured parse via Claude Haiku, register lookup + session logging, 80% check, coordinator email if needed, then a facilitator confirmation on WhatsApp. 1) I’ll implement the flow as specified: Twilio watch → HTTP (Claude with a tight JSON schema: present[], absent[], session_name, date) → Sheets search on the Learner Register → looped Session Log rows → router on updated attendance % → optional Gmail alert → Twilio reply with summary and flags. 2) I’ll add guardrails you’ll want in production: validate/repair JSON when the model drifts, handle webhook retries without double-posting rows, and clear errors when a name does not resolve in the register (so you do not silently drop learners). 3) Twilio/WhatsApp: confirmations use your live number and template rules; I’ll align copy with what Twilio allows for outbound session messages. 4) Deliverables: exported Make blueprint, a one-page field map (sheet columns ↔ Make), and a short facilitator cheat sheet. If you share sample facilitator messages plus the exact Register and Session Log headers, I can lock scope and timeline inside your budget range. — SynapticFlow
$100 USD in 7 days
3.9
3.9

Hello, The primary challenge lies in ensuring reliable data synchronization between WhatsApp messages, the Claude API, and Google Sheets. This requires precise handling of real-time updates and potential discrepancies across systems. Additionally, managing the flow of data while maintaining security around sensitive learner information is critical. What specific data structures does the Claude API return, and how should they be mapped to the Google Sheets format? Are there specific thresholds for attendance that trigger the alert, and how are these defined? Lastly, is there an existing setup for Twilio, or will a new configuration be needed for this automation? Looking forward to discussing the architecture further.
$30 USD in 7 days
3.4
3.4

With over 6 years in AI development and full-stack engineering, I am excited to bring my skillset and passion for building solutions that solve actual problems efficiently to your project. As you know, this particular task requires not just technical expertise but a deep understanding of data parsing, management, and automation - precisely the skills I've honed over my career. My proficiency in languages such as PHP and extensive knowledge of Software Architecture make me more than capable of building an end-to-end automated system with features like Google Sheets integration, email alerts, and Twilio messages - crucial functionalities for this project. Furthermore, my experience in building AI-powered digital products would complement the implementation of Claude API to parse WhatsApp attendance messages in an intelligent manner.
$30 USD in 2 days
2.4
2.4

With over two decades of software development experience, I, Barry at DemiVision, have the necessary skills and expertise to successfully deliver on your attendance automation project. Building on our deep technical knowledge, we have created mobile and web applications, and integrated AI to develop high-performing and scalable systems. I assure you that your WhatsApp attendance automation project would meet these high standards. One of our key strengths lies in building robust Webhooks that will effectively leverage Twilio's Watch Messages Trigger and connect with the Claude API for receiving WhatsApp attendance messages from facilitators. We can harness Claude's power in parsing and returning structured JSON whilst integrating Google Sheets to search rows in the Learner Register sheet - an essential feature for your project. Our proficiency doesn't end there; we also have proficiency in backend engineering and cloud deployment which will be valuable for logging each learner's attendance data to the Session Log sheet - a process that involves date, session, facilitator, learner ID, learner name present/absent tags. Additionally, if any learner’s attendance falls below 80%, we can quickly design an email alert system using Gmail to notify the coordinator accordingly. Choose me and DemiVision as your long-term technology partners who will elevate your project with custom web application development, mobile apps for Android & iOS, API development & system integration among other skills. We'll ensure your attendance automation solution is not only technologically precise but also secure, easily maintainable with measurable business outcomes. Let's actualize your digital transformation dream with sustainable growth through innovation!
$140 USD in 5 days
1.4
1.4

Development of responsive web applications using jQuery, PHP (Laravel, CodeIgniter), WordPress (hooks and plugins management), C# (.NET Core, WinForms, WebAPI), Node.js (microservices, Postman), Vue.js, Angular, HTML5, and Python (FastAPI, Django). Experience with relational databases (MySQL, PostgreSQL, Oracle, SQL Server) and NoSQL (MongoDB). Scalable and optimized solutions.
$156 USD in 7 days
2.5
2.5

Cape Town, South Africa
Payment method verified
Member since Jun 22, 2015
$250-750 USD
$210-1750 USD
$250-750 USD
$15-25 USD / hour
$750-1500 USD
$250-750 SGD
₹750-1250 INR / hour
$30-250 USD
₹1500-12500 INR
$10-30 USD
£250-750 GBP
$250-750 USD
₹12500-37500 INR
$250-750 USD
$200-250 USD
₹1500-12500 INR
$30-250 USD
$250-750 USD
$10-150 USD
₹1500-12500 INR
₹37500-75000 INR
₹1500-12500 INR
$25-50 AUD / hour
€750-1500 EUR
$10-30 USD