Organize with Gemini in Google Sheets

Important: This feature is available to users on work or school accounts through a Gemini for Google Workspace add-on, and to users on personal accounts through Google One AI Premium. Learn about Gemini features and plans.

This feature is also available through our early access testing program Google Workspace Labs.

On Google Sheets, you can use the “Help me organize” prompt to create tables using artificial intelligence. You can use the prompt to create a new table with generated column headers and example table contents. For example, you can ask Google Sheets to draft a trip planner or a task tracker.

Important: “Help me organize” currently can't be used to edit or refer to existing content in your spreadsheet.

This feature is currently available on desktop.

Use AI to organize and track your data in Sheets

An animation showing someone using "Help me organize" in Sheets to create a project tracker for building a new website

  1. On your computer, open a new spreadsheet or tab in Google Sheets. The Help me organize sidebar will automatically open.
Tip: You can also access Help me organize via the toolbar or Insert menu.
  1. Enter a prompt. For example:
    • “Plan a hiking trip in iceland”
    • “Tracking tasks for a project to build a new website”
    • “Planning a sales kick off event”
Tip: For better results, write instructions instead of questions. For example: "Wedding planner to-do list with status updates and due date".
  1. Click Create.
  2. (Optional) After generating a table, you can:
    • Send feedback about the suggested table: Click Good suggestion for a table that fulfills your request or Bad suggestion for a table that does not meet your needs. 
    • Edit your prompt: At the top of the sidebar, click the prompt. Edit your prompt and click Create.
    • Create a new version of the table: Click Create.
      • Important: After creating a new version, you can’t go back to the previous version.
  3. When you’re finished, in the preview, click Insert.
Tip: For best results, use “Help me organize” in a new tab. If you use the “Help me organize” prompt in a tab that already has data and insert the generated result, it overwrites any existing data it replaces.

Give feedback on a generated table

Gemini for Google Workspace is constantly learning and may not be able to support your request.

If you get a suggestion that’s inaccurate or that you feel is unsafe, you can let us know by submitting feedback.

  1. Below the generated text, click Good suggestion or Bad suggestion.
  2. If you click Bad suggestion , you can select the issue you found and enter additional feedback.
  3. 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 Gemini feature suggestions

  • Gemini feature suggestions don’t represent Google’s views, and should not be attributed to Google.
  • Don’t rely on Gemini features as medical, legal, financial or other professional advice.
  • Gemini features may suggest inaccurate or inappropriate information. Your feedback makes Gemini more helpful and safe.
  • Enterprise end users can submit feedback about their experience using this feature. End users are informed before they submit feedback that the feedback data shouldn’t contain personal, sensitive, or confidential information.
Search
Clear search
Close search
Google apps
Main menu
9507543113415454424
true