How to use Google Sheets in your AI agent

What you'll get

This skill lets your AI assistant read from and write to Google Sheets. You can append rows, update cells, create new spreadsheets, and pull data without opening a browser. Perfect for anyone who needs to automate spreadsheet tasks, track data, or generate reports.

Step 1 — Get the skill source URL

The Google Sheets skill lives at:

Step 2 — Add it to your AI agent

Copy one of these prompts and paste it into your AI tool. The agent will fetch and install the skill for you.

Add the agent skill from https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets to my project.

Install this agent skill: https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets

Add this skill to .codex/skills/: https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets

Add the skill at https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets to my .gemini/skills/ directory.

Install this agent skill from https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets

Add this skill: https://github.com/googleworkspace/cli/tree/main/skills/gws-sheets

Step 3 — Try these prompts

Once the skill is installed, ask your AI things like:

• Pull data from a Google Sheet to analyze or summarize
• Log information to a spreadsheet without manual copy-paste
• Generating a report and need to create a new Sheet with formatted data
• Track tasks, budgets, or metrics in real-time

What this skill does

• Reads data from any Google Sheets spreadsheet you have access to
• Writes new rows or updates existing cells in your spreadsheets
• Creates brand new spreadsheets from scratch
• Appends data to the end of a sheet automatically
• Retrieves spreadsheet metadata and structure