The 5-minute data dashboard: Visualize and analyze with Google Sheets

Laura Mae Martin, Google’s executive productivity advisor, shares ways to work smarter with Google Workspace. If you missed our last post, check out Take prompting to the next level.

Our question comes from Michael, a VP of marketing, who is preparing his end-of-year executive presentation: “I want to show how my team drove positive results. How can Gemini in Sheets help me transform my data into visualizations that tell a clear story for executives?”

Gemini can help you visualize data quickly, leaving you more time to strategize and develop actionable insights. Use it to analyze information and highlight all the ways your team contributed to the bottom line. Get started with these three steps.

1. Aggregate

Highlight your most successful marketing campaigns and compare the return on marketing spend for each channel. First, ask Gemini in Sheets to create a Sheet that consolidates relevant data from files across Google Drive.

• Import all the software sales generated from marketing campaigns in @2025MarketingResults. Then, import the expenses for each marketing campaign using @2025CampaignExpenses.

Once you’ve reviewed the data, create tables that make it easier to dig into the details.

• Create a summary table from the combined data showing the sales, expenses, and calculated ROI for each marketing campaign.

2. Analyze

Before asking your own questions, give Gemini a chance to reflect. You might gain insights you hadn’t considered.

• What trends do you see in this data?

Then, formulate your own questions to identify trends and highlight successes:

• What was the average profit and ROI for each campaign?
• Which marketing channels were the most cost effective?
• How could I reallocate marketing dollars next year to improve performance?

You’re ready to integrate Gemini’s suggestions as you draft a plan for the year ahead.

• Use your suggested budget reallocations to draft a campaign sales forecast and budget for 2026. Assume a 15% increase in our total budget and the same response rates.

Try what-if analyses to determine how campaign changes could impact future profits:

• We’re considering a new email platform that will increase campaign costs by $5,000. We expect the platform to increase software subscription sales by 5%. Simulate what our 2026 email campaign ROI would be with and without the new platform.

3. Visualize your data

Share the story behind the data with easy-to-understand charts and graphs. Map out all your campaign results by channel in one chart. Then, highlight your most successful campaigns. Try prompts like these:

• Build a donut chart to show the percentage contribution of each marketing channel to total sales.
• Build a bar chart that displays the results of the three most profitable marketing campaigns.

Create a visual that supports your request for more social media spending:

• Build a sensitivity table showing how a 10% or 20% increase in social media campaign spend could increase sales.

Not sure where to start? Gemini can guide you.

• I’d like to compare the ROI of each marketing channel. What’s the best chart to use?
• How can I generate a geo chart that displays @NewCustomerLocations on a map?

Tell your story

Now that your dashboard is complete, you’re ready to present your story to the executive team. Use Gemini to draft a high-impact email summary that includes your core recommendations and the key visuals you generated. Then, get help developing effective talking points for your Google Slides presentation. This clear, actionable messaging, supported by data-driven insights, can empower your executive team to make informed, strategic decisions.