How to Use What-If Analysis in Google Sheets with ChatGPT

Running different scenarios is a core part of business planning, but building them in a spreadsheet can feel clunky and slow. Combining the number-crunching power of Google Sheets with the creative intelligence of ChatGPT, however, turns this task from a chore into a dynamic conversation. This article will show you how to use ChatGPT to brainstorm, build, and interpret 'what-if' analysis models in Google Sheets, making your forecasting faster and more insightful.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is What-If Analysis?

What-if analysis is the process of changing the values in cells to see how those changes affect the outcome of formulas on the sheet. It’s a powerful but simple way to explore the impact of different variables on a key outcome you care about, like profit, revenue, or customer acquisition cost.

Most business decisions revolve around "what-if" questions:

• What if we increase our product price by 15%? How does that affect our net profit?
• What if our ad campaign's conversion rate is only 2% instead of the projected 4%?
• What if we hire two new salespeople? At what point do they pay for themselves in new revenue?

By building a model in Google Sheets, you can get concrete answers to these hypothetical questions. Traditionally, this involves setting up all your formulas and then manually plugging in different numbers to see what happens. It works, but it can be slow and often limits the scope of your exploration. This is where AI comes in.

How to Do What-If Analysis in Google Sheets (The Old-Fashioned Way)

Before we bring in ChatGPT, let's look at how to set up a basic what-if model manually. Understanding this foundation is helpful when you start asking AI to build upon it.

Let’s imagine you run a small online store selling coffee mugs. You want to project your monthly profit. Your model needs a few key inputs:

• Units Sold: The number of mugs you expect to sell.
• Price per Unit: The retail price of one mug.
• Cost per Unit: What it costs you to source and ship one mug.
• Fixed Costs: Monthly expenses like software subscriptions, marketing, etc.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Set Up Your Inputs and Outputs

In a blank Google Sheet, lay out your variables clearly. Good organization is your best friend. Put your assumptions (the inputs you'll be changing) at the top.

Create a simple table like this:

Then, in a cell below, label it:

Projected Profit

Step 2: Write Your Formula

Now, calculate your profit. The formula for profit is: Gross Revenue - Total Variable Costs - Fixed Costs.

In cell B7 (or wherever you want the projected profit to appear), use this formula:

=(B2*B3) - (B2*B4) - B5

Press Enter, and you’ll see your projected profit: $9,000.

Step 3: Manually Test Your Scenarios

Change the "Cost per Unit" (cell B4) from $10 to $12. The projected profit (cell B7) instantly updates to $7,400. You’ve just performed a simple what-if analysis. You can change any input value to see its impact immediately.

While this works for a few changes, doing it repeatedly for multiple scenarios or across many variables gets tedious.

Supercharging Your Analysis with ChatGPT

Instead of just using AI to do work for you, think of it as a collaborator. It can help at every stage of the what-if analysis — from brainstorming ideas to building the actual model and interpreting results.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

1. Generate Scenarios and Ask Better Questions

Sometimes the hardest part of forecasting is figuring out which variables matter most. If you're not a finance expert, it’s easy to overlook critical factors. ChatGPT is an excellent brainstorming partner for identifying key levers to pull.

Example Prompt:

I run an e-commerce subscription box business. What are the key variables I should consider in a what-if analysis to forecast monthly profitability? Include some less-obvious assumptions I might be missing.

ChatGPT might suggest obvious ones like price, cost, and ad spend, but also factors like:

• Customer Churn Rate: What if 5% of your subscribers cancel each month instead of 3%?
• Shipping Cost Fluctuations: How does profitability change if courier fees increase by 10%?
• Website Conversion Rate: How many more boxes do we sell if we improve landing page conversions from 2% to 2.5%?

This helps you create more realistic and robust models by stress-testing assumptions you hadn't considered.

2. Build the Google Sheets Model and Formulas for You

Struggling to translate your business logic into formulas? Just ask ChatGPT to do it. Describe what you want, and it will give you a copy-and-pasteable table with correct formulas.

Example Prompt:

Okay, create a table I can paste into Google Sheets for my e-commerce business. I want to analyze how changing the price per unit and monthly ad spend affects my net profit. Inputs needed: Units Sold, Price Per Unit, Cost Per Unit, and Ad Spend. Outputs: Total Revenue, Total Cost of Goods Sold (COGS), Gross Profit, and Net Profit. Please provide exact formulas.

GPT can generate a structured table with your inputs and formulas, saving you from syntax errors and manual setup.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Create Data Tables for Multiple Scenarios at Once

Manually testing many scenarios is tedious. You can have ChatGPT generate entire scenario comparison tables for you.

In our coffee mug example, what if you wanted to see profit impacts of selling between 500 and 1500 units, while testing three different prices? Doing this manually would take ages.

Example Prompt:

Using our coffee mug model (Cost per Unit $10, Fixed Costs $3000), generate a data table. Rows should show 'Units Sold' from 500 to 1500 in steps of 100. Columns should show 'Projected Profit' at price points $22, $25, and $28. Show as a copyable table.

GPT will produce a structured table ready to paste into Google Sheets, enabling quick analysis of multiple scenarios.

4. Interpret the Results and Get Recommendations

After your analysis, you might see a table full of numbers and wonder what it all means. ChatGPT can help interpret those results into plain-English insights and actionable advice.

Example Prompt:

Here is the data from my what-if analysis showing profit at different sales volumes and price points: [paste table]. Based on this, answer these questions:

The AI will analyze your data and provide clear answers, turning your spreadsheet into a decision-making guide.

Final Thoughts

Pairing ChatGPT with Google Sheets makes what-if analysis less about getting formulas right and more about asking the right questions. It enables creative brainstorming, faster model building, wider scenario testing, and clearer insights — leading to better, data-informed business decisions.

Even more powerful is connecting your real-time data sources (like Shopify, Google Analytics, or Ads) so you can ask questions in plain English and receive live, interactive dashboards. No setup, no exports, just instant answers.

To see for yourself, try Graphed.