React-Django Web App Build

Job ID: 39884090

Budget: $250 – $750 USD

we’re building a secure client portal for our Fundaday Funding Software.



Right now, the software writes funding results into a Google Sheet — one row per bank result.



We want to replace that spreadsheet view with a custom web dashboard that matches our Fundaday layout.



Users will log in with their Google account and only see clients that are CC’d to their Gmail in the sheet.



When they type a client’s name, they’ll instantly see the funding results (approved/denied/amounts) displayed in a clean interface.




What Needs to Be Built



Front-End
Simple landing/login page with “Sign in with Google”



Clean responsive dashboard layout (like our sample screenshot)



Search bar for client name



Client Summary Card:



Name, Business, Total Approved, Date Submitted



Bank Results Table:



Bank | Status | Amount | green ✓ or red ✕ icons



“Upload Docs” + “Add Note” buttons (placeholder actions)



Back-End / API
Google Apps Script Web App (or Node.js backend) that connects to the Google Sheet



Filters rows where the CC column includes the signed-in user’s Gmail address



Returns that data as JSON for the front-end



(We’ll provide the developer with the API or Sheet the bot already writes to)



Authentication
Use Google Identity Services for secure OAuth login



Automatically detect and verify the signed-in Gmail address



Only return data for that address (server-side filter)



Integration
Front-end fetches filtered results from the API



Displays data in the dashboard layout



Search by client name



Must be mobile-friendly




Technical Skills Required
Google Apps Script & Google Sheets API



Google Identity / OAuth (Sign in with Google)



JavaScript, HTML, CSS (Bootstrap or Tailwind welcome)



API integration & JSON handling



Optional: WordPress experience (to embed the portal later)




Deliverables
Working hosted dashboard page



Connected Google Apps Script backend



Functional Google Login flow



Filtered search results display



Documentation on how to update Sheet ID, client IDs, etc.