App Logo
docs.google.com

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. 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.

Input

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.

Default: 0
startCell optional

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

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

FAQ

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. 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.
Required: spreadsheetId, values. Optional: gid, startCell.
It returns cols, rows, range, saved.
Yes. It acts as you on docs.google.com: on your own Chrome it reuses your session, and on a Reduck-hosted browser it loads the docs.google.com cookies saved by the Reduck extension.
It makes changes on docs.google.com, like sending, posting or booking something.
Ask an AI agent connected to Reduck to run reduck/docs.google.com/sheets_write_cells, or run it from a terminal with the Reduck CLI: npx @reduck-ai/cli@latest run --script reduck/docs.google.com/sheets_write_cells
It is part of Reduck's official curated catalogue.

Related scripts

docs.google.com

Sheets: new spreadsheet

Create a new Google Spreadsheet in My Drive, optionally with a title. Returns spreadsheetId, url, and firstGid (always 0). The file lands in Drive root (My Drive); moving it elsewhere is a Drive action, not a Sheets one.

docs.google.com

Sheets: add tab

Add a tab to a Google Spreadsheet, optionally naming it in the same pass. Returns the new tab's gid and final name. Waits for the editor's save before resolving; needs edit rights.

docs.google.com

Sheets: delete tab

Delete one tab of a Google Spreadsheet by gid. Returns deletedGid and remainingTabs (names left). The sheet's data goes with it (recover via Undo / Drive history); an unknown gid throws rather than risk deleting the wrong sheet; needs edit rights.

Start building not clicking

Get started for free