google-sheets

# Google Sheets Writing Use this skill whenever you need to write structured data into an existing spreadsheet. ## Requirements - **Hyper MCP installed and connected.** [https://app.hyperfx.ai/mcp](https://app.hyperfx.ai/mcp) - **Google Sheets integration** enabled at [https://app.hyperfx.ai/apps](https://app.hyperfx.ai/apps). ## Core Rule Never write to Google Sheets from guessed column letters alone. Always: 1. inspect the workbook and target worksheet 2. find the real header row 3. map fields by header name 4. verify the destination range 5. write 6. read back sample rows to confirm alignment ## Critical Failure Modes To Avoid - Do not assume row 1 is the real header row. - Do not assume column `A` is the first business/data column. - Do not treat helper cells like `Total`, notes, formulas, merged labels, or spacer columns as real headers. - Do not overwrite a broad range before checking existing data and layout. - Do not claim success until you read back the written cells. ## Required Workflow ### Step 1: Inspect workbook structure Start with: - `google_sheets_get` - `google_sheets_worksheets_list` if needed Confirm: - worksheet title - row/column counts - whether there are multiple candidate tabs ### Step 2: Read enough context to find the real headers Read more than one row when structure is unknown. Typical pattern: - `google_sheets_values_get(..., range="Sheet1!A1:Z5")` Look for: - true column labels - helper columns before the real table - title rows,...