Data Analysis
17.5. Data Analysis — Crunching the Numbers
gws sheets get SHEET_ID "Sheet1!A1:D10"
gws sheets update SHEET_ID "Sheet1!A1:B2" --values '[["Name","Score"],["Alice","95"]]'
Chaining multiple steps
Example: the agent finds the latest news about 3 competitors → compiles it → puts it into a report, each step using the result of the previous one.
Notes
- Separate “fetching data” (deterministic script) from “interpreting it” (LLM).
- Sensitive data: use read-only credentials (11.3).
- Save results into Sheets/Docs instead of only answering in chat.