Profile My skills Saved Collections Edit profile Submit a skill

Google Sheets

Manages Google Spreadsheets — list, create, read, write, and append data. Use for budgets, trackers, data tables, and CSV-like operations.

rotoslider d809ec4 3 files · 8.2 KB Updated
Data & Analytics

File contents

Google Sheets

When to Use

  • Find spreadsheets → list_spreadsheets
  • Create new → create_spreadsheet (with optional sheet_names and initial_data)
  • Read data → read_sheet (A1 notation range)
  • Overwrite range → write_sheet
  • Add rows → append_to_sheet

Important

  • After creating, use the returned tab names (not "Sheet1") for read/write
  • Range uses A1 notation: "Sheet1!A1:D10", "Income!A:D"
  • values parameter is a 2D array: [["Name","Amount"],["Rent","1200"]]

rotoslider/choom/tree/main/nextjs-app/skills/core/google-sheets commit d809ec4560

Browse category

Frequently asked questions

npx skillmds@latest add rotoslider/google-sheets