Best Way to Extract Structured Data from Emails in Zoho Desk/Flow

Best Way to Extract Structured Data from Emails in Zoho Desk/Flow

I am trying to automate the processing of NSF (Non-Sufficient Funds) notices received via email in Zoho Desk. Specifically, I need to:

  1. Extract specific details from the email body, including:
    • Account Number (e.g., "Account Number: 987654321")
    • NSF Amount (e.g., "NSF Amount: $150.75")
  2. Match the extracted data with client records stored in Zoho Analytics.
  3. Send an automated email with the NSF details to a specific team member.

Since Zoho Desk does not have an email parser, and Zoho Flow does not have a built-in text formatter, what is the best way to extract structured data from email bodies within Zoho Flow?

Specific Questions:

  1. What is the recommended method to parse structured data (Account Number, NSF Amount) from an email body?
  2. Can this be done natively within Zoho Desk or Flow somehow, or do I need a custom function?
  3. Is there an alternative Zoho tool or feature that can better handle email parsing?

I would appreciate any guidance or best practices to accomplish this. Thank you!