How Does Google Duet Work in Sheets?

Instead of integrating Gemini into Workspace apps like Sheets, Google developed their Duet AI for that purpose.

Navigate to Google Sheets, and click+ Blankto create a new spreadsheet.

+ Blank highlighted in Google Sheets.

you might use Google Duet in existing spreadsheets, but it will overwrite any existing data or formatting.

tap the text field in theHelp me organizesidebar.

Dont see the sidebar?

The text field highlighted in the Help me organize sidebar in Sheets.

Click theHelp me organize buttonat the far left end of the tool bar.

punch in a request, and clickCreate template.

The spreadsheet template is now ready for your data.

Create template highlighted in Google Sheets.

What Can Duet AI Do in Google Sheets?

Duet can generate spreadsheets quickly and even populate them with placeholder data, but it does have limitations.

In some cases, youll find that it simply cant perform the required task.

Insert highlighted in Google Sheets.

That wont necessarily be the case forever since Duet will likely gain new features and abilities over time.

If you submit a request that Duet cant handle, youll receive an fault signal to that effect.

Can Google Duet Use Formulas in Sheets?

A spreadsheet template made by Google Duet.

When you receive an error alert from Duet in Sheets, rephrasing the request can help.

This method uses smart features in Sheets to automatically generate formulas that augment a Duet-generated template.

This is just one example of how to use a Duet-generated template.

The text field highlighted along with the Create template button highlighted.

Start by creating a new spreadsheet in Google Sheets.

Then punch in a request, i.e.

profit and loss tracker for a laundromat, and clickCreate template.

Insert highlighted in Google Sheets.

If the template isnt quite right, adjust your request and click Create template again.

This template is a good start, but it doesnt actually calculate anything.

To fix that, highlight the first number in theGross Profitcolumn and press the=key.

A cell highlighted in Google Sheets.

Press the left arrow on your keyboard twice, then click thesuggested formulaor presstab.

Now do the same thing with the first entry in theNet Profitcolumn.

Delete the number from that cell, press the=key, then the back arrow twice.

Cell and a formula highlighted in Google Sheets.

Then click thesuggested formulawhen it appears, or presstab.

Now hit the first entry in theGross Profitcolumn.

Click thedotat the bottom right corner of the selected cell, anddrag down.

Cells and a formula highlighted in Google Sheets.

Repeat that process, but with the first entry in theNet Profitcolumn.

you’re free to enter numbers into theRevenue,Cost of Goods Sold, andOperating Expensescolumns.

The spreadsheet automatically calculates the Gross Profit and Net Profit entries with those numbers entered.

A cell highlighted in Google Sheets.

FAQ

Gemini (formerly Bard) is Google’s AI chatbot program that launched in early 2023.

It uses the company’s own Pathways Language Model (PaLM).

Google Gemini is available atgemini.google.com.

A draggable dot highlighted with an arrow pointing down to show you need to drag the dot down in Google Sheets.

Cells highlighted in Google Sheets with an arrow indicating to drag down to have Google Sheets automatically fill in the rest of the cells.

Cells highlighted where you can enter data the formula will use.

A spreadsheet made by Google Duet with formulas added and the working formula total is highlighted..