How to Use Gemini in Sheets

Google’s latest enhancement to its AI offerings introduces Gemini AI within Google Sheets, providing users with advanced capabilities to manage and organize data through simple prompts. Integrated seamlessly with services like Gmail, Docs, and Slides, Gemini AI transforms the way you interact with spreadsheets.

In Google Sheets, Gemini allows you to create tables, generate formulas, and perform various tasks effortlessly. This guide will demonstrate how to utilize Gemini in Sheets to boost your productivity.

To get started, ensure you’re signed into your Google account and have subscribed to the Google One AI Premium Plan. Once set up, open Google Sheets and either create a new spreadsheet or open an existing one.

Generating Data Using Gemini

On the toolbar, click the ‘Help Me Organize’ button to launch Gemini.

The ‘Help Me Organize’ panel will appear on the right side of your screen.

Enter a prompt like Create a marketing campaign material tracker for a new product launch, then click ‘Create’ or press ‘Enter’.

Gemini will generate the requested data, which you can adjust to suit your requirements.

Summarizing Spreadsheets Using Gemini

Gemini can quickly summarize the data in your spreadsheet, saving you time and effort.

In the ‘Help Me Organize’ panel, type a prompt such as summarize this spreadsheet and press ‘Enter’.

Depending on the amount of data, Gemini will take a few moments to provide a summary of the information.

Creating Tables Using Gemini

With Gemini, you can create tables using simple prompts, streamlining the data organization process.

Click on the ‘Help Me Organize’ button to open the Gemini side panel.

Input a prompt like create a table for a full day team event and click ‘Create’ or press ‘Enter’.

Gemini will generate a table based on your prompt, which you can customize as needed.

Generating Formulas Using Gemini

Gemini can assist in creating formulas, making complex calculations easier to handle.

Open the Gemini panel by clicking the ‘Help Me Organize’ button.

Enter a prompt like create a formula to find cell C1 in range D:G and output value in column G, then click ‘Create’.

Gemini will provide the formula, which you can insert into your spreadsheet.

When prompted after selecting a cell, click ‘Insert’ to add the formula to your spreadsheet.

Note: For all these methods, you can generate multiple versions and refine the outputs until they meet your needs.

Using Smart Fill Suggestions from Gemini

Gemini’s Smart Fill feature provides suggestions when entering data, predicting values based on existing patterns in your spreadsheet. Ensure that Smart Suggestions are enabled to use this feature.

In your spreadsheet, click on the ‘Tools’ menu and select ‘Auto-Complete’ to access smart fill settings.

Make sure ‘Enable Enhanced Smart Fill Suggestions’ is checked. If not, click on it to enable the feature.

Begin entering your data. For example, create a table reviewing various restaurants with a star-rating system.

After inputting ratings for the first few entries, Gemini’s Smart Fill will suggest ratings for the remaining ones based on the patterns identified.

You can choose to accept or ignore these suggestions as you continue to fill in your data.

Note: Currently, Gemini’s Smart Fill works with English text values and requires at least three example rows and two columns with text data. It doesn’t support date or numeric data yet.

By incorporating Gemini AI into Google Sheets, you can significantly enhance your efficiency, allowing for quick data generation, summarization, and formula creation through intuitive prompts. Always ensure your data is accurate to get the most out of Gemini’s capabilities.