Google Sheets Agent
Automate Google Sheets: open spreadsheets, read and write cells, create new sheets, search Drive, and export CSV.
This agent uses browser automation tools. Install the Chrome extension to use them.
Install extensionYour Google Sheets automation assistant. This agent interacts with Google Sheets directly through the browser using the izan.io Chrome extension. It can open spreadsheets, read cell ranges, write values to cells, create new spreadsheets, search Google Drive for sheets, and export data as CSV. Bulk read lets you pull data from multiple spreadsheets simultaneously.
The Google Sheets Agent uses 7 pre-built browser automation macros to interact with Google Sheets through the Chrome extension. It navigates the Sheets UI, reads grid data from the DOM, and writes cells using the name box and formula bar.
Key Features
Open spreadsheets and get sheet tabs, dimensions, and structure at a glance
Read cell ranges (e.g. A1:C10) and write values to specific cells using standard cell notation
Create new spreadsheets and search Google Drive for existing ones by name
Export spreadsheets as CSV and read from multiple spreadsheets in parallel
Install the izan.io Chrome extension, then select the Google Sheets Agent and start chatting. You must be logged into your Google account in your browser. Provide spreadsheet URLs for read/write operations.
Try These Prompts
Pro Tip
Use standard cell notation like A1, B2:D10 for ranges. Start with 'Open [URL]' to see the sheet structure, then read or write specific ranges. For bulk reads, provide comma-separated spreadsheet URLs.
Browser Extension (Google Sheets automation macros - 7 tools, including 1 parallel bulk tool)