The "Fill with Gemini" Feature is Finally Here for Google Sheets

Let’s be honest: nobody actually likes manual data entry. Spending your afternoon copy-pasting tracking numbers or trying to remember how to write a complex REGEX formula isn't exactly living the dream.

Google Sheets is officially doing the heavy lifting for us. The new Fill with Gemini feature isn’t just a fancy shortcut; it’s basically like having a data scientist sitting inside your spreadsheet. Instead of you telling the computer how to do something with code, you just show it what you want, and it handles the rest.

How to Use Your New Superpower

There are two ways to get this moving. If you’ve already started a list, just grab the new "sparkle" handle at the bottom of your selection and drag it down Gemini will look at your examples and finish the job. If you’re starting from a blank slate, you can just highlight a range, hit the "Fill" button, and type in a plain-English request like, Format these dates to be readable.

4 Ways to Save Your Sanity

1. The Clean Up the Mess Style (Extraction) Ever had a column of messy data where you only need one piece of info? Maybe it’s pulling names out of messy email addresses or grabbing specific model numbers from a paragraph of text. Gemini "sees" the info you want and plucks it out, saving you from an hour of deleting extra characters.

2. The Sort My Life Style (Categorization) If you have a thousand customer reviews and need to know which are happy and which are not, Gemini can read them for you. It understands the vibe of the text, so it can tag entries as "Positive," "Neutral," or "High Priority" without you reading a single line.

3. The Make it Pretty Style (Transformation) Data is usually a mess when it arrives. Gemini can take a list of phone numbers that are all formatted differently and snap them into one consistent look. It’s perfect for fixing wonky capitalization or standardizing company names so your pivot tables actually work.

4. The Personal Touch Style (Drafting) This is the real game-changer. If you have a list of customers and what they bought, you can ask Gemini to write a custom, one-sentence thank-you note for each one. It uses the data in the sheet to make each row unique, making high-scale outreach feel a lot less like a robot wrote it.

Is it actually good?

Google says it's about 9 times faster than doing it by hand. While it's incredibly smart, it’s still worth doing a quick "vibe check" on the first few cells it generates to make sure it caught your drift. It’s currently available for most Workspace Pro accounts and Google One AI Premium users, so go ahead, give your "Control+C" keys a well-deserved break.