Project Outcomes
BluLever needs Salesforce to serve as its single source of truth for student data. However, disconnected systems – including Google Drive, Canvas LMS, and legacy spreadsheets – led to corrupted fields, record mismatches, and administrative silos that hindered operational efficiency and student progress tracking.
This project set out to scale BluLever’s Salesforce SIS into a centralized operational platform. Key objectives included implementing a custom Lightning Web Component (LWC) for real-time Google Drive file linking, establishing an event-driven direct REST API sync with Canvas LMS, and cleaning up legacy student records to ensure reliable, end-to-end data integrity.
The enhanced SIS unifies administrative workflows, eliminates storage bottlenecks, and establishes a single, authoritative record for student data and course enrollments. By replacing manual spreadsheet tracking with direct Canvas API syncing and custom LWC file attachments, the system reduces administrative overhead, streamlines data validation, and lays a scalable foundation for future platform expansions.
Key technology/tools used: Salesforce NPSP, Lightning Web Components (LWC), APEX, Custome MetaData Types, REST API Sync, Canvas LMS API, Google Drive API, Google Sheets, Salesforce Inspector & Data loader.

File linking page

Linked files page