Google Workspace Official Website here

Strengths of Google Sheets

Google Sheets is an Excel-compatible spreadsheet tool that allows real-time collaborative editing. From 2025 to 2026, its integration with Gemini AI will be significantly strengthened, and features such as natural language table creation, AI-powered data analysis, and Gemini AI functions, which dramatically boost business efficiency, have become available.

Key New Features for 2025-2026 (Gemini Integration)

1. Fill with Gemini (AI-powered automatic data entry)

By selecting a cell range and using "Fill with Gemini," it can learn data patterns to generate custom text, classify data, summarize information, and retrieve real-time information from Google Search. Manual entry will be significantly reduced.

2. Create Spreadsheets with Natural Language (From March 2026)

Simply by entering prompts like "Create a campaign performance tracker with budget and actual comparison columns," Gemini will automatically create a spreadsheet with the appropriate structure, functions, and formatting. The effort of designing from scratch is no longer necessary.

3. AI Functions: Prompt Gemini within Cells

"AI Functions" became available starting in 2025. You can write prompts directly to Gemini within cells to perform data generation, analysis, translation, classification, and more. For example:

=AI("Summarize this product description in 30 characters or less", A2)

This is especially effective for batch processing large amounts of data.

4. Gemini-Generated Charts (Supports Automatic Updates)

Simply by instructing, "Show me the trend of this data as a line chart," Gemini will generate a chart, and the chart will automatically update when the data is refreshed. It supports Japanese, English, French, Spanish, German, Italian, Portuguese, and Korean.

5 Essential Functions for Business

XLOOKUP (An evolved version of VLOOKUP)

It is used to reference data from other sheets or tables. More flexible than VLOOKUP, it allows searching to the left and returning multiple columns.

=XLOOKUP(A2, CustomerDB!A:A, CustomerDB!B:B, "Not registered")

SUMIFS (Sum with Multiple Conditions)

It sums only the cells that meet multiple conditions. Essential for sales aggregation by department or period, among others.

=SUMIFS(Sales!D:D, Sales!B:B, "Tokyo", Sales!C:C, "2025")

QUERY Function (SQL-like Analysis)

It is a powerful function unique to Google Sheets. It allows extracting and aggregating data using SQL-like syntax.

=QUERY(Data!A:F, "SELECT A, SUM(F) WHERE C='Tokyo' GROUP BY A ORDER BY SUM(F) DESC")

IMPORTRANGE (Retrieve Data from Other Sheets)

It automatically retrieves data from another spreadsheet. Essential for creating dashboards that integrate multiple sheets.

ARRAYFORMULA (Array Processing)

It applies a single formula to an entire column. It can be used for batch calculations on large amounts of data.

Data Analysis with Pivot Tables

  1. Select data range
  2. Click 'Insert' → 'Pivot table'
  3. A pivot table will be created on a new sheet
  4. Set rows, columns, values, and filters
  5. Ask Gemini 'Tell me the insights from this pivot table' to utilize AI analysis

Data Validation

Under 'Data' → 'Data validation', you can set up dropdown lists and input restrictions. This prevents input errors and maintains data integrity.

Automation with Google Apps Script

You can create scripts from 'Extensions' → 'Apps Script' to automate tasks such as sending emails and performing regular aggregations. With Workspace Studio, automation by AI agents is also possible without programming.

Summary

By simply mastering the three features: 'Fill with Gemini', 'Natural Language Sheet Creation', and 'AI Functions', you can significantly reduce your spreadsheet work time. First, challenge yourself to create dashboards using the QUERY function and IMPORTRANGE, and gradually deepen your integration with Gemini.

▶ Check details and free trial on the Google Workspace Official Website