We are living in a happy time, as ai produces like a tool that is very improving our work. From the introduction of products such as Chatgpt, the start of large languages (LLMS) has basically changed how we are living and how we work.
Google, as a company, will certainly not pass the opportunity to improve its LLM products, as shown by Gemini Model. In addition, Google has already had many useful business products, such as Google sheets. Google made fun of a delicious move by allowing the Gemini to be directly integrated to Google sheets.
As Google's sheets are used by many businesses, it will help understand how to use Gemini Ai inside it. In this article, we will do in the implementation of Gemini with Google sheets.
Want to know? Let's get in!
Google Gemini on Google Sheets
According to the official announcement by Google, the current spreadsheet of AI (Gemini on Google Sheets) is already available to the public, but with Google Workspace registration. Trying, you can consider their prices and use free trial.
Before we try Google Gemini on Google sheets, we need to make it available again, such as default, feature is automatic automatically and requires us to have a Google Workspace admin administration account. Navigate to the controller's dashboard and enable Gemino for Google Workspace by opening alpha features within the generating AI tabs.
When features are enabled, try to create a new Google sheet using your Google Workspace account. After opening a new file, you will see the icon of ** Gemini **, like the picture below.
This is your Gemini Assistant, where you can ask whatever and direct Gemini to do something in Google sheets. If you are not sure what you can do, you can always ask Gemini “what is the gemini that does” in the early age.
For example, we can ask Google Gemini to build a new table and put it on our sheets, matching the picture below.
By referring to existing files or tables in Google sheets, we can ask the Gemini model to an analysis or suggestions. For example, we can ask the Gemini for details on our details and chart suggestions that we grow, as shown in the picture below.
In fact, you can ask whatever Gemini or anything, and the model will suggest or give the acts properly for your job.
Additionally, you can work directly in the Google Sheet Cell Phase using gemini, renovated by =AI formula. The formula currently allows text, summarization, and classification.
This page =AI Formula takes two parameters: Prompt (or instruction) and current selection distance. Let's start by producing a new label using =AI formula. For example, we can try to assign a document name based on the data we have.
=AI("Generate a document name suitable for this row", A2:F2)Then press the “Startup button and Install Insert” button to make formula.
Once =AI The formula is made, you can pull the first lower cells to use it in all the information available. For example, we can produce written words in five different cells, as shown below.
You might look at the rest of the table and use the following formula to summarize the dataset.
=AI("Summarize the data in one line", Table1)The result is a text data such as issuance below.
The table outlines project management approaches, detailing their characteristics, advantages, disadvantages, suitable applications, and risk levels.
This concludes the basic presentation of access and using Gemini model in Google Sheets. You can also check your model how to speed up your data analysis.
Store
Google Gemini has become a basic product that helps people with their work by producing text based on natural language revival. Currently, Google combines the Gemini model on Google sheets with Google Workspace, which can come after the program.
In this article, read Us applying Google Gemini directly to Google sheets, both with Gemini Sidebar and through =AI formula.
I hope this has helped!
Cornellius Yudha Wijaya It is a scientific science manager and the database author. While working full-time in Allianz Indonesia, she likes to share the python and data advice with social media and media writing. Cornellius writes to a variety of AI and a study machine.
