Google is integrating Gemini Gems into Workspace apps like Docs, Sheets, and Gmail, allowing users to access customizable AI chatbots directly within these applications.
Google's AI function brings Gemini-powered language models right into your spreadsheet cells without any add-ons. With it, you can generate fresh text, summarize blocks of data, categorize entries, or even guess sentiments—all by typing a simple formula.
The article provides examples such as:
- *sentiment analysis* ```=AI("Is this customer feedback positive, negative, or neutral?", A2)```
- *data categorization* `=AI("Classify this expense as Travel, Office, or Other", D3)`
- *simple calculations* `=AI("Add the numbers in these cells", A1:A5)`
The article provides examples such as:
- *sentiment analysis* ```=AI("Is this customer feedback positive, negative, or neutral?", A2)```
- *data categorization* `=AI("Classify this expense as Travel, Office, or Other", D3)`
- *simple calculations* `=AI("Add the numbers in these cells", A1:A5)`
=SUMIFS(B6:B14, A6:A14, "apples", C6:C14,"delivered")
<999950 » 0.0,"K"; <999950000 » 0.0,,"M";0.0,,,"B"
