Build or edit entire spreadsheets with Gemini in Sheets

In Google Sheets, you can use Gemini in Sheets to:

• Create new sheets.
• Complete end-to-end tasks on existing sheets.

Use Gemini in Sheets

1. On your computer, open Google Sheets.
2. On the right, the side panel automatically opens with Build.
   • To edit or create a spreadsheet, type your prompt.
3. Optional: Answer clarification questions should they arise.
4. Review the plan and the template outline that Gemini provides.
5. Optional:
   • To add sources, click Add sources.
   • To remove all sources, click Clear.

Things to ask Gemini in Sheets

In the side panel, select one of the suggestions or type your own prompt.

Generate a new sheet

• "Create a sheet to track my monthly expenses with columns for date, category, amount, and notes."
• "Create a table for a project tracker in Google Sheets with columns for task, assignee, deadline, and status."
• "Create a 10-day itinerary for a first-time visitor covering Tokyo, Kyoto, and Osaka."

Complete end-to-end tasks

• "Run a full analysis on the data set to help me make decisions about my business."
• "Create a visual dashboard of this sales data set."
• "Update my budget based on last year's revenue."

Tip: If the request needs more info, follow the prompts to help deliver a more accurate result.

Stop Gemini in Sheets

If you want to cancel and generate a new plan:

• You can press the stop button within the side panel.
• You can submit a new prompt. This restarts the generation process for a new sheet.

Give feedback on generated suggestions

Google Workspace with Gemini is constantly learning and may not be able to support your request. Because feedback may be human readable, please do not submit data that contains personal, confidential, or sensitive information.

If you get a suggestion that's inaccurate or that you feel is unsafe, you can submit feedback. Your feedback can help improve AI-assisted Workspace features and broader Google efforts in AI.

1. At the bottom right of the generated text, click Good suggestion or Bad suggestion .
2. If you select Bad suggestion , you can select the issue you found and enter additional feedback.
   • Optional:
     • To review data that'll be attached with your feedback, at the bottom, select the data.
     • If you don't want to include the data with your feedback, to help us improve the product experience, uncheck the box next to "Attach collected data to your feedback."
3. Click Next.
4. Review additional context that you can share with your feedback. If you don’t want to include the additional context with your feedback, uncheck the box next to "Additional context."
5. Click Submit.

To provide general feedback on this feature, at the top, go to Help Help Sheets improve.

To report a legal issue, create a request.

Learn about Workspace Experiments feature suggestions

• Workspace Experiments feature suggestions don't represent Google's views, and should not be attributed to Google.
• Don't rely on Workspace Experiments features as medical, legal, financial or other professional advice.
• Workspace Experiments features may suggest inaccurate or inappropriate information. Your feedback makes Workspace Experiments more helpful and safe.
• Don't include personal, confidential, or sensitive information in your prompts.
• Google uses Workspace Experiments data and metrics to provide, improve, and develop products, services, and machine learning technologies across Google.
• Your Workspace Experiments Data may also be read, rated, annotated, and reviewed by human reviewers. Importantly, where Google uses Google-selected input (as described in the Privacy Notice) to generate output, Google will aggregate and/or pseudonymize that content and resulting output before it is viewed by human reviewers, unless it is specifically provided as part of your feedback to Google.

How Workspace Experiments data in Google Sheets is collected

When you use Gemini in Google Sheets, Google uses and stores:

• Prompts you enter or select.
• Generated content.
• Google Workspace content that you have access to and is referenced for content generation. This includes both Google selected and user provided input.
• Your feedback on the Gemini in Sheets side panel.

To understand how this data is used, review the Google Workspace Experiments Privacy Notice and Terms for Personal Accounts.

Related resources

• Get started with Google Workspace Experiments
• Collaborate with Gemini in Google Sheets
• Learn about prompts for Gemini in Docs, Sheets, Slides, Vids & Forms