Gemini in Sheets Actions

Gemini in Google Sheets can propose and perform spreadsheet-editing actions from natural-language instructions, including formatting, filtering, pivot-table creation, find-and-replace and structural changes to rows and columns.

Recorded characteristics

Function

Gemini in Google Sheets can perform spreadsheet actions from natural-language prompts. Google documents actions including conditional formatting, pivot-table creation, dropdowns and checkboxes, sorting and filtering, find-and-replace, number formatting, inserting/deleting/freezing rows and columns, filling ranges, table formatting and optimisation tasks.

Data access

Gemini can operate on spreadsheet data available within the user's Google Sheets context. Google states that Gemini's access to Workspace data is constrained by the user's underlying access and can additionally be restricted by administrators and content owners.

Actions

Can take actions

External actions

Unknown

Human confirmation

Required

Permission basis

User permissions

Administrative control

Google Workspace administrators can restrict user access to Gemini features and restrict Gemini's access to some or all Workspace data. No additional controls are inferred beyond those documented.

Default state

Not established

Availability

Requires an eligible Google Workspace or Google AI plan. Additional availability limitations apply as documented by Google.

Licensing

Eligible Google Workspace or Google AI plan required. Specific plan coverage is as documented by Google.

External model or provider

Google Gemini.

Limitations and uncertainty

This record concerns Gemini's documented spreadsheet actions in Google Sheets. Broader Gemini, Gemini app, connector or other Google Workspace capabilities are not attributed to this record. External-action capability and default state remain unestablished.

Evidence

• Collaborate with Gemini in Google Sheets

  Supports: Function · Actions · Human confirmation · Availability · Licensing · External model · General · Primary source

  Google documents natural-language spreadsheet actions including conditional formatting, pivot tables, dropdowns and checkboxes, sorting and filtering, find-and-replace, number formatting, inserting/deleting/freezing rows and columns, filling ranges, table formatting and optimisation tasks.

  Gemini performs the documented spreadsheet-editing actions within Google Sheets.

  Google documents that Gemini generates an action preview card containing the proposed action and the user clicks Apply before the action is performed.

  Google documents that the feature requires an eligible Google Workspace or Google AI plan.

  Google documents that an eligible Google Workspace or Google AI plan is required.

  Google documents the feature as powered by Gemini.

  Primary Google support documentation for collaborating with Gemini in Google Sheets.

• What controls Gemini's access to Workspace data

  Supports: Data access · Permission basis · Admin controls · Primary source

  Google states that Gemini has the same access to Workspace data as the user, subject to additional administrator and content-owner restrictions.

  Google states Gemini's access to Workspace data is constrained by the user's underlying access.

  Google documents that Workspace administrators can restrict user access to Gemini features and restrict Gemini's access to some or all Workspace data.