Timesheet Filter

Connect to Google Sheets, filter by date range and candidate, then save to database

🔑 Step 1 — Google OAuth Client (v1.4 - CACHE DEBUG)
Create an OAuth 2.0 Web Client ID in Google Cloud Console, enable the Google Sheets API, and add your site URL to Authorized JavaScript Origins.

Not signed in.

📊 Step 2 — Spreadsheet

🗂 Step 3 — Column Mapping

Sat–Fri hours are tied to calendar days using the row's week-ending Friday.

🔍 Step 4 — Filter & Calculate Hours

Each day column (Sat–Fri) counts only if that specific calendar day falls within the date range.