How to use Gemini in Google Sheets in 2024

Knowing how to use Google Gemini can give you a deeper understanding of how AI works. Gemini is Google’s answer to ChatGPT and Microsoft Copilot, and it’s an upgraded version of the earlier experimental chatbot Bard.

Built on the advanced Gemini AI models, it’s constantly being updated with new features like image generation and the ability to run code.

Originally a text-only chatbot, Gemini is now a full-fledged Google product, integrated into Google Workspace, Android, and also available as a standalone tool.

While Gemini is impressive, it’s still a work in progress and can make mistakes or generate some strange responses. However, it’s a big improvement over the earlier Bard models.

Gemini comes in both free and paid Advanced versions. The free version lets you create images, write stories, compile to-do lists, and even generate code. Let’s dive into how to sign up for Google Gemini and how to use it once you’re set up.

Before You Start

Integrating Gemini with Google Sheets enables you to handle thousands of cells simultaneously. By prompting Gemini with your instructions, the Sheets add-on executes them, neatly organizing the output in rows and columns. Additionally, using the familiar Google Sheets interface eliminates the need to switch between different apps. Google Sheets is already excellent for teamwork, allowing real-time collaboration. With the Gemini for Sheets add-on, this collaboration becomes even more productive.

Demo Gemini for Google Sheets

How to Install Gemini for Sheets Add-On

Go to the Gemini for Sheets Add-On on the Google Workspace Marketplace.
Click Install.

Confirm any required permissions to proceed with the installation of the Gemini for Sheets add-on.

Once installed, you can access the add-on from the Extensions menu in any Google spreadsheet. Gemini is now integrated with Google Sheets and can be used for writing copy, translating, classifying text, extracting entities, web searching, and many other tasks, all in bulk and directly from Google Sheets. The available AI models include Gemini, Claude, Perplexity, GPT-4, GPT-4 Turbo, and GPT-3.5 Turbo.

Key features of Gemini for Google Sheets

Gemini is available in hundreds of countries and supports English, Japanese, and Korean. Some features are currently only available in English, but this is changing as Gemini expands worldwide.

Go to gemini.google.com

Head over to gemini.google.com. This will also be your go-to URL to access the tool once you’re in. You can also find it in the Google app on Android, inside the Google app on iOS, and within Google Workspace apps like Docs or Sheets.
Sign in

Click the “Sign in” button. You’ll need a Google account, and it must be confirmed for a user over 18.
Accept Google Gemini Terms of Service

You’ll need to accept the Google Gemini Terms of Service. Click “More,” then on the next page, click “I agree.”
Start using Google Gemini

You’re almost there! Click “Continue,” and you’ll be taken to the Gemini page. This will be the first thing you see whenever you go to gemini.google.com.

How to Use Google Gemini

Once you have access to Google Gemini, here’s how you can start exploring its features:

Visit https://aistudio.google.com/app/apikey

Head over to gemini.google.com, and you should be immediately taken to the AI tool. If not, double-check that you have been granted access.

Enter a query or search term

Type a question or search term into the search box and hit enter.
Wait for a response

Gemini will process your query and generate a response. Enjoy exploring the capabilities of Google Gemini!

Generate Gemini API keys for Google Sheets

You can create your api key at this page: Create Gemini API Keys

🤔️ Need to execute tasks in bulk?