Skip to main content

Google gives Gemini a boost in Sheets and a cool trick in NotebookLM

Working with Google Gemini in Sheets.
Nadeem Sarwar / Digital Trends

Google is expanding Gemini integration within its Workspace suite and has announced a couple of new tricks for its underrated NotebookLM tool. The first in line is the ability to create structured tables in Google Sheets with text prompts.

So far, all tables created by the AI were served in plain text with only bold highlights for the headers. Needless to say, they looked drab and boring, lacking any character at all. There was no text formatting or stylistic edits to the cell contents.

Recommended Videos

Now, Google has updated the “Create a table” preset in the Gemini sidebar in Sheets. On tapping it, users can conveniently substitute the core input terms and get a structured table with colorful highlights, dropdown options, and shaded cells in a few seconds.

New structured table format in Google Sheets for Gemini.
Google

According to Google, the facility will be available to “Workspace customers with Gemini Business, Enterprise, Education, Education Premium add-ons and users with the Google One AI Premium subscription.”

It seems the rollout is focused on business and enterprise customers first. Presently, those with access to Gemini Advanced courtesy of a Google One AI Premium subscription may not yet be able to create structured tables in Google Sheets.

An underrated gem gets better

The more impressive set of updates has been reserved for NotebookLM, the AI-powered note-taking app that also doubles as a research assistant. It can now analyze YouTube videos using a simple URL copy-paste and break down the contents in whichever form you’d like to view them.

NotebookLM providing summary of YouTube videos.
Nadeem Sarwar / Digital Trends

You can further ask follow-up questions based on the topic-based breakdown offered by NotebookLM, complete with clickable links to the specific point in the video. After trying it on a few videos of varying durations, it seems to work flawlessly, even picking up details from the relatively shorter chapters in a YouTube video.

Another cool feature that will be immensely convenient for journalists, researchers, and students is the ability to search across an audio file’s transcription for specific information.

NotebookLM summary of a YouTube video.
Nadeem Sarwar / Digital Trends

Furthermore, NotebookLM has also gained the ability to transform audio recordings, handwritten notes, and lecture slides into study guides. Finally, we have a sharing update for Audio Overviews, which are essentially podcast-style audio versions of user-uploaded text files like PDFs.

Up until now, you could only generate these overviews with a single click. Now, they can also be shared directly using a custom URL. For folks seeking more versatility, they can also import Docs, Slides, and website links, or simply copy-paste text and get the analysis done by the underlying Gemini 1.5 model.

Nadeem Sarwar
Nadeem is a tech journalist who started reading about cool smartphone tech out of curiosity and soon started writing…
How to use Gemini AI to create presentations in Google Slides
a professional woman giving a slideshow presentation

The only thing people enjoy less than sitting through a slideshow presentation is making a slideshow presentation. But with the integration of Gemini AI into Google Slides, that process is about to get a whole lot easier.

In this guide, we'll explore everything you need to seamlessly incorporate Gemini AI into your workflow. Whether you're looking to enhance your design elements, streamline content generation, or simply save yourself some time, Gemini AI offers a suite of features that can transform the way you build your presentations.
How to integrate Gemini into Google Slides
As with the integrations for Docs and Sheets, Gemini AI is not available for use with Slides at the free tier. You'll need a $20/month subscription to the Google One AI Premium Plan to gain access; otherwise, a work or school account through a Gemini for Google Workspace add-on will work.

Read more
How to use Gemini AI to master Google Sheets
a laptop with a spreadsheet graph displayed

Applying AI in your spreadsheet workflows can save you a lot of time, and with Gemini AI integrated into Google Sheets, you can take your data management to the next level. In this guide, we'll walk you through everything you need to seamlessly integrate Gemini AI into Google Sheets.

Discover how Gemini can enhance your ability to analyze data, automate repetitive tasks, and optimize your entire spreadsheet experience, making your work more efficient and insightful than ever.
How to integrate Gemini into Google Sheets
Just as with adding Gemini functionality to Docs, Sheets, and the rest of the Workspace suite, you can't do it with the free tier. You'll have to subscribe to the $20-per-month Google One AI Premium Plan to gain access, or you can use a work or school account if it has the Gemini for Google Workspace add-on.

Read more
How to use Gemini AI to write anything in Google Docs
A Gemini branding image

Gemini AI, Google's latest language model, is revolutionizing the way we create content within Google Docs, from drafting emails and reports to generating creative writing pieces.

In this guide, we'll walk you through the steps to access and set up Gemini AI in Google Docs, explore its impressive features, and provide practical examples of how to leverage its potential for a wide range of tasks.
How to integrate Gemini into Google Docs
Unfortunately, Gemini integration with Google's Workspace suite isn't available to free-tier users. You'll need a $20/month subscription to the Google One AI Premium Plan (or a work or school account through a Gemini for Google Workspace add-on) to gain access. Signing up for the personal plan is straightforward.

Read more