New AI functions to "perform actions or answer questions to address a wide variety of scenarios" added to Sheets. The post ...

Google says Gemini does all of this by creating and running Python code, then producing an analysis of the code’s results.