Tech Desk
Aug 07, 2024
Recently, Google announced the availability of Gemini AI, a generative artificial intelligence chatbot to generate text based on user prompts, in the side panels of its applications including Docs, Sheets, Slides, and Drive.
Through the side panel, Gemini can assist users and help them to summarise, analyse, and generate content by utilising insights gathered from their emails, and documents without switching tabs.
Gemini can be a game-changer for a data scientist, business analyst, or spreadsheet enthusiast, as one can explore it in Google Sheets to get work done in less time. However, Gemini AI in Google Sheets is only available on the web and you cannot use it on iPhone, or Android.
Read more: Google to introduce Gemini on earbuds soon
5 ways to use Gemini AI in Google Sheets
Here are the ways in which you can complete your Google Sheets tasks using the Gemini AI feature.
- To create tables
- To summarise spreadsheet
- To get information from Google Drive
- To create custom template
- To generate formulas
To create tables
You can ask Google Gemini to create tables in Google Sheets by using different prompts. You can follow these steps.
- Visit Google Sheets on the web and open a new spreadsheet.
- Select Gemini in the upper-right corner
- Click Create a Table.
- Enter a prompt such as “Create a table for a 7-day vacation in Greece”.
- Now click Create.
- Check the generated table.
- Click Insert to add it to your spreadsheet.
Google Sheets will create columns such as Day, Date, City, Activity, Time, and Price.
To generate formulas
You can also create formulas for your tasks in Google Sheets.
- Open the spreadsheet in Google Sheets.
- Enter a prompt: Create a formula to count the number of non-empty values in Column B.
- Copy or insert the generated formula into your spreadsheet.
To create custom template
While there are hundreds of Google Sheets templates, you can also ask Gemini to create a custom one according to your needs and preferences. Follow these steps.
- Open a blank sheet in Google Sheets.
- Click the “Help Me Organise” menu in the upper-left corner.
- Enter a prompt: Digital marketing campaign material tracker for a new product launch in the US.
- Select Create.
- Check the final result with relevant columns and entries.
To summarise spreadsheet
Dealing with large spreadsheets is hectic and a time-consuming task, therefore, a user might want to summarise them quickly. For this,
- Open a sheet on the desktop
- Ask Gemini to summarise it, and get a quick overview of the file.
If you find it technical or complex, you can also ask Gemini to explain the spreadsheet in an easy-to-understand language.
To get information from Google Drive
If you want to access details from your Google Docs, Sheets, or Gmail account, Gemini can get you relevant results in no time by retrieving the information and showing the list in the spreadsheet without the need to switch between tabs.
