How it works
To create WhatsApp records from Microsoft SQL without manual input, use a ready-made scenario.
- Starts when: When WhatsApp Message Received
- Then: Normalize Message Input
- Check: Check 24h Message Window
- If yes: Retrieve Company Knowledge
- Then: Build AI Context
- Then: Prepare AI Booking Prompt
- Then: General Support Agent
- Then: Compose WhatsApp Response
- Then: Send WhatsApp Response
- Then: Fetch Current Date & Time
- Then: Append Log to Google Sheets
- Then: Extract Booking Details
- Then: Booking Information Agent
- Then: Parse Booking Data
- Then: Normalize Date and Time
- Check: Check Booking Feasibility
- If yes: Post Cal Booking
- If no: Handle Booking Failure
- If no: Send WhatsApp Reopen Message
- Then: Google Chat Model (Booking)
- Then: Store Simple Memory
- Then: Google Chat Model (Support)
You can launch this Microsoft SQL + WhatsApp integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.