google-sheets
Analyze and edit connected Google Sheets with range precision. Use when the user wants to create Google Sheets, find a spreadsheet, inspect tabs or ranges, search rows, plan formulas, create or repair charts, clean or restructure tables, write concise summaries, or make explicit cell-range updates.
- License 许可
- MIT
- 最近更新
- 2026-07-19
- Stars
- ★ 1
- Forks
- 1
01 前言 Front Matter
- name
- google-sheets
- description
- Analyze and edit connected Google Sheets with range precision. Use when the user wants to create Google Sheets, find a spreadsheet, inspect tabs or ranges, search rows, plan formulas, create or repair charts, clean or restructure tables, write concise summaries, or make explicit cell-range updates.
02 资源文件 10
- 参考文档agents/openai.yaml366 B
- 资产文件assets/google-sheets-small.svg1.6 KB
- 资产文件assets/google-sheets.png72.6 KB
- 参考文档references/reference-batch-update-recipes.md8.3 KB
- 参考文档references/reference-chart-recipes.md12.7 KB
- 参考文档references/reference-edit-workflow.md2.2 KB
- 参考文档references/reference-formula-patterns.md4.8 KB
- 参考文档references/reference-import-spreadsheet-to-native-sheets.md2.6 KB
- 参考文档references/reference-live-read-search-safety.md2.3 KB
- 参考文档references/style-profiles.md1.3 KB
03 SKILL.md 正文
Google Sheets
Use this skill to keep spreadsheet work grounded in the exact spreadsheet, sheet, range, headers, and formulas that matter.
Purpose Of This File
This file is intentionally minimal and only covers:
- routing to the right spreadsheet workflow
- stateful operation and mandatory routing to reference files
- live-read/search safety for direct connector calls
Detailed editing, formula, chart, upload, live-read/search, and batch-update rules live in references/.
Latency is not a constraint for this skill, so always read the relevant reference files before performing the task.
If the user has not provided explicit style direction, read references/style-profiles.md and apply the appropriate Google Sheets destination default before authoring workbook formatting.
Default Routing
- New Google Sheets creation: first check whether the
[@spreadsheets](plugin://spreadsheets@openai-primary-runtime)plugin or the$Excelskill is installed. - If either is installed, YOU MUST use
[@spreadsheets](plugin://spreadsheets@openai-primary-runtime)or$Excelto create a local.xlsx. Then import the.xlsxinto Drive as a native Google Sheets spreadsheet. Readreferences/reference-import-spreadsheet-to-native-sheets.md. - If neither skill is installed, create the spreadsheet directly with Google Sheets MCP.
- Existing Google Sheets edits: use Google Sheets MCP directly.
Do not reference the local .xlsx in the final answer. Your final answer includes the Google Spreadsheet link only.
Canonical Workflow Bias
Prefer one simple proven workflow over a large tree of recovery branches. When a task matches a known successful pattern, follow that pattern directly instead of re-evaluating every possible fallback path. Do not let accumulated edge-case guardrails turn a straightforward Sheets task into a long blocker-analysis exercise.
For sheet creation and editing tasks, prefer this sequence when viable:
- Gather the required source material.
- Pick the correct default routing.
- Establish the sheet checklist or sheet plan.
- Build or edit the sheet.
- Verify the sheet is clean, complete, native, and scannable.
- Stop once the verified workflow has succeeded.
If a simple verified workflow is viable, use it. Do not drift into speculative alternate paths.
Required Read Order (No Skips)
If Default Routing uses [@spreadsheets](plugin://spreadsheets@openai-primary-runtime) or $Excel:
- Read the
[@spreadsheets](plugin://spreadsheets@openai-primary-runtime)plugin skill or$Excelskill - Read
references/reference-import-spreadsheet-to-native-sheets.md
If Default Routing uses connector edit workflow:
- Read
references/reference-edit-workflow.md. - Before any direct live range read, cell read, or
search_spreadsheet_rows, readreferences/reference-live-read-search-safety.md. - Read every task-specific file from the matrix below.
- If the task spans multiple categories, read all matching files.
- If uncertain, read every file in
references/.
Do not execute content edits until the required references are read in the current turn.
Final Answer Requirement
If the [@spreadsheets](plugin://spreadsheets@openai-primary-runtime) plugin or the $Excel skill is installed, you MUST use one of them to create a local .xlsx and import it to Google Drive with upload_mode: "native_google_sheets".
Even though you created a local .xlsx, do not cite the local path in the final answer. The final answer cites only the Google Spreadsheet link.
Connector Load Checklist
- Confirm the exact target Google Sheet URL or spreadsheet id before editing an existing spreadsheet.
- If the user only gives a title or title keywords, use the connector/app search path to identify candidate spreadsheets before asking for a URL.
- Resolve and record the spreadsheet id, target sheet names, and
sheetIdvalues. - Read spreadsheet metadata before deeper reads or writes.
- For direct live range reads, cell reads, or
search_spreadsheet_rows, use exact visible tab names from metadata, bounded ranges, and the recovery rules inreferences/reference-live-read-search-safety.md. Do not guessSheet1, scan whole grids, or retry oversized row searches. - Before each edit pass, identify the exact sheet, range, headers, formulas, and validation constraints being edited through connector reads.
- Re-read target cells before writing when live values, formulas, formatting, or validation could affect the write.
Task To Reference Map
| Task area | Required reference file |
|---|---|
| Existing spreadsheet edit workflow, grounding, validation-backed cells, output conventions, and write planning | references/reference-edit-workflow.md |
| Direct live range reads, cell reads, row searches, tab/range recovery, and oversized search avoidance | references/reference-live-read-search-safety.md |
Raw Sheets write shapes and example batch_update bodies |
references/reference-batch-update-recipes.md |
Importing a locally created .xlsx, .xls, .ods, .csv, or .tsv into Google Sheets |
references/reference-import-spreadsheet-to-native-sheets.md |
| Formula design, repair, rollout, or syntax refresh | references/reference-formula-patterns.md |
| Chart creation, repair, chart-spec recall, or repositioning | references/reference-chart-recipes.md |
| Unspecified styling for native Google Sheets destinations | references/style-profiles.md |
04 同仓库更多 Skills
Zotero
Use Zotero Desktop from Codex to enable/probe the local API, search a local Zotero library, list items/collections/tags, export BibTeX, insert citation keys into LaTeX or Markdown drafts, read indexed full text when requested, and import BibTeX/RIS records into Zotero through the connector server. Use when the user mentions Zotero, citations, references.bib, BibTeX export, local Zotero API, localhost:23119, or adding citations from a Zotero library.
zoom-apps-sdk
Use when using Apps SDK.
youtube
Obtain accurate, timestamped YouTube video transcripts (preferring manual captions over auto-generated) as the primary deliverable, then derive summaries, key claims, or notes from that transcript. Use when the user provides a YouTube URL (or video ID) and wants the transcript, a faithful summary, key claims with attribution, timestamped notes, or "what does this video actually say". The skill is transcript-first: never substitute metadata, title, description, or search snippets for the spoken content. Triggers: "youtube transcript", "get the transcript of this video", "summarize this youtube video", "what did they say in https://youtube.com/...", "key claims from this talk".
yeet
Publish local changes to GitHub by confirming scope, committing intentionally, pushing the branch, and opening a draft PR through the GitHub app from this plugin, with `gh` used only as a fallback where connector coverage is insufficient.
x-post-creator
Create X-ready post threads and co-located story packages from the active conversation or referenced project material. Use when the user says turn this into an X-post, /x-post, make this into an X thread, or wants plain-language social posts with supporting images saved to docs/x-posts/[story-name]/.
x-api
Search, read, and write X posts through the local X API MCP server (the same backend used by the Codex x-api skill). Use for searching X/x.com, reading threads and replies, creating lists, staging/publishing posts for @alltheputs, finding high-visibility reply targets for research outreach, ingesting public context, or any request that mentions /x-api or "search X".