Google Sheets can now handle complex AI commands

Google has upgraded its Gemini AI in Sheets to now handle complex, multi-step tasks from a single instruction. According to an official blog post by Google regarding the upgraded feature, users no longer need to give several separate commands to complete a complicated job.

For example, a user can now ask Gemini to "delete all the old archived rows, add a new 'Team' column with a dropdown menu, and then create an 'Updated Due Date' column" - and Gemini will understand and perform all of these actions at once.

This allows for advanced data cleaning and formatting in plain language. Other tasks Gemini can now do in one go include building a project tracker with formulas and dropdowns, or cleaning a sales report by removing old data and highlighting top performers, says Google.

The tool has also been given more abilities, like creating pivot tables, adding filters, and filling cells with formulas, adds Google in the post. The feature is available for Google Workspace business and enterprise customers, as well as for educational users with the Google AI Pro add-on. Users can find Gemini in the side panel of Google Sheets.