.jpg)
The What
During my internship at On This Spot, a New York based feminist art history non-profit that produces short documentary films to bring the stories of pioneering women artists to life through the geography of New York, I focused on enhancing the efficiency and effectiveness of the fundraising research process. My role centered on building a structured knowledge base of foundation fundraising policies to support the organization’s development strategy.
The How
- Collected and reviewed fundraising policies and guidelines from multiple foundations, analyzing their alignment with the core mission to “put women artists on the map.”
- Built a searchable, categorized, and tagged database in Excel to record foundation criteria, deadlines, and proposal alignment information.
- Built Google Sheets automation tools, including formulas, scheduling, and conditional formatting, to track application progress and key deadlines in real time, linking the system to KPI dashboards to enhance fundraising strategy efficiency and monitoring.
The Impact
- Improved the team’s ability to cultivate and sustain foundation relationships by consolidating funding policies and historical engagement data into one centralized system.
- Implemented Google Sheet automation to track application timelines and update status in real time, significantly reducing manual entry and freeing staff to focus on strategic relationship-building.
- Improved data accuracy and reporting consistency, strengthening donor and foundation engagement strategies and informing targeted, mission-aligned fundraising initiatives.
