# Google Sheets (https://sellersheetai.com/docs/mcp-api/workflows/sheets)

> Your agent's tools for the sheet — read, write, format, filter, chart and protect — so results land where your team reviews them.



<Callout title="In short">
  The Amazon and noon tools never write to a sheet themselves. When you work in a Google Sheet, your agent records results there with these tools: headers, formats, filters and dropdowns included. You review and edit in the sheet, then say "submit the rows I changed".
</Callout>

## How your agent uses the sheet [#how-your-agent-uses-the-sheet]

<Steps>
  <Step>
    ### Read what is there [#read-what-is-there]

    `list_sheet_tabs` and `get_sheet_metadata` show the workbook; `read_sheet` reads a range, `get_sheet_cell` one cell with its dropdown and note, `get_sheet_notes` the notes on a tab.
  </Step>

  <Step>
    ### Write results [#write-results]

    `write_sheet` writes a block of values, `append_sheet_rows` adds rows at the end, `write_sheet_formula` writes formulas, `import_sheet_tsv` drops in a whole report. `setup_sheet` and `add_sheet_tab` build a new tab.
  </Step>

  <Step>
    ### Make it readable [#make-it-readable]

    `format_sheet_range`, `set_sheet_number_format`, `freeze_sheet_panes`, `autofit_sheet_columns` and `apply_sheet_table_style` format it; `add_sheet_conditional_format`, `add_sheet_chart` and `insert_sheet_sparkline` add the visuals.
  </Step>

  <Step>
    ### Make it a working surface [#make-it-a-working-surface]

    `add_sheet_dropdown` puts Amazon's own values in a column, `create_sheet_filter` and `sort_sheet_range` order the rows, `protect_sheet_range` locks what nobody should edit. `sheet_batch_update` is the escape hatch for anything else.
  </Step>
</Steps>

## Try asking [#try-asking]

> "Read the data from my Sales spreadsheet."

> "Format the header row of my listings sheet, freeze it, and add a filter."

## Reading a range, both ways [#reading-a-range-both-ways]

The same tool and the same arguments — through your AI client, or from your own code.

**MCP** — you ask: "What's in A1:F20 of my Sales tab?" Your agent calls `read_sheet`.

<ToolCall tool="read_sheet" args="{ spreadsheet_id: &#x22;<your spreadsheet id>&#x22;, range_: &#x22;Sales!A1:F20&#x22; }" />

<Callout type="warn" title="These tools change your sheet">
  The write and format tools change the workbook you name — never your Amazon account. A sheet must be one your Google account can open.
</Callout>

## Tools on this page [#tools-on-this-page]

Pulled from the catalog at build time, each with its own access label.

<ToolList domains="[&#x22;sheets&#x22;]" />

## FAQ [#faq]

### Is there a skill for building good sheets? [#is-there-a-skill-for-building-good-sheets]

Yes — `sellersheet-sheets` (sheet building, formats, live data) and `sellersheet-dashboard` (multi-tab dashboards). See [Install the skills](/docs/start/skills).

### What about the Google Sheets add-on? [#what-about-the-google-sheets-add-on]

The add-on's buttons run their own workflows inside the sheet — see the [add-on buttons](/help/sheets/buttons). Docs and Drive have their own pages: [Google Docs](/docs/mcp-api/workflows/docs), [Google Drive](/docs/mcp-api/workflows/drive).