Google’s AI assistant, Gemini, can assist you in several ways in Google Sheets, from analyzing your data to helping you edit your spreadsheet faster. In Google Sheets, you mostly use these genAI tools through the Gemini sidebar. But you can also trigger Gemini to take action through a formula inside a cell. It also automatically performs actions in the background to provide suggestions. To use Gemini within Google Sheets, you need to be subscribed to a Google Workspace Business Standard, Business Plus, or Enterprise plan or a Google AI plan . Alternatively, you can sign up for Google Workspace Labs with a free Google account. Note: If you use Google Workspace at work, your administrator may need to enable permission for Gemini to be used in Google Sheets. This quick guide will go over the major ways you can use Gemini in Google Sheets. If you’re new to Google Sheets or need a refresher, see our Google Sheets cheat sheet first to get up and running. In this article: Generate analyses, insights, or summaries Generate charts, graphs, or other data visualizations Generate formulas Quickly edit or format your spreadsheet Use a formula inside a cell to prompt Gemini Use Enhanced Smart Fill (or turn it off) As when using any generative AI tool, remember that Gemini can make mistakes or simply make things up , so you should always check its output for accuracy. Start in the Gemini sidebar From the Gemini sidebar , you can prompt Gemini to take several actions on your spreadsheet, such as adding information to it, providing analysis about it, or even editing it for you. In the top-right corner of Google Sheets, click the Gemini icon, a nova star located between the Share button and your Google user account pic. The Gemini sidebar will open to the right of your spreadsheet. Now that you have it opened, you can type prompts inside the text box on the sidebar, triggering Gemini to take actions on your spreadsheet. Click the nova star icon at upper right to open the Gemini sidebar. Howard Wen / Foundry As a reminder: You can always enter more prompts to follow up on something that Gemini generated. Examples include: Ask a question about something specific in an analysis that it generated. Tell it to generate a visualization from its analysis. Tell it to explain how a formula that it generated works. Tip: Gemini’s responses are often long, but you can drag the left edge of the sidebar to make it wider and reduce the need to scroll. The first four tips below summarize the major things Gemini can do to your spreadsheet from its sidebar. 1. Generate analyses, insights, or summaries Gemini can extract deep data analyses, insights, or trends from your spreadsheet. Optionally, select the cells that you want Gemini to analyze. This is suggested so that Gemini can give you a more accurate and faster result, especially if your spreadsheet contains a lot of data. Click a table, column, or row, or highlight a cell range. Next, enter your prompt. Examples: Anomalies or outliers: Find any anomalies or outliers in the “Inventory Amount” column for “Product A” row. Correlations: Find any correlation between the “Travel” column and the “Total Revenue” column. Predictions: Predict the net income for the next quarter based on the data in the “Quarter 2” tab. Summaries or takeaways: What are the three key takeaways from this survey data? Gemini will generate a result that appears in the Gemini sidebar. You can ask Gemini to identify key takeaways from your spreadsheet data. Howard Wen / Foundry Additionally, you can have Gemini generate a summary of related material from a source outside your spreadsheet, such as a document in your Google Drive or an email thread in your Gmail: Google Drive document: Summarize the takeaways from the “Q4 Sales 2026” Google Doc in my Drive. Gmail thread: List the action items from my recent email thread with Scot Davenport about “New Client Onboarding Steps.” Gemini can summarize email threads or documents related to your spreadsheet. Howard Wen / Foundry Adding or saving Gemini’s result Click Insert to insert the result on your spreadsheet where your cursor is, Copy to copy the generated text to your PC clipboard, or Export to Docs to save the result as a new document in your Google Drive. You’ll be able to open it in Google Docs. You can click the Analysis steps link that appears above the result to see the steps Gemini took to arrive at its result. There may also be a Sources link below the result. Clicking this will show you the specific files or email threads Gemini used to generate this result. Gemini lists the source(s) it used to generate a result. Howard Wen / Foundry 2. Generate charts, graphs, or other data visualizations Chart creation works best if the data on your spreadsheet has headers for each column or row, such as “Expenses,” “Month,” “Sales,” etc. (This rule also applies if you use the standard way to create a chart in Google Sheets, by selecting Insert > Chart on the menu bar above your spreadsheet.) Your prompt should name the type of chart you want (pie chart, bar chart, etc.), as well as the headers of the columns and rows that you want in it. But don’t be afraid to just ask Gemini to generate a chart from your data without naming headers as an experiment to see what the result might be. Prompt examples: Bar chart (comparison chart): Generate a bar chart that compares Weekly Sales and Product Categories. Complex analysis: Build a stacked column chart that shows Quarterly Profit by Product Category. Line Chart: Create a line chart with the Date on the X-axis and Sales on the Y-axis. Pie chart (distribution chart): Show me a pie chart of the percentage share of Budget by Items. Trend: Identify the key trends in sales so far this year. Gemini will generate a result that appears in the Gemini sidebar. Describe the chart you want Gemini to create, and it will appear in the sidebar. Howard Wen / Foundry You can enter more prompts to trigger Gemini to refine the chart. Examples could include telling it to change the chart type or rename a label in the chart, adding a trend line, or using only the data from certain columns and rows. Adding or saving Gemini’s result Click the Preview button at the bottom of the chart card to see a larger preview of the chart in a panel over your spreadsheet, and if you like what you see, click the panel’s Insert button to add the chart. Or you can skip the preview step and just click Insert below the chart in the sidebar. Either way, a new tab will be added to your spreadsheet with the chart that Gemini generated on it. (For some users, the chart may instead be added to the current tab.) 3. Generate formulas Gemini can generate a formula and insert it into a cell. Prompt examples: Create a formula that averages the values for columns A2 and A6. Generate a formula that adds 7 business days to the dates in the “Deadline” column. Gemini will generate a result that appears in its sidebar along with the steps it took to arrive at the result. Sometimes it may even set up a new column or row and insert the formula into the cells; you can undo this action if you want. Column J contains results based on the generated formula. Howard Wen / Foundry If you don’t understand how a formula works, just ask Gemini to explain it as your next prompt. Adding or saving Gemini’s result Click Insert to set the generated formula or calculated result in the cell where your cursor is, or click Copy to copy it to your clipboard. 4. Quickly edit or format your spreadsheet Gemini can add elements to your spreadsheet or help you edit it. Prompt examples: Add columns or rows: Add a new column with the heading “Expenses”. Checkboxes: Insert checkboxes in the column H1. Conditional formatting: Highlight all Sellers in red whose Total Sales are less than $200. Convert to title case: Convert all the text in the column “Job Titles” to title case. Dropdown lists : Add a dropdown to the cells in the “Status” column with options: “Awaiting,” “In Progress,” “Done”. Extract: Extract the ZIP codes from the “Address” column and put them in the “ZIP Codes” column. Filter : Apply a filter to show rows where the “Progress” is “Done”. Freeze rows/columns: Freeze the first four rows and the third and sixth columns. Pivot tables : Create a pivot table showing the average sale amount by “Person” and “Product.” Remove extra spacing: Remove any extra spacing in this sheet. Sort: Sort the entire sheet by the “Sales Figures” column, from largest to smallest number. Multi-step command: Sort the data by “Employee”. Freeze the header row. Highlight the cells in the “Sales” column that are above 100. Gemini will immediately apply your requested changes to your spreadsheet, and list in the sidebar the steps it took to do so. Gemini can apply conditional formatting in an instant. Howard Wen / Foundry If the changes do not give you the results that you want, simply click the Undo button in the Gemini sidebar. For certain actions such as conditional formatting or pivot tables, a Settings button may appear in the Gemini sidebar after the action is applied. Clicking this will open the Google Sheets settings panel for that feature so that you can make adjustments. Gemini will often suggest additional prompts below the current result, such as creating a chart or asking a question about the data. Click any prompt, and Gemini will generate a response to it. 5. Use a formula inside a cell to prompt Gemini You can use a formula in a cell to trigger Gemini to generate content in that cell that references data in another cell or cell range. You can use this formula to categorize text in cells or even write emails. You can also apply this function across multiple rows. The format for this formula is: =AI(" YOUR PROMPT ", REFERENCE CELL OR CELL RANGE ) YOUR PROMPT is your prompt telling Gemini what you want it to do. REFERENCE CELL OR CELL RANGE is the cell(s) containing the data you want Gemini to reference with your prompt. Examples: Draft emails: =AI(“Write a concise, professional email opening line to the person in A2, referencing their industry in B2”, A2:B2) Extract data: =AI(“Extract only the 5-digit zip code from the address”, B2) Fix text: =AI(“Apply proper capitalization, and remove extra spaces from the name in”, B2) Standardize dates: =AI(“Standardize the date in B2 to YYYY-MM-DD format”, B2) Categorize information: =AI(“categorize amount greater than 80 as ‘Glorious’ and below 80 as ‘Must Improve’, H5”) When you’ve finished typing your formula, press the Enter key. Gemini will process your prompt and generate a result. The result will be inserted into the cell. The rightmost column shows the result of an AI prompt formula (shown in the formula bar at the top). Howard Wen / Foundry If the data in the reference cell / range is changed, the formula result won’t automatically be updated, but you can select the cell that contains the formula and click the Refresh and insert button that appears to update it. Applying your Gemini formula to other cells You can apply this Gemini formula in the cell to the other cells on the rows below it. First, make sure your spreadsheet data is formatted as a table. If it’s not, select all the cells containing data and click Format > Convert to table from the top menu bar. Click the cell that contains the formula. Then click on the bottom-right corner of the cell (you may see a + sign appear) and drag down to apply the formula to the cells below. Gemini will automatically run the prompt inside these cells, referencing the data from each row that they’re on. The formula is now copied into all the rows in the rightmost column. Howard Wen / Foundry 6. Use Enhanced Smart Fill (or turn it off) The Smart Fill feature in Google Sheets is an automation tool that assists you as you work on your spreadsheet. It’s been enhanced to use Gemini to detect patterns in your data. As you enter data in cells, it may offer to fill out subsequent cells for you. For example: After you finish entering values into a few rows, Smart Fill may suggest that it automatically add more rows for you, and supply the values for those cells. This suggestion may be triggered after you do the same task to your spreadsheet three or more times. Smart Fill can suggest autofill values based on Gemini’s analysis of the data you’ve already entered. Howard Wen / Foundry Other Smart Fill behaviors: Categorizing: Analyzing the text in the cells of a column and filling in the cells of an adjacent column with corresponding category names. Extracting: Extracting the ZIP codes from the addresses listed in a column and inserting them into a new column. Standardizing: Converting values in a column that have been entered in inconsistent formats. For example, it can offer to convert both “sept 1st, 2026” and “9/6/26” into a uniform “YYYY-MM-DD” format. A Smart Fill suggestion appears as a faded outline or a bubble showing its predicted range of values. If you want to accept the suggestion, click the outline or checkmark on the Auto Fill notice card. If you don’t want to accept, click the X icon on this card. Turning Enhanced Smart Fill off or on If you find that these Smart Fill suggestions get in your way as you work on your spreadsheet, or simply don’t work well for you, you can turn off the feature. Turning off Enhanced Smart Fill. Howard Wen / Foundry On the menu bar above your spreadsheet, select Tools > Suggestion controls > Enable enhanced Smart Fill suggestions to uncheck it. Select it again to turn it back on (the checkmark reappears). Note: Turning off Enhanced Smart Fill does not disable the basic Smart Fill feature, which doesn’t use Gemini. It uses simpler logic to suggest sequential numbering or extracting text. Related reading: Google Sheets cheat sheet: How to get started 6 quick tips for Google Sheets Google Workspace: 7 great ways to use the Gemini AI sidebar Google Sheets power tips: How to use filters and slicers Google Sheets power tips: How to use pivot tables How to use Google Sheets for project management How to use smart chips in Google Docs and Sheets 4 advanced ‘smart chip’ tips for Google Docs and Sheets Google Workspace power tips: Tap into cross-app productivity More Google Workspace tips and tutorials