Skip to main content
The Google Sheets extension allows your agent to interact with Google Sheets — creating spreadsheets, reading and writing cell ranges, appending rows, formatting cells, and managing sheets. It uses standard A1 notation for ranges and is ideal for data entry automation, report generation, and spreadsheet-driven workflows.

​
Setup

If you haven’t set up Google OAuth yet, complete the Google OAuth Setup first.
1

Enable the Google Sheets API

In your Google Cloud project, navigate to APIs & Services → Library, search for Google Sheets API, and click Enable.
2

Install the Extension

ironclaw registry install google-sheets
3

Authorize Access

ironclaw tool auth google-sheets
IronClaw will provide a URL for you to authenticate - remember to follow the auth setup to enable your agent to capture the callback. If possible, it will open a browser window. Once approved, the token is stored securely and refreshed automatically.
If you already authenticated one Google service, you still need to authenticate each additional Google extension separately.

​
Available Actions

  • create_spreadsheet: Create a new spreadsheet with an optional title and initial sheet names
  • get_spreadsheet: Retrieve spreadsheet metadata (title, sheet names, named ranges)
  • read_values: Read cell values from a range using A1 notation (e.g. Sheet1!A1:D10)
  • batch_read_values: Read multiple ranges in a single API call
  • write_values: Write values to a range, replacing existing content
  • append_values: Append rows after the last row that contains data in a range
  • clear_values: Clear all values from a range (preserving formatting)
  • add_sheet: Add a new sheet (tab) to an existing spreadsheet
  • delete_sheet: Delete a sheet by its ID
  • rename_sheet: Rename an existing sheet
  • format_cells: Apply number formats, text styles, or background colors to a cell range

​
Example Usage

Once configured, you can ask your agent things like:
  • “Create a new spreadsheet called ‘Monthly Expenses’”
  • “Read the values from cells A1 to E20 in my budget sheet”
  • “Add a new row with today’s sales data to the ‘Sales’ tab”
  • “Clear all data from the ‘Draft’ sheet”
  • “Rename the first sheet to ‘Summary’”
  • “Format column B as currency in my expenses spreadsheet”

​
Using A1 Notation

All range operations use standard A1 notation. You can include the sheet name to target a specific tab:
NotationMeaning
A1Single cell
A1:C10Range across rows and columns
Sheet1!A1:B5Range on a specific sheet
Sheet1!A:AEntire column A on Sheet1
If your spreadsheet has multiple sheets, include the sheet name in the range (e.g. Budget!B2:D50) so the agent targets the right tab.