Sheets: write cells

Write a 2D block of values into one tab of a Google Spreadsheet, top-left at startCell (clears the target rectangle first). Returns range, rows, cols, saved. Gotcha: values are parsed per the spreadsheet locale ("1.5" in a FR sheet becomes 1 May; prefix ' to force text); leading = enters a formula; in-cell newlines are dropped; needs edit rights.

Version 5 (6/12/26, 8:39 AM)

Author Reduck AI - @reduck

Output

values required

2D row-major block. null/"" leaves the (pre-cleared) cell empty. "=..." enters a formula.

spreadsheetId required

Spreadsheet id or any full docs.google.com spreadsheet URL

gid optional

Tab gid (from sheets_list_tabs). Default 0.

startCell optional

Top-left cell in A1 notation, e.g. "B2". Default "A1".

Output

cols required

rows required

range required

A1 range that was written (and pre-cleared)

saved required

true once the editor's POST /save returned 200