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:
- Extract specific details from the email body, including:
- Account Number (e.g., "Account Number: 987654321")
- NSF Amount (e.g., "NSF Amount: $150.75")
- Match the extracted data with client records stored in Zoho Analytics.
- 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:
- What is the recommended method to parse structured data (Account Number, NSF Amount) from an email body?
- Can this be done natively within Zoho Desk or Flow somehow, or do I need a custom function?
- 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!