WMC Pipeline

Manage Walmart Connect advertising data — onboard clients, monitor sync status, and run backfills.

Data coverage across all WMC clients. Click a client to see table-level detail.

No clients found in WMC Supabase. Use Onboard New Client to add the first one.

1 Step 1: Create sheets

Fill in the client and connection details below. This creates the Google Sheets and Supabase rows. You'll get the UUIDs in Step 2 after opening the new sheets.

Used to name the Google Sheets and the Supabase client row.

From Walmart Connect Manager. Stored in Supabase for reference.

Exact name from Supermetrics Hub. Leave blank to skip Search sheet creation.

Exact name from Supermetrics Hub. Leave blank to skip Display sheet creation.

2 Step 2: Add UUIDs and finish

Finishing onboarding for . Paste the UUIDs from the new sheets below.

Run Step 1 first. After the sheets are created, open each sheet → Extensions → Supermetrics → create one test query with the new client's connection → refresh it → copy the UUID from the SupermetricsQueries tab (Column W, before the backtick). Paste them here and click the button below.

From Column W of SupermetricsQueries in the new Search sheet (part before the backtick).

From the new Display sheet's SupermetricsQueries tab after creating a test query.

What this does
  • Step 1 copies template sheets, renames them, updates connection names, inserts Supabase rows.
  • Step 2 swaps the Supermetrics UUID so queries pull the new client's data; then you Refresh all in each sheet.
Open each new sheet → Extensions → Supermetrics → create one test query with the new client's connection → refresh → copy UUID from SupermetricsQueries Column W (before the backtick). Then run Step 2 here.
Apps Script Output

Found in the sheet URL: docs.google.com/spreadsheets/d/[THIS PART]/edit

1
Enable Batch Mode
Sets BACKFILL_MODE=true in Apps Script to prevent mid-run sheet clears.
2
Populate Backfill Chunk Rows
Creates the first date-range chunk per tab in 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.
3
Refresh All Queries in Supermetrics
Open the Google Sheet and click Extensions → Supermetrics → Refresh all. Then click "I've clicked Refresh all" to start monitoring.
Open Sheet
Checking query status…
4
Sync All Data to Supabase
Runs monitorAndSync() — reads all accumulated sheet data and upserts to WMC Supabase.
5
Clean Up & Restore Weekly Schedule
Removes chunk rows from SupermetricsQueries, resets date range to Last week (Sun-Sat), and disables Batch Mode.
Activity Log
Ready. Fill in the form above and click Enable to begin.