Booking requests from email — into a table, with a guest confirmation

The scenario reads booking emails on your Microsoft Outlook, sorts dates and details into columns of Affinity and sends the guest a confirmation.

  • Booking data straight into a table
  • Reads both text and attachments
  • The guest gets a confirmation
  • Incomplete requests flagged for review
Guardrails
Set it upScriptera

How it works

To move data from Affinity to Microsoft Outlook automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Look for incoming emails
  2. Then: Get many messages (1)
  3. Then: Guardrails1
  4. Then: Configuration: User Settings
  5. Check: IF (Guardrail Check)
  6. If yes: Filter Booking Emails
  7. Check: Check for Attachment
  8. If yes: Extract Attachment Data
  9. Then: OpenAI Model for PDF
  10. Then: Validate Extraction
  11. Check: Check for Errors
  12. If yes: Apply Business Rules
  13. Then: Log Team Assignment
  14. Then: Guardrails
  15. Then: Merge Sanitized Data
  16. Then: Append to Cases Sheet
  17. Then: Send Confirmation Email
  18. Then: Log Success Metrics
  19. If no: Log Error to Sheet
  20. Then: Send Error Notification
  21. If no: OpenAI Model for Email Text2
  22. If no: Set Invalid Email Error
  23. Then: Log Invalid Email Error
  24. Then: Send Invalid Email Notification
  25. Then: GEMINI 2.5 FLASH
  26. Then: CHAT GPT 5 mini

You can launch this Affinity + Microsoft Outlook integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios