Checking Google Drive sync…pulling from Google Drive
The dashboard reads its data straight from your shared Google Drive folders via a service account. Every sheet — in any workbook, under any name — is matched to a dataset by its columns and de-duplicated. New uploads are picked up automatically; no manual import, no login, no demo data.
The app scans every tab of every workbook in the connected folders and routes each one to a dataset by its column headers — not by the file name — so any export is picked up however it's titled. The unified Meta full_analysis export is detected by its row_type schema and split into market KPIs, campaigns, creatives and alerts. Rows are merged across files and de-duplicated by key columns, so a re-uploaded or overlapping file never double-counts. Report-style sheets that aren't a flat table — weekly analyses, format benchmarks, strategy packs — are parsed section-by-section and shown on their channel page, so nothing is skipped. Sheet contents are cached and only re-read when a file is actually uploaded or changed, so the data refreshes weekly without slowing navigation. Folders must be shared with the service account as Viewer.
Meta datasets are derived from the unified full_analysis export (showing the 7-day window; switch 7d/30d on the Meta pages).
21:58:36 [drive] ✓ Cowork-Klaviyo Analysis: 13 sheet(s) found21:58:36 [drive] ✓ Cowork-Meta Ads Analysis: 13 sheet(s) found21:58:36 [drive] ✓ Google Ads Analysis: 4 sheet(s) found21:58:36 ✓ HYGR Google Ads — Negative Keyword Pack → google_ads · report (5 sections)21:58:36 ✓ HYGR Google Ads Analysis — Windsor (90d) → google_ads · report (14 sections)21:58:36 • HYGR Klaviyo — 12-Campaign Calendar (Jun–Jul 2026) (no tabular dataset — skipped)21:58:36 • HYGR Klaviyo — Format Benchmarks (Mar–Jun 2026) (no tabular dataset — skipped)21:58:36 ✓ HYGR Klaviyo — Weekly Analysis (3 Jun 2026) → klaviyo · report (6 sections)21:58:36 ✓ HYGR Klaviyo — Weekly Brief (2026-06-08) → klaviyo · report — superseded duplicate21:58:36 • HYGR Klaviyo — Weekly Brief (2026-06-22) (no tabular dataset — skipped)21:58:36 • HYGR Klaviyo — Weekly Brief (2026-06-28) (no tabular dataset — skipped)21:58:36 • HYGR Klaviyo — Weekly Brief (2026-06-28) (no tabular dataset — skipped)21:58:36 ✓ HYGR Klaviyo — Weekly Brief (2026-07-05) → klaviyo · report — superseded duplicate21:58:36 ✓ HYGR Klaviyo — Weekly Brief (2026-07-12) → klaviyo · report (6 sections)21:58:36 • HYGR Klaviyo — Weekly Brief (2026-07-19) (no tabular dataset — skipped)21:58:36 • HYGR Klaviyo — Weekly Brief (2026-07-26) (no tabular dataset — skipped)21:58:36 • HYGR Klaviyo — Weekly Brief (2026-08-02) (no tabular dataset — skipped)21:58:36 • HYGR Klaviyo Email Data (no tabular dataset — skipped)21:58:36 • HYGR_Google_Ads_7d_full_analysis_2026-06-08 (no tabular dataset — skipped)21:58:36 • HYGR_Google_Ads_7d_full_analysis_2026-06-17 (no tabular dataset — skipped)21:58:36 • HYGR_Meta_30d_full_analysis_2026-06-07 (no tabular dataset — skipped)21:58:36 • HYGR_Meta_7d_full_analysis_2026-06-07 (no tabular dataset — skipped)21:58:36 • HYGR_Meta_7d_full_analysis_2026-06-08 (no tabular dataset — skipped)21:58:36 • HYGR_Meta_7d_full_analysis_2026-06-08 (no tabular dataset — skipped)21:58:36 ✓ HYGR_Meta_7d_full_analysis_2026-06-17 → meta · unified (7d) — superseded duplicate21:58:36 • HYGR_Meta_7d_full_analysis_2026-06-17 (no tabular dataset — skipped)21:58:36 ✓ HYGR_Meta_7d_full_analysis_2026-06-17 → meta · unified (7d)21:58:36 ✓ HYGR_Meta_7d_full_analysis_2026-06-22 → meta · unified (7d)21:58:36 ✓ HYGR_Meta_7d_full_analysis_2026-06-28 → meta · unified (7d)21:58:36 • HYGR_Meta_7d_full_analysis_2026-07-22 (no tabular dataset — skipped)21:58:36 • HYGR_Meta_7d_full_analysis_2026-07-26 (no tabular dataset — skipped)21:58:36 • HYGR_Meta_7d_full_analysis_2026-08-02 (no tabular dataset — skipped)21:58:36 • HYGR_Meta_Creative_Strategy_Pack_2026-06-07 (no tabular dataset — skipped)21:58:36 [meta unified] ✓ 186 row(s) adapted (7d: 186, 30d: 0)21:58:36 [reports] ✓ 4 report sheet(s) parsed (klaviyo: 2, google_ads: 2)21:58:36 [klaviyo_campaigns] — no data yet21:58:36 [klaviyo_snapshot_history] — no data yet21:58:36 [meta_campaigns] ✓ 57 row(s) from 3 file(s), de-duplicated21:58:36 [meta_creatives] ✓ 90 row(s) from 3 file(s), de-duplicated21:58:36 [meta_placements] — no data yet21:58:36 [meta_alerts] ✓ 53 row(s) from 3 file(s), de-duplicated21:58:36 [meta_snapshot_history] ✓ 12 row(s) from 3 file(s), de-duplicated21:58:36 [google_ads_campaigns] — no data yet21:58:36 synced 4/8 dataset(s) from Google Drive
Rates are raw decimals (0.412 = 41.2%). Dates are ISO YYYY-MM-DD.