WMC Pipeline
Manage Walmart Connect clients in Supabase, link Supermetrics connections, and run backfills.
Data coverage across all WMC clients. Click a client to see table-level detail.
No clients found in WMC Supabase. Use the Client setup tab to register a client.
Creates the WMC clients row. Optional Search / Display fields create client_connections using the exact Supermetrics Hub names. Add the optional ds_user UUID from the Query Builder so GAS direct API uses it (avoids QUERY_AUTH_UNAVAILABLE when Hub name alone is not accepted).
Optional. Must match Hub / sheet “Data source logins” exactly. Leave blank if no Search.
Optional. Leave blank if no Display.
If runDateRangeRepull logs 0 connections kept, add connection rows here. Use the same Hub names as in sheets. If the client row already exists, set ds_user UUIDs via paste or field — we update client_connections.ds_user_id for links that are already on file.
Found in the sheet URL: docs.google.com/spreadsheets/d/[THIS PART]/edit
BACKFILL_MODE=true in Apps Script to prevent mid-run sheet clears.SupermetricsQueries. After each "Refresh all" completes, click Sync this round & Advance to sync to Supabase, clear the sheet, and queue the next chunks (uses actual last row per tab — no estimates). Repeat until all chunks are done.monitorAndSync() — reads all accumulated sheet data and upserts to WMC Supabase.SupermetricsQueries, resets date range to Last week (Sun-Sat), and disables Batch Mode.