Match Users with Financial Aid Programs using GPT 5-Nano with Automatic Letters & Emails

Description

How It Works
The webhook receives incoming profiles and extracts relevant demographic, financial, and credential data. The workflow then queries the programs database to identify suitable options, while the AI generates personalized recommendations based on eligibility and preferences. A formal recommendation letter is created, followed by a drafted outreach email tailored to coordinators. Parsers extract structured data from the letters and emails, a Slack summary is prepared for internal visibility, and the final response is sent to the appropriate recipients.

Setup Steps
Configure AI agents by adding OpenAI credentials and setting prompts for the Program Matcher, Letter Writer, and Email Drafter.
Connect the programs database (Airtable or PostgreSQL) and configure queries to retrieve matching program data.
Set up the webhook by defining the trigger endpoint and payload structure for incoming profiles.
Configure JSON parsers to extract relevant information from profiles, letters, and emails.
Add the Slack webhook URL and define the summary format for generated communications.

Prerequisites
OpenAI API key
Financial programs database
Slack workspace with webhook
User profile structure (income, GPA, demographics)

Use Cases
Universities automating 500+ annual applicant communications
Scholarship foundations personalizing outreach at scale

Customization
Add multilingual support for international applicants
Include PDF letter generation with signatures

Benefits
Reduces communication time from 30 to 2 minutes per applicant, ensures consistent professional quality