I stopped downloading productivity apps after pairing Gemini with Google Sheets

I used to download a new productivity app whenever I wanted to organize something.

One app for budgeting, another for meal planning, another for tracking projects, and another for managing subscriptions.

Eventually, I realized I already had a tool that could do most of those jobs: Google Sheets.

The problem was that building spreadsheets from scratch could be time-consuming.

After I started using Gemini in Google Sheets, though, creating trackers, planners, and dashboards became as simple as describing what I wanted in plain English.​

Related

9 unique ways to use Google Sheets beyond number crunching

Think outside the cell

Posts 4
By  Parth Shah

Gemini removes the hardest part of using spreadsheets

Every new spreadsheet meant deciding how to structure it, creating columns, writing formulas, adding dropdown menus, applying conditional formatting, and building charts.

Even a simple budget or habit tracker could take too long to set up.

Gemini removes much of that busywork. Instead of manually building a spreadsheet, you can describe your requirements.

For example, you might ask Gemini to create a monthly budget with automatic totals and charts, build a project tracker with status dropdowns, generate formulas to calculate expenses, summarize trends in your data, or explain why a formula isn't working.

It can also create pivot tables, apply conditional formatting, build charts, and organize your data without requiring you to remember where every option lives or how every function works.

Getting started is straightforward, provided you have access to Gemini in Google Sheets. The feature is available to eligible Google Workspace customers and Google AI plan subscribers.

You must open a spreadsheet on your computer and click the Ask Gemini button in the upper-right corner to access the side panel.

Then, you can choose one of Google's suggested prompts, describe what you want to create, or specify the changes you'd like to make.

Gemini generates the requested tables, formulas, charts, or edits directly in your spreadsheet.

My budget tracker replaced a dedicated budgeting app

One of the first things I asked Gemini to create was a monthly budget tracker.

In the past, I probably would have downloaded a dedicated budgeting app.

Instead, I described exactly what I wanted, and Gemini built the foundation for me in seconds.

The prompt I used is:

Create a monthly budget tracker with separate sections for income and expenses.
Add columns for Category, Budgeted Amount, Actual Amount, and Difference, and calculate the remaining budget automatically.
Include a dashboard with charts showing spending by category and total monthly expenses.
Highlight categories where I've gone over budget, and add a section summarizing my total income, total expenses, and remaining balance.

If I decide I want to track subscriptions separately or add a savings goal, I ask Gemini to update the spreadsheet.

It can modify existing sheets, add new tables or formulas, and even create charts as my budget evolves, making Google Sheets feel like a budgeting app built specifically for me.

Travel planning became much easier

Planning a vacation usually involves dozens of browser tabs.

I have flight confirmations in one tab, hotel bookings in another, restaurant recommendations saved elsewhere, and a growing list of places I want to visit.

Instead of scattering that information across several apps, I asked Gemini to build a travel planner in Google Sheets that keeps everything in one place.

Here's the prompt I used:

Create a travel planner for my trip with separate sections for flights, accommodation, daily itinerary, transportation, budget, packing list, and important reservation details.
Add columns for dates, times, confirmation numbers, estimated costs, and notes.
Include a dashboard for my total trip budget and daily spending.
Additionally, add checkboxes to track completed activities and packing items.

This way, the planner will align with my personal style of organizing trips rather than following someone else's template.

Everything stays on one spreadsheet, and I don't need to install another app to keep my itinerary organized.

Gemini finally made formulas approachable

Formulas were the biggest reason I avoided building more advanced spreadsheets.

I could usually find the right function with a Google search. However, remembering the syntax or figuring out why a formula wasn't working often took longer than the task itself.

Gemini makes things simpler.

For example, I might ask it to calculate my monthly spending by category, count completed tasks, or look up a value from another table.

Gemini generates the appropriate formula, explains how it works, and inserts it into the spreadsheet if I want to.

It can also build pivot tables, apply conditional formatting, create charts, and troubleshoot formulas that return errors, making Google Sheets much more approachable for people who don't use spreadsheets every day.

Related

I created an entire presentation using Gemini in Google Slides, here is how it went

From idea to finished presentation

Posts 4
By  Parth Shah

Gemini in Google Sheets simplifies everyday planning

One of the biggest surprises after using Gemini in Google Sheets is how useful it is for everyday planning.

Whether I'm planning meals for the week, tracking household chores, managing subscriptions, or creating a reading list, I no longer instinctively search the Play Store for another productivity app.

Instead, I start with Google Sheets.

The best part is that I don't have to begin with a blank spreadsheet, since the one generated with Gemini is flexible enough to do exactly what I need.