Effortlessly automate data entry in Google Sheets using Fill with Gemini

We're introducing Fill with Gemini in Google Sheets, a new AI-powered feature designed to make data preparation and manual entry even easier. Fill with Gemini infers your intent, allowing you to populate data 9x faster than manual entry for 100-cell tasks.*

Whether you need to extract information from the web or categorize existing data, Fill with Gemini handles the heavy lifting, eliminating the need for complex formulas. For example, a marketing team can use it to automatically generate suggested responses based on customer feedback messages, or a small business owner could use it to quickly fill out product details just by describing what they need.

Fill with Gemini offers two ways to enrich your data, saving you time and effort:

• **Drag-and-drop: **If your column has at least one completed cell, you can use a new drag entry point to fill the column based on the context of the table.
• Prompt-based filling: For empty multi-cell selections, you can use a one-click entry point to "Fill" the range. You can either automatically fill cells when a column has at least one completed cell or write a custom prompt to fit your specific needs.

*Data based on a 95-participant study comparing manual entry against Fill with Gemini on a 100-cell task.

Getting started

• **Admins: **This feature is an entry point to the existing AI function. It will be hidden if the Smart features for Google Workspace setting is disabled. Visit the Help Center to learn more about managing Google Workspace smart features for your users.
• End users: You must have Workspace smart features enabled to use Fill with Gemini. This feature will be ON by default for eligible users. Users can trigger Fill with Gemini by dragging a selection or selecting empty cells to see the prompt menu. Visit the Help Center to learn more about filling columns with Gemini.

Note: Through July 15, 2026, Workspace customers will get promotional access to higher limits for AI function in Google Sheets, allowing users to experiment with these features. Per-user usage limits will apply after that date; we’ll provide more information in the Help Center in advance of updated usage limits going into effect.

Rollout pace

• Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 22, 2026
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 6, 2026

Availability

• Business: Business Standard and Plus
• **Enterprise: **Enterprise Standard and Plus
• **AI Add-ons: AI Expanded Access; AI Ultra Access; Google AI Pro for Education
• **Consumer: **Google AI Pro and Ultra

*Once promotional limits are no longer in effect, users with AI Expanded Access and AI Ultra Access add-on licenses will have higher limits on usage of AI function in Google Sheets.

Resources

• Google Help: Use the AI function in Google Sheets
• Google Admin Help: Set smart features & controls on or off for users