Google 表格
AI 操作表格的工具——读取、写入、格式、筛选、图表和保护——让结果落在团队审核的地方。
一句话
亚马逊和 noon 工具本身从不写入表格。当你在 Google 表格里工作时，AI 用这些工具把结果记录到表格中，包括表头、格式、筛选和下拉菜单。你在表格里审核、修改，然后说“把我改过的行提交”。
AI 如何使用表格
读取已有内容
list_sheet_tabs 和 get_sheet_metadata 显示工作簿结构；read_sheet 读取一个区域，get_sheet_cell 读取单个单元格及其下拉菜单和批注，get_sheet_notes 读取标签页的批注。
写入结果
write_sheet 写入一块数据，append_sheet_rows 在末尾追加行，write_sheet_formula 写入公式，import_sheet_tsv 导入整份报表。setup_sheet 和 add_sheet_tab 新建标签页。
让它易读
format_sheet_range、set_sheet_number_format、freeze_sheet_panes、autofit_sheet_columns 和 apply_sheet_table_style 负责格式；add_sheet_conditional_format、add_sheet_chart 和 insert_sheet_sparkline 添加可视化。
变成工作台
add_sheet_dropdown 把亚马逊的取值放进下拉菜单，create_sheet_filter 和 sort_sheet_range 排列行，protect_sheet_range 锁定不该编辑的区域。其他需求用 sheet_batch_update 兜底。
可以这样问
“读取我 Sales 表格里的数据。”
“把 listings 表的表头行加上格式、冻结，并加筛选。”
读取区域的两种调用方式
同一个工具、同样的参数——通过 AI 客户端，或者从你自己的代码。
MCP——你说：“我的 Sales 标签页 A1:F20 里是什么？” AI 调用 read_sheet。
在 AI 客户端中（MCP）
{
"name": "read_sheet",
"arguments": {
"spreadsheet_id": "<your spreadsheet id>",
"range_": "Sales!A1:F20"
}
}在代码中（Tool API）
curl -X POST https://api.sellersheetai.com/api/v1/tools/read_sheet \
-H "Authorization: Bearer $SELLERSHEET_API_KEY" \
-H "Content-Type: application/json" \
-d '{"spreadsheet_id":"<your spreadsheet id>","range_":"Sales!A1:F20"}'抢先体验 — 如需 Tool API 访问，请 联系我们.
这些工具会改动你的表格
写入和格式工具改动的是你指定的工作簿——不会改动你的亚马逊账户。表格必须是你的 Google 账号能打开的。
本页用到的工具
构建时从工具目录读取，每个工具带有自己的权限标签。
| 工具 | 权限 | 作用（英文） |
|---|---|---|
add_sheet_chart | write | Insert a native Google Sheets chart over a range of data. |
add_sheet_conditional_format | write | Add a conditional formatting rule to a range: a boolean rule (the default) that formats the cells meeting a condition, or a 2- or 3-stop colour gradient. |
add_sheet_dropdown | write | Set, replace or remove the dropdown on a range — the one dropdown tool. |
add_sheet_named_range | write | Add a new named range. |
add_sheet_tab | write | Add a new tab to the spreadsheet. |
append_sheet_rows | write | Append rows below the last non-empty row of the columns in range_. |
apply_sheet_table_style | write | Style an already-written range as a table: a bold, coloured, centred header row, alternating row bands, thin grey borders and a frozen header. |
autofit_sheet_columns | write | Auto-resize columns to fit their content — wraps Sheets `autoResizeDimensions`. |
clear_sheet_range | destructive | Clear the values in a range. |
collapse_sheet_group | write | Collapse (collapsed=True) or expand the row or column groups that lie inside range_. |
copy_sheet_format | write | Copy formatting only (no values) from source range to target range. |
copy_sheet_tab | write | Copy a tab, with all its formatting, into another spreadsheet (or the same one). |
create_sheet_filter | write | Create a filter view on a range: a named, saved filter anyone can open from Data > Filter views without touching the tab's one basic filter (set_sheet_basic_filter sets that). |
delete_sheet_named_range | destructive | Delete a named range. |
delete_sheet_tab | destructive | Delete a tab from the spreadsheet. |
find_replace_in_sheet | destructive | Find and replace text in a sheet. |
format_sheet_range | write | Set the fill colour, font colour, bold and font size of a range. |
freeze_sheet_panes | write | Freeze rows and/or columns in a sheet. |
get_sheet_cell | read | Read everything about a cell or a small range in one call: value, formula, format, note, hyperlink and dropdown. |
get_sheet_links | read | Get hyperlinks from a range. |
get_sheet_metadata | read | Get the spreadsheet's metadata: title, locale, time zone and every tab's properties. |
get_sheet_named_range | read | Get a specific named range. |
get_sheet_notes | read | Get notes from a range. |
group_sheet_rows_cols | write | Group rows or columns (creates a collapsible [+] toggle in the sheet). |
hide_sheet_rows | write | Hide rows in a sheet, or show hidden rows again. |
import_sheet_tsv | destructive | Server-side parse + write of TSV (tab-separated) text. |
insert_sheet_rows_cols | write | Insert rows or columns in a sheet. |
insert_sheet_sparkline | write | Insert an in-cell SPARKLINE chart by writing the formula for you. |
list_sheet_named_ranges | read | List all named ranges in the spreadsheet. |
list_sheet_tabs | read | List all tabs in the spreadsheet. |
merge_sheet_cells | destructive | Merge cells in a range. |
paste_sheet_with_format | destructive | Write values AND apply uniform format to the same range — saves a round-trip vs calling write_sheet then format_sheet_range. |
protect_sheet_range | write | Protect a range from editing. |
read_sheet | read | Read cell values from a range. |
read_sheet_format | read | Read cell formatting from a range. |
rename_sheet_tab | write | Rename an existing tab. |
resize_sheet_columns | write | Resize columns in a sheet. |
resize_sheet_rows | write | Resize rows in a sheet. |
set_sheet_basic_filter | write | Set a basic filter (column dropdown arrows) on a header row range. |
set_sheet_borders | write | Add cell borders to a range. |
set_sheet_number_format | write | Set number format for a range. |
setup_sheet | write | Create a tab if it is missing, write a key row and a label row, and format them. |
sheet_batch_update | destructive | Apply several raw Sheets API v4 requests (spreadsheets.batchUpdate) in one call. |
sort_sheet_range | destructive | Sort a range by specified columns. |
ungroup_sheet_rows_cols | write | Remove a row/column group (ungroup). |
unmerge_sheet_cells | write | Unmerge cells in a range. |
unprotect_sheet_range | write | Remove protection from a range. |
update_sheet_note | write | Update note on a cell or range. |
write_sheet | destructive | Write a 2D block of values to a range; every cell is parsed as if typed (USER_ENTERED). |
write_sheet_formula | destructive | Fill one formula into a cell — or across EVERY cell of a range. |
常见问题
有教 AI 做好表格的技能吗？
有——sellersheet-sheets（建表、格式、实时数据）和 sellersheet-dashboard（多标签页看板）。见安装技能。
Google 表格插件呢？
插件的按钮在表格内运行各自的流程——见插件按钮。Docs 和 Drive 有各自的页面：Google 文档、Google 云盘。