In this project, I designed and deployed an n8n workflow to streamline employee check-ins using UltraMsg, Odoo, and WhatsApp. The goal was to automate data extraction, image processing, and storage while ensuring seamless API interactions between different platforms.
✔ Webhook integration – Captures real-time messages from WhatsApp via UltraMsg.
✔ Data cleansing & processing – Formats employee phone numbers and removes unnecessary suffixes for precise identification.
✔ Image conversion – Transforms uploaded images into Base64 format for Odoo compatibility.
✔ Automated record updates – Links employee data with corresponding check-in information in Odoo.
⚡ Handling inconsistent phone number formats – Implemented custom data-cleaning logic.
⚡ Ensuring image compatibility with Odoo – Developed a transformation process for smooth storage.
⚡ Managing multiple webhooks with the same UltraMsg account – Configured unique identifiers to avoid conflicts.
This project enhances automation efficiency and ensures accurate data handling, improving operational workflows within Odoo.