Design a strict JSON schema for parsing inbound emails
Convert unformatted customer inquiry emails into a strict, validated JSON schema with field types and enum values for reliable webhook payloads.
You getExtraction Strategy, JSON Schema Definition and sample Parsed Object
Prompt
Act as a software integration specialist. Create a strict, machine-readable JSON schema designed to extract and normalize structured data from raw inbound email text.
Rules:
- Use JSON Schema Draft 7 standards.
- Define clear property names, types, descriptions, and required fields based on the provided sample email.
- Use enums where values should be restricted (such as inquiry type, urgency, or department).
- Include explicit regex patterns for phone numbers, dates, and email addresses where applicable.
- Set additionalProperties to false to keep integrations predictable.
Output format:
1. Extraction Strategy (1-2 sentences on handling missing or unclear data)
2. JSON Schema Definition (clean, valid JSON schema inside a code block)
3. Sample Parsed Object (a valid JSON example matching the schema)
Here is the sample email text:Example output
Paste an example customer inquiry or inbound contact email at the end of the prompt in ChatGPT, Claude, or Gemini. Use the resulting schema in Zapier, Make, or custom API parsing code.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Classify inbound emails by intent and urgency
Triage customer and partner emails accurately without manual sorting. Get structured classifications for intent, tone, urgency, and recommended routing.
Architect an automated lead routing and enrichment workflow
Design a complete end-to-end specification for inbound lead qualification, third-party data enrichment, and team routing. Use it to eliminate manual lead handling.
Build a resilient dead-letter queue for webhooks
Architect a retry and dead-letter queue blueprint to capture, store, and replay webhook payloads when downstream systems fail.
Build a schema mapping table between webhooks
Map fields, transform data types, and define fallback values between source and target webhooks. Ideal when connecting two tools with mismatched JSON schemas.
Design a client onboarding automation for signed contracts
Create an automated client onboarding workflow that sets up shared folders, internal records, and welcome emails when deals close.
Draft approval gate rules for automated customer messages
Establish a reliable human-in-the-loop policy that catches errors before automated notifications or emails go out. Use this to protect customer trust without slowing down routine operations.
- Map an automated invoice and reminder sequence
- Map record fields to prevent duplicates across systems
- Repair malformed JSON payloads from language models
- Audit CRM fields to remove manual entry bottlenecks
- Build a pre-send data check for recurring reports
- Build an email triage rulebook with human escalation