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
• Google Sheets integration enabled at https://app.hyperfx.ai/apps.

How to run the tools in this skill

Every tool in this skill is named by its canonical tool name. Run it with the call your surface gives you:

If a tool is not found: in Hyper chat, find its toolkit id with discover_toolkits and pass it to enable_toolkit. On an MCP client or the CLI, tell the user which integration to connect in Hyper.

Core Rule

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

If the user gave a link, the spreadsheet_id is the part after /d/ in it. If the user gave only a name, call google_sheets_list and take the id whose title matches.

Start with:

• google_sheets_get: it lists every worksheet with its size

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, totals, formulas, blank separators

If the first row contains labels like Total, Notes, or other non-record metadata, do not anchor your write range to that row alone.

Step 3: Build a header map

Map your source fields to actual sheet headers by name, not memory.

Example:

• source field business_name -> sheet header Business Name
• source field contact_email -> sheet header Owner (s) Email

If a required header is missing or ambiguous, stop and ask the user instead of guessing.

Step 4: Choose the safest write strategy

Use:

• google_sheets_values_update for one verified contiguous range
• google_sheets_values_batch_update for multiple verified ranges

Prefer narrow writes over large blanket writes.

There is no append tool. To add rows, read the key column of the table (for example Sheet1!B:B) with google_sheets_values_get; the first empty row is the row after the last one it returns. Write from that row with google_sheets_values_update, in the mapped columns only. The sheet grows to fit by itself.

Write Rules

• Only write columns you have positively mapped.
• Leave unrelated columns untouched.
• When a sheet contains helper columns before the table, start writing at the true mapped column, not column A.
• If a field is intentionally blank, write a blank value only to that verified column.
• Use RAW unless the user explicitly wants formulas or Sheets parsing behavior.

Verification Is Mandatory

Immediately after writing:

1. read back the exact written range
2. inspect at least 2-3 sample rows
3. confirm each field landed under the intended header

If the read-back is misaligned, acknowledge it and correct it before reporting success.

Recommended Tool Pattern

1. google_sheets_get
2. google_sheets_values_get on a header-discovery range such as A1:Z5
3. optional google_sheets_values_batch_get for existing data + destination area
4. google_sheets_values_update or google_sheets_values_batch_update
5. google_sheets_values_get on the written range for verification

Example Mindset

Bad:

• “I saw Business Name near the start, so I will write A2:F51.”

Good:

• “The first visible row includes Total: 7 in column A, while Business Name is actually in column B, so I will map the write range from B onward and verify it after writing.”