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.