This is a well-scoped project with some interesting technical challenges, particularly around the TTLock integration and the OpenAI Vision QA pipeline.
**What caught my attention:**
The event-driven checkout flow into dynamic Google Form generation is smart — it means your cleaning staff gets a pre-filled checklist without needing a separate app. The real complexity is in the vision QA loop: image upload, OpenAI analysis, pass/fail routing, and PMS status update all need to happen reliably with proper error handling.
**Relevant experience:**
I build API-heavy automation systems daily. A recent project involved integrating Amazon Ads API (OAuth2), Keepa API, and ClickUp API into a multi-agent intelligence system with structured JSON processing, conditional routing based on AI analysis results, and automated Slack notifications — very similar pattern to your checkout-to-QA pipeline.
**How I’d approach your key technical challenges:**
- **TTLock integration:** HTTP module with OAuth token management, webhook listener for lock events, and a PIN generation scenario that fires on confirmed booking. The critical part is handling the token refresh cycle reliably since TTLock tokens expire.
- **OpenAI Vision QA:** Image URLs from form submissions sent to Vision API with a structured JSON schema enforcing pass/fail + specific issue categories. Router splits based on the JSON response — pass updates PMS status directly, fail triggers WhatsApp alert to operations with the flagged images attached.
- **Scalability for 100+ units:** Modular scenario design from day one — each workflow (checkout trigger, form processing, QA analysis, notifications) as a separate scenario connected via webhooks. This means you can update one without touching others, and operations limits scale linearly.
- **Error handling:** Every external API call gets a retry/fallback path. Failed TTLock calls queue to a Google Sheet “retry log” with full context. No silent failures.
**Questions before scoping:**
1. Is Nowistay confirmed as the PMS, or are you still evaluating? API availability varies significantly between PMS platforms.
2. For TTLock — are the locks already deployed, and do you have API credentials set up?
3. How many images per QA inspection on average? This affects OpenAI API costs and scenario operation counts.
4. Do you need multi-language WhatsApp notifications for cleaning staff?
**About me:**
- Founder of Evara AI (incubated at IIT Bhubaneswar) — custom automation and AI systems
- 1.5+ years of production API integrations (REST, OAuth2, webhooks, structured JSON)
- Time zone: IST (UTC+5:30), available 20+ hours/week
- Happy to share hourly rate after understanding full scope
I’d be glad to walk through the architecture on a quick call. Reach me at: priyanshukumarmaurya2224@gmail.com