Skip to main content

About Gemini for Sheets

Gemini for Sheets is an AI writer and assistant for Google Sheets. It lets you use Google's Gemini as an AI assistant directly in Google Sheets. It is built on top of Gemini Pro — Google's best AI model for scaling across a wide range of tasks.

Gemini for Sheets is extremely powerful at:

Working with textWriting text
  • Refining data
  • Fixing grammar and spelling
  • Extracting entities
  • Tagging and categorizing
  • Translating
  • Taglines, headlines
  • Ad copy
  • Product descriptions
  • Subject lines, emails
  • Outlines, blogposts

Discover Gemini functions​

The add-on offers many Gemini functions for different use-cases. You can discover them by typing =GEMINI_ in a cell.

GEMINI_LIST, GEMINI_FILL, GEMINI_TABLE and GEMINI_SUMMARIZE are particularly well suited to Google Sheets.

Why use Gemini for Sheets instead of Bard(Google's conversational AI) or ChatGPT?​

Bard/ChatGPT is a chatbot interface, which is great to learn and play with Gemini. But you probably do most of your work in real document editors like Google Sheets because your data is already in Google Sheets.

Using Gemini for Sheets will save you a lot of time by allowing you to:

  • Get many variations quickly
  • Apply prompts to Sheets tabular data and get results as tables
  • Organize your prompts within Google Sheets
  • Save answers in Sheets for easier retrieval
  • Avoid constant copy/pasting in Bard/ChatGPT
  • Take advantage of all the features offered by Google Sheets
WHAT'S NEXT
How to get started in Gemini for Sheets™ & Docs™