ParcelPanel ↔ Sheet Cross-Check

Upload a ParcelPanel "Info Received" export → reads your Google Sheet tab directly → shows every order missing from the sheet.
⚠️ SP orders (tracking starts with SP) are excluded — they live in the SP sheet tab and are not checked here.

Step 1 — Options

Store

Sheet Tab Name

Minimum Residence Days

2 — Sheet Credentials (pre-filled from server env vars when configured)

Google Sheet ID or URL

Google API Key (read-only, from Google Cloud Console → Credentials)

Create a read-only API key: Google Cloud Console → APIs & Services → Credentials → Create API Key → restrict to "Google Sheets API". Kept in sessionStorage only — never sent anywhere except Google's API.

Step 2 — Upload ParcelPanel CSV Export

📦

Drag & drop your ParcelPanel export CSV here

Export from PP filtered to "Info Received", or export all — we filter to Info Received here

Browse file

Reads the sheet tab directly via Google Sheets API and compares with the uploaded CSV

❌ Missing from Sheet

Info Received in PP with residence ≥ 5 days — NOT found in the sheet tab

Order #	Tracking #	Carrier	Residence (d)	Order Date	Fulfillment Date	Last Checkpoint	Product

✅ Found in Sheet

Confirmed present in the sheet tab

⚠️ SP tracking numbers excluded — orders with tracking starting with SP belong to the 4. ORDER_TRACKING tab and are not checked here.