AI Quick Tips 140: Gemini for Google Sheets Upgrayedd

First of all, +1 if you got the joke without looking it up (if not, don’t worry, it was a long shot)

Anyway, Google is changing Gemini in Sheets to be able to provide insights like trends, patterns, and correlations in your data.  And they are also giving it the ability to generate charts.

Historically, Gemini (and Bard) have been pretty bad at analyzing spreadsheets, so this will be a welcomed upgrade.

Google offers some tips to get the best results -

• For the most accurate results, ensure your data is in a consistent format, with clear headers and no missing values. 
• When asking Gemini in Sheets to analyze your data, be as specific as possible in your prompts to ensure Gemini understands your request. 
• For complex analysis, Gemini in Sheet's performance is most consistent in files below 1 million cells. 
• Charts are generated as static images and can be easily inserted into your sheet. 
• Charts are not linked to your sheet data, so they won't update automatically if your data changes. 
• Once inserted, charts cannot be modified. If you need to make changes, you'll need to generate a new chart. 

The rollout for these features is expected to be completed by February 20, 2025.  

I attempted to use the new features but it was not available for our account yet

Here is the link to Google’s post about this - https://workspaceupdates.googleblog.com/2025/01/generate-charts-and-insights-with-gemini-google-sheets.html