Start Today! Smart Data Utilization with Google Sheets × Gemini Integration
Hello, this is the official note editorial department for Google's AI, "Gemini."
In this note, we will introduce Google Workspace apps that have become easier to use through integration with Gemini, categorized by service.
This time, we are focusing on how to use it with "Google Sheets."By integrating Google Sheets with Gemini, it has become possible to streamline analysis using data within your sheets. Beyond that, Gemini also supports you in automating report creation using data, generating content from scratch, translating, and answering questions. Furthermore, by working while conversing with Gemini, you might gain new insights you wouldn't have thought of on your own.
In this note, we will introduce ideas for Gemini integration that are useful in business scenarios by making full use of the "Gemini side panel" available within the Google Sheets screen. Experience the power of Gemini to maximize the potential of Google Sheets and accelerate your business!
Let's try using Gemini in Google Sheets
A very useful tool when using Gemini in Google Sheets is the "Gemini side panel." The Gemini side panel is available to those who have a subscription to an eligible Google Workspace, or Google One AI Premium plan.
When you use the Gemini side panel, it can quickly handle tasks such as "creating template tables" or "converting existing data into a spreadsheet."
Also, those using an eligible Google Workspace can select cells or sheets and use "Analyze with Gemini" from the right-click menu.
In this way, not only can you streamline your Google Sheets work, but by analyzing the contents of your sheets, you might generate new ideas. Please try utilizing the Gemini side panel.
6 Ways to Use Gemini to Make Google Sheets More Convenient
From here on, as a practical guide, we will introduce actual ways to use the Gemini side panel.
For example, it makes your daily life more convenient, from business to personal use, such as "comparing and referencing multiple pieces of data in your work" or "checking monthly spending trends based on your household account book."
Leave everything from formula creation to formatting to Gemini
1. Easily create tables from scratch using templates
One of the convenient features of the Gemini side panel is the "Help me organize" feature. When you select "Table" from "Insert" in a new spreadsheet, the "Help me organize" menu will appear in the side panel as shown below. Templates for various scenarios are available, so if you choose one that fits your purpose, the table will be completed instantly.
This time, using this feature, I had Gemini create tables for event tasks, schedules, guest lists, vendor lists, and budgets, and compiled them into a single file. Let's use this table as a base and customize it to fit your own work.
In addition, the following types of tables are available in the Help me organize menu.
Customer tracking: Customer contact info, cases
Project management: Project tasks, resources, office hours
Inventory management: Inventory tracker, vendor list, purchase orders, sales orders
Recruiting: Applicants, job openings, hiring budget
Marketing: Content and campaign tracker, campaign results
Travel Itinerary: Travel plans, budget, and transportation methods
Please feel free to use these according to your needs!
2. Create an original table from your own ideas
Beyond templates, you can also create original tables from scratch based on your own ideas and keywords.
To create a table that better matches your vision, try creating prompts while keeping the following points in mind.
Clearly indicate the types of columns and rows to include in the table
Specifically explain what kind of data you want to enter into the table
If there is a specific format you want to apply, clearly state the formatting requirements
I want to aggregate sales results for a new product. I want to analyze trends based on the purchaser's age, gender, purchase date and time, day of the week, quantity, etc. Create a table template that can record daily sales results.
3. Get the necessary formulas created
You can use Gemini to generate formulas for your spreadsheets.
When you are unsure about "what kind of formula should I use for this calculation?", try consulting the Gemini side panel.
For example, even for tasks like "I want to know the number of stores that had higher sales than last month" or "I want to know the number and percentage of people who paid with electronic money," it will quickly provide the formulas, saving you the trouble of searching for them and helping to streamline your work.
As of March 2025, I want to know the number of stores that had higher sales than last month. Tell me the formula.
Furthermore, if you want to know more about this formula, you can ask an additional question like "Explain that function in simple terms," and Gemini will provide a detailed explanation of the meaning of the function or formula.
Using Gemini to analyze and visualize tables
1. Analyze user trends from the sheet
In business, understanding customer behavior and characteristics is extremely important. However, customer data is often vast and complex, making it difficult to analyze manually. Therefore, have Gemini analyze your customer data and provide concrete advice on which customer segments you should focus on.
Analyze the customer base from this data by attributes such as age, gender, and purpose. Furthermore, give me advice on which segment I should focus on.
2. Get advice from Gemini on analysis methods
Many people may have various data but are unsure about "what kind of analysis should I perform using this data?" Even without specialized knowledge in data analysis, by consulting Gemini, you can find appropriate analysis methods and gain hints for analysis from multiple perspectives. If you are unsure, consult Gemini to streamline your analysis and lead to deeper insights.
What kind of analysis can I perform using this sheet?
3. Analyze free-text survey fields and create a report
Free-text fields in surveys, where you can hear customer voices directly, are a valuable source of information for service improvement and new product development. To maximize the use of survey results, use Gemini to clarify service improvements and issues.
*For the Gemini app, specify the file.
Summarize the comments in the free-text fields by separating them into positive and negative ones.
Furthermore, you can also request a draft report on this survey from Gemini. At that time, by providing detailed instructions such as "structure it into three parts: good points, areas for improvement, and others," "provide suggestions and actions," or "summarize it concisely in a table," you can create a report that better meets your needs.
Create a report based on the survey
・Structure it into three parts: pros, areas for improvement, and other
・Suggest insights and actions to take based on that
・Summarize it concisely in a table
Master the next level of Spreadsheet usage
The integration of Gemini × Spreadsheet has greatly expanded the possibilities for data utilization.
If you are wondering, "How can I perform data analysis?", try consulting Gemini first. For example, by asking "What can Gemini do in Google Sheets?" from the side panel, Gemini will tell you what it is capable of.
Gemini makes data analysis more accessible; for instance, you might discover trends in customer data that you hadn't noticed before, potentially leading to new business opportunities.
Master the next level of Spreadsheet usage and achieve a smarter way of working together with Gemini.
How to use Gemini in Google Sheets is also detailed on the following help page.
Gmail Help "Use Gemini in Google Sheets"
We hope these usage examples are helpful to you.
Also, if you would like to try using the "Gemini side panel" in Google Sheets, please consider subscribing to Google Workspace or the paid Google One AI Premium plan. Both offer free trial periods, so please feel free to sign up.
Google will continue to strengthen the integration between Workspace apps and Gemini. We look forward to introducing new ways to use them as new features supporting Japanese are added, so stay tuned.