Dashboard
View only —

Evidence dashboard

A one-way mirror of the Main sheet. Browse, search and inspect evidence — no editing.

Total listings
0
Source rows in the Main sheet
Purchased
0
Listings with purchase activity
Delivered
0
Listings with a delivery date
Invoices linked
0
Direct invoice access
Media linked
0
Initial or key evidence folders
Total transaction
₹0
Sum across purchased listings
Unique sellers
0
Across all marketplaces
OSINT linked
0
Listings with OSINT folder

Recent listings

Latest 8 entries from the sheet

Evidence records

Read-only browser of the Main sheet. Search, filter and inspect evidence assets.

Loading…
Visible listings
0
Visible transaction (INR)
₹0
Visible delivered
0
Visible with media
0

Insights

Distribution of sellers, publishers and account holders across the evidence pool.

Top sellers 0
Top publishers 0
Top titles 0
Spend by seller (₹) ₹0
Top account holders 0
Coverage

About this dashboard

Read-only customer browser for the BC Guardian Evidence Collection sheet.

How it works

  • The dashboard is a one-way mirror of the Main tab in the connected Google Sheet.
  • No fields are editable here. The sheet remains the single source of truth.
  • Hyperlinked evidence cells are detected from real cell hyperlinks, rich-text run links and HYPERLINK() formulas.
  • Google Drive file and folder links are auto-converted to drive.bytes.care.
  • Login is restricted to the email patterns configured in MASTER_ACCOUNTS (e.g. *@bytescare.com).

Required environment variables

  • SHEET_ID, SHEET_NAME (default Main)
  • GOOGLE_CLIENT_EMAIL, GOOGLE_PRIVATE_KEY
  • AUTH_SECRET
  • SMTP_HOST, SMTP_PORT, SMTP_USER, SMTP_PASS (and optionally SMTP_FROM, SMTP_SECURE)
  • MASTER_ACCOUNTS — comma-separated, supports * wildcard
  • CUSTOMER_NAME — optional, shown in the header / OTP email
  • APP_NAME, DRIVE_PROXY_BASE — optional