Menu
Google Sheets: Read and write spreadsheets via the Sheets API v4.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Use this skill when expanding the scraper network to new Florida counties. Contains the 67-county expansion roadmap, prioritization framework, site reconnaissance procedure, and lead analysis strategy. The goal is total Florida coverage for maximum bail bond lead generation.
Use this skill when creating a new county arrest scraper, modifying an existing solver, or adding a new county to the scraping pipeline. Contains the canonical architecture, naming conventions, and integration checklist.
Non-negotiable rules, safe refactoring patterns, shared code modification guidelines, secrets management, config hierarchy, and schema change process for the swfl-arrest-scrapers repo. Read this before modifying any core infrastructure.
Testing patterns, fixture guidelines, parser test templates, smoke tests, and red-green TDD methodology for the scraper pipeline. Use when writing tests for new counties, verifying core/ changes, or debugging test failures.
Systematically strengthen scraper pipelines against network failures, anti-bot measures, data edge cases, and real-world brittleness that breaks idealized scraper designs.
Performance optimization patterns for Python scraper pipelines — connection pooling, memory efficiency, async I/O, and batch operations for high-throughput data ingestion.
| name | gws-sheets |
| description | Google Sheets: Read and write spreadsheets via the Sheets API v4. |
| metadata | {"version":"0.22.5","openclaw":{"category":"productivity","requires":{"bins":["gws"]},"cliHelp":"gws sheets --help"}} |
PREREQUISITE: Read
../gws-shared/SKILL.mdfor auth, global flags, and security rules. If missing, rungws generate-skillsto create it.
gws sheets <resource> <method> [flags]
| Command | Description |
|---|---|
+append | Append a row to a spreadsheet |
+read | Read values from a spreadsheet |
batchUpdate — Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be applied.create — Creates a spreadsheet, returning the newly created spreadsheet.get — Returns the spreadsheet at the given ID.getByDataFilter — Returns the spreadsheet at the given ID with data filtering.developerMetadata — Operations on the 'developerMetadata' resourcesheets — Operations on the 'sheets' resourcevalues — Operations on the 'values' resourceBefore calling any API method, inspect it:
# Browse resources and methods
gws sheets --help
# Inspect a method's required params, types, and defaults
gws schema sheets.<resource>.<method>
Use gws schema output to build your --params and --json flags.
# Our SheetsWriter uses the Sheets API v4 to insert at row 2 (newest first)
from core.writers.sheets_writer import SheetsWriter
writer = SheetsWriter(sheet_id)
result = writer.write_records(records, county="Lee")
# result = {'new_records': N, 'duplicates_skipped': N, 'qualified_records': N}
# Booking_Number + County is the dedup key
# SheetsWriter checks existing Booking_Number column before insert
Each county gets its own tab: Lee, Charlotte, Collier, etc.
The Qualified_Arrests tab aggregates high-value leads across all counties.