> Case Study: Data Pipeline for The States Project

Challenge

The States Project relied on Grapevine to manage donations for its Giving Circles program. The platform handled payment processing well, but its reporting tools were too limited for the organization’s needs. Teams across the organization needed daily, accurate fundraising data, and the existing dashboard could not support the level of detail required. Manual reporting was slow and incomplete.

Context

The States Project already used Airtable across much of the organization. They needed a clean way to bring donation data into Airtable and structure it in a format that supported internal reporting, program milestones, and cross-team decision making.

Grapevine’s team agreed to grant full API access, which opened the door for a custom data solution.

Solution

Fox Digital Labs designed and built a data pipeline that automated the entire flow of donation data.

Product work

• Redesigned the Airtable schema to align with the organization’s reporting needs.
• Helped the team define which data fields mattered most and how they contributed to program milestones.

Engineering work

• Built a Python ETL script that pulled data from the vendor API, applied business logic, and loaded it directly into Airtable through the Airtable API.
• Implemented daily syncs and update polling to ensure accuracy and completeness.

Outcome

The project delivered a fully automated donation dashboard that updated daily without manual work. Data across all Giving Circles became consistent, reliable, and ready for internal reporting. The States Project gained a scalable workflow and eliminated a major operational barrier.

Client Feedback

“Our team worked with Justen to help develop a script connecting one of our fundraising platforms to our Airtable so that we could have accurate daily fundraising data. Justen did an amazing job on our project, showing great technical skills and a clear understanding of our needs. He delivered exactly what we needed, making our system work so much better. Justen was professional, responsive, and went above and beyond to ensure everything worked properly.”
Denim Diaz, Project Manager, Growth – The States Project

Project URL