Validate incoming file rows and load valid records into a database table.
Check emailed requests and confirm each valid table entry by ID.
Turn emailed entry requests into database rows, with a reply that confirms the ID or tells the sender what to fix.
Add valid intake forms to the tracking table and report the result.
Keep your tracking table focused on valid form responses, with an email explaining what was added or what needs fixing.