sakura3id/rekap-viewer ? reverse-engineered prompt

Build me a secure web app for viewing IPL payment recaps from a Google Sheet.

It should show a clean table with Blok, Nomor, and monthly payment status, with sticky headers and frozen side columns so people can scroll through long data easily. Regular residents should not see names, but committee members should, so please make privacy depend on the user role. I also want the app to check permissions before showing data, and to keep the Google Sheet details hidden in the browser by using a server side proxy.

Please make it work nicely on mobile too, with collapsible filters, multi select status filters, and a quick way to search and compare house numbers. If possible, connect it to the existing community login session so users do not need to sign in twice, and include a simple profile dropdown that shows who is logged in.

Use the current docs online if you need to, and make it easy to run locally and deploy later on Fly.io.