Google has launched a new AI function in Sheets that can automatically generate text to fill empty cells in spreadsheets based on existing data. The feature, powered by Google Gemini, allows users to create customized content, summarize information, or categorize data by referencing specific cells within their spreadsheets.
How it works: Users highlight cells where they want AI-generated content and enter a formula that tells the AI what to create based on nearby data.
- The function uses syntax like
=AI("Write a formal ad copy for the product. Cater copy to the objective and target audience.", A2:C2)to generate tailored advertisement copy based on different target audiences listed in the spreadsheet. - Another example allows users to summarize customer feedback with
=AI("For the customer, write a one sentence summary of their feedback.", A2:D2). - The tool can also categorize data, such as classifying customer inquiries as compliments, exchange requests, or return requests, or organizing restaurants by location.
Key limitations: The AI function comes with several constraints that users should understand before implementation.
- It only supports text-based responses and cannot generate other types of content like images or charts.
- The function can’t access entire spreadsheets or Google Drive files, limiting its scope to selected cell ranges.
- Users can only generate outputs for the first 200 selected cells at a time, requiring multiple rounds for larger datasets.
The big picture: This feature builds on Google’s existing Gemini-powered capabilities in Sheets that can answer questions about data and create visualizations, expanding the platform’s AI automation tools for workplace productivity.
Who can access it: The AI functions are rolling out to Google Workspace users on business and enterprise plans, as well as Gemini AI Pro and Ultra subscribers, and those with Gemini Education plans or add-ons.
Recent Stories
DOE fusion roadmap targets 2030s commercial deployment as AI drives $9B investment
The Department of Energy has released a new roadmap targeting commercial-scale fusion power deployment by the mid-2030s, though the plan lacks specific funding commitments and relies on scientific breakthroughs that have eluded researchers for decades. The strategy emphasizes public-private partnerships and positions AI as both a research tool and motivation for developing fusion energy to meet data centers' growing electricity demands. The big picture: The DOE's roadmap aims to "deliver the public infrastructure that supports the fusion private sector scale up in the 2030s," but acknowledges it cannot commit to specific funding levels and remains subject to Congressional appropriations. Why...
Oct 17, 2025Tying it all together: Credo’s purple cables power the $4B AI data center boom
Credo, a Silicon Valley semiconductor company specializing in data center cables and chips, has seen its stock price more than double this year to $143.61, following a 245% surge in 2024. The company's signature purple cables, which cost between $300-$500 each, have become essential infrastructure for AI data centers, positioning Credo to capitalize on the trillion-dollar AI infrastructure expansion as hyperscalers like Amazon, Microsoft, and Elon Musk's xAI rapidly build out massive computing facilities. What you should know: Credo's active electrical cables (AECs) are becoming indispensable for connecting the massive GPU clusters required for AI training and inference. The company...
Oct 17, 2025Vatican launches Latin American AI network for human development
The Vatican hosted a two-day conference bringing together 50 global experts to explore how artificial intelligence can advance peace, social justice, and human development. The event launched the Latin American AI Network for Integral Human Development and established principles for ethical AI governance that prioritize human dignity over technological advancement. What you should know: The Pontifical Academy of Social Sciences, the Vatican's research body for social issues, organized the "Digital Rerum Novarum" conference on October 16-17, combining academic research with practical AI applications. Participants included leading experts from MIT, Microsoft, Columbia University, the UN, and major European institutions. The conference...