Ryan's Updates

• Conducted additional customer interviews and outreach with Boston Public Schools (BPS) and private foundations.
• Currently in discussions to onboard BPS schools as beta users within the next week.
• Designed the complete front end for the Dashboard page, with implementation scheduled for next sprint.
• Designed the chat page for the Grants AI search and chat feature.
• Collaborated with Gabriel to design and deploy a landing page for customer outreach. The new design will be live by Monday.
  • Landing Page - https://grantware.vercel.app/
• Updating all agent prompts to improve performance.
• Architecting agent requests to enhance the quality, visuals, and response time of answers.
• Conducting outreach to all Massachusetts schools using Python scripts, to gauge interests, get data, and beta users.
• Updated all GrantWare AI DOCS

Gabriel's Updates

• Successfully migrated the project from Firebase to Supabase for the backend.
• Integrated Prisma ORM with the new Supabase setup.
• Created an Entity-Relationship Diagram (ERD) for the application's collections tables.
• Developed pages and API endpoints for the following features:
  • Standard grants search with comprehensive query capabilities for all fields in the opportunities table.
  • AI-powered grants search, integrated with n8n to pass user and school district information for more informed recommendations.
  • A grant bookmarks page allowing users to view and delete their saved grants.
  • Admin-only pages and routes that permit admins to create user accounts and assign them to specific school districts.
  • Developed a script to create the first admin user.
  • Removed the "Get Started" option; users now require an admin-created account to log in.
  • A recommendations route that uses a separate n8n agent (via webhook) to return a specified number of grant recommendations.
• Integrated the grant recommendations feature into the application's homepage, where they are displayed as cards.

Adrian Julian Dybacki's Updates

• Implemented a new "Opportunities" database schema to generalize grant information, adding flexible columns like extra and attachments to accommodate unique data from various sources.
• Updated Mass DESE scraping scripts to extract basic information and leverage AI to generate database descriptions and parse details like funding amounts from plain text.
• Enhanced the grants.gov API fetch script with AI-powered summaries for descriptions and eligibility.