Skip to content

How can I turn off Google Gemini™ and AI features in Google Sheets™?

Why You Might Want to Turn Off Gemini™ AI Features in Google Sheets™

Google Gemini™ and its array of AI-powered features in Google Sheets™ can offer significant advantages for tasks like creating formulas, generating quick tables, analyzing data, or building charts. The “Ask Gemini” side panel aims to streamline your workflow by providing in-context assistance for these functions.

However, for users engaged in deep work with complex datasets, intricate financial modeling, or detailed data validation, the constant presence and proactive suggestions of these AI tools can become a source of distraction. When you need to maintain intense focus on crafting precise formulas or meticulously reviewing figures, the AI’s interventions might interrupt your concentration more than they help.

The Surprising Solution: It’s Still Hidden in Gmail™!

If you’re looking to create a more focused environment in Google Sheets™ by disabling features like automatic formula suggestions, data insight pop-ups, or the general Gemini side panel, the method is identical—and just as surprising—as it is for Google Docs™. The master switch for these smart features across Google Workspace, including Sheets, is managed within your Gmail™ settings.

Step-by-Step Guide to Disabling Gemini™ in Google Sheets™:

Here’s how to turn them off:

  1. Open Gmail™ on your computer.
  2. Click the Settings icon (the cogwheel ⚙️) in the top right corner.
  3. Select See all settings.
  4. Ensure you are in the General tab (this is usually the default). Scroll down until you find the section titled “Smart features and personalization in other Google products” (the exact wording might vary slightly, e.g., “Google Workspace smart features”).
  5. Within this section, you should see a toggle or a link like “Manage Workspace smart feature settings” or simply options to enable/disable these features.
  6. Toggle off the smart features or personalization options that control features across Google products. This action is what disables Gemini in Google Sheets™. There isn’t a separate “Gemini for Sheets” toggle; it’s a broader control.

(Optional: You might need to refresh Google Sheets or close and reopen your spreadsheet for the changes to take full effect.)

By turning these settings off in Gmail™, you should find that the Gemini integrations, including prompts for creating formulas, automatic data analysis, and other AI-driven suggestions, are disabled in Google Sheets™. This will result in a cleaner interface, allowing for more concentrated and uninterrupted spreadsheet work.

Note: Disabling these smart features in Gmail™ will likely turn them off across other integrated Google Workspace apps where they appear, not just Google Sheets™ and Docs™.

Regain Your Focus for Data Mastery

While AI tools like Gemini™ offer powerful capabilities for data manipulation and analysis, the ability to control their presence is key for maintaining productivity, especially during tasks that require unwavering attention to detail. By following these steps, you can customize your Google Sheets™ environment to minimize distractions and better support your specific workflow.

Happy (focused) spreadsheeting!