Brainforge Knowledge

LMNT_week_by_week_README

2 min read

LMNT Week-by-Week Inputs/Outputs — Import into Google Sheet

Target Sheet: Your week-by-week table
Data sources reference: Brainforge x LMNT - Data Platform Documentation (Data Sources tab)

Files in this folder

FileUse
write_week_by_week_to_sheet.shWrite table + Assumptions to Sheet via gws (run after gws auth login -s sheets,drive)
LMNT_week_by_week_values.jsonJSON payload for main table (used by script)
LMNT_week_by_week_assumptions_values.jsonJSON payload for Assumptions (used by script)
LMNT_week_by_week_inputs_outputs.csvMain table: 14 weeks (for manual import if not using gws)
LMNT_week_by_week_ASSUMPTIONS.csvAssumptions (for manual import if not using gws)

How to build the table in your Sheet

  1. Re-auth if you get 401: gws auth login -s sheets,drive (complete browser flow).
  2. From this folder:
    chmod +x write_week_by_week_to_sheet.sh && ./write_week_by_week_to_sheet.sh
    Writes table to A1:F15 and Assumptions to A17:B24 on the first sheet.
  3. If your first tab is not named “Sheet1”, run: SHEET_NAME="YourTabName" ./write_week_by_week_to_sheet.sh

Option 2: Import the main table (manual)

  1. Open the target sheet: https://docs.google.com/spreadsheets/d/1PXjBjM_MSfG5jT53Ouv6VHOWge0rBxGLvBaic6Kzt6g/edit?gid=0#gid=0
  2. File → Import → Upload and select LMNT_week_by_week_inputs_outputs.csv.
  3. Choose Replace spreadsheet or Replace current sheet (or Insert new sheet(s) if you want to keep existing content).
  4. Select Comma as separator. Import.

Option B: Paste from CSV

  1. Open LMNT_week_by_week_inputs_outputs.csv in a text editor or Excel.
  2. Select all (Cmd+A), copy.
  3. In the target Sheet, click cell A1, then Edit → Paste.
  4. If columns don’t split: Data → Split text to columns, choose Comma.

Add Assumptions

  • Either import LMNT_week_by_week_ASSUMPTIONS.csv as a new sheet (e.g. “Assumptions”), or
  • Copy the two columns into the same sheet above the week-by-week table (e.g. rows 1–7), and start the table at row 9.

In the Sheet, add a note or cell (e.g. above the table):
“Source: Data Platform Documentation – Data Sources” so Phil can open the latest connector status.

Content notes

  • Weeks start 2026-03-10 and align to the renewal Feb–July timeline and the Data Platform Documentation (e.g. Amazon 3/3, Walmart 3P & Spins 3/14, TikTok 3/20).
  • Inputs/Outputs use the same outcome language as the plan-of-attack and Strategic Planning Framework (e.g. “Amazon + Shopify sales aligned and finance ready”, “One dashboard for retail VP”).
  • Primary role maps to DE / AE / Analyst so you can add a “Person” column later (e.g. New AE = [name]) without changing structure.

Graph View