Pooja Jha
RBITC Project Tracker · Pet project
For
Rotary Bangalore IT Corridor
Built with
Next.js · Google Sheets · Vercel
Status
Proof of concept, live on Vercel
The brief
Track every project
A clear status, a lead, volunteers, and a target for people reached.
Record real impact
Expected versus actual reach, rolled up for the whole club.
Remember members
Birthdays and anniversaries, surfaced before they arrive.
Product tour
01
The club’s impact at a glance: people reached this term against the year’s target, projects by category, and expected versus actual beneficiaries.
02
Every project in one list, searchable and filterable by category and lead. Each one moves through clear stages.
IDEA
PLANNED
IN PROGRESS
COMPLETED
IMPACT RECORDED
03
After a project runs, members and guests rate it and share what went well. Each response moves from New to Reviewed to Actioned, so suggestions don’t get lost.
Coming up
RM
Rahul Mehta & Kavya
Anniversary · 16 Oct · in 2 days
SI
Sneha Iyer
Birthday · 20 Oct · in 6 days
AN
Arjun Nair
Birthday · 21 Oct · in 7 days
04
Members’ special days, grouped month by month, with the next few always waiting on the dashboard. A small thing that keeps a club close.
Under the hood
01
Members
Sign in with their Google account
02
Next.js app
Built and hosted on Vercel
03
Service account
Connects the app to Google’s API
04
Google Sheet
Stores projects, impact, feedback, and dates
Storage on Google Sheets and hosting on Vercel both run on free tiers, so within those limits the tracker costs the club nothing to run.
My role
01
Ideation
Spotted the need and shaped what the tracker should cover: projects, impact, feedback, and members’ special days.
02
Lead
Led the project from the first idea to a working app that club members sign in to.
03
Proof of concept
Delivered a working proof of concept on Next.js, Google Sheets, and Vercel, where it’s temporarily hosted.
Where it stands