Send confirmation email and update intake spreadsheet record

Intake submissions lack confirmation and incomplete rows leave applicants unsure and staff chasing details. Send instant personalized confirmations and update the intake sheet so applicants hear back.