How to Use Google Bard with Google Sheets (Updated for 2024)

Posted by

Google Bard can help you create content and calculations for Google Sheets. In the first role, Bard serves as a smart list generator that generates content in a table for you to export to Google Sheets. In the latter role, Bard’s responses help you devise Google Sheets formulas and functions. These uses of the bard provide abilities that extend beyond the norm Autofill And Improvement capabilities In Google Sheets.

See: ChatGPT vs Google Bard: An in-depth comparison (TechRepublic)

For the following actions, you will need to sign in to an authorized active Google Account to use both Google Sheets and Google Bard. If you use a Google Workspace account for work or school, you may need to contact an administrator to request access to Bard. Once you have access, open Bard in any modern browser to get started. Enter a natural language prompt, and Bard will respond. Bard responses may vary — no two people who enter the same prompt can receive the same response.

How to Get Content from Bard to Google Sheets

with Feet, you can prompt the system for all kinds of comparisons and lists. For example, a request to compare two or more products might create a table with a column for each product and each row with a separate comparison feature (Figure A). You can also ask the bard for a list of things, such as people, places, or things. Bard accepts sequences, so you can give the first hint:

List the 10 cities in the United States with the most annual rainfall.

Then, after you receive the initial response, prompt again with:

Add a column for the population.

Figure A

Bard can help you quickly find all kinds of comparisons and lists. When Bard renders the response in a table, select Export to Sheets to create a new Google Sheet with the table’s contents.

Tools | Autocomplete | Enable the auto-complete option.

In Google Sheets, you enter a predictable series of letters of the alphabet, numbers, days of the week, months, or other standard patterns into two or more cells. Then select the cells and expand the corners of the box to cover the entire range of cells to be filled. For example, if you type Mon in a cell and Mars In an adjacent cell, you can select those two cells and then drag the point to fill the other five cells with the remaining three-character descriptions of the days of the week in English. In contrast, the tables you can prompt Bard to create can include a much wider range of catalog data.

Select Export to Sheets

When the response includes a table, select the Export to Sheets option in the lower-right corner of the table. This exports the table to a new Google Sheet (Figure A). The system will use your prompt as both the name of the newly created file and the starting sheet within the file. The contents of the table will be placed in the cells of the sheet, with column headings in row A.

“In Table” prompt

Bard will often automatically format comparisons and lists in tables. When the system does not do this, add the phrase “in the table” to your request. This will make the prompt listed above look like this:

In a table, list the 20 cities in the United States with the most annual rainfall.

View other drafts or reset the chat

Sometimes the bard gives either a partial response or an oddly formatted response. For example, try the prompt:

List all 50 U.S. states sorted by population.

Bard returns a table of 40 states, which is an incomplete response. In another example, a prompt for:

List of elements by name and atomic weight.

In response, Bard created a list formatted as a code snippet, not a table. When the response is not what you expected, select the View Other Drafts button to access alternative drafts (Figure B). In some cases, one of those drafts will be formatted as a table rather than a code snippet.

Another option when this type of error occurs is to start a new chat (shown in Figure B top left) and then try again with a rewritten prompt. This may provide a more complete or better formatted response.

Figure B

See other drafts to access alternatively formatted responses, which sometimes display data in a table rather than a list format.
See other drafts to access alternatively formatted responses, which sometimes display data in a table rather than a list format. In some cases, choosing to reset the chat and retrying your prompt may return the response in the format you want.

How to get help from Bard with Google Sheets calculations

You can prompt Bard to explain and provide examples of Google Sheets formulas and functions. Unlike the Google Sheets help pages, which provide a static set of details and examples, you can ask Bard for a variety of examples with a detailed description of how a feature works.

For example, if you want to know a little more about a Added new functions to Google Sheets In March 2023, you can signal:

How do I use the WRAPCOLS function in a Google Sheet? Can you give an example of how I might use it to group a list of employee names into groups of 4 people each?

Response from Bard (Figure C) sequence includes:

  • A description of how the function is used.
  • A code snippet example of the syntax with each part listed.
  • A sample formula for grouping a list into sets of four.
  • Example with demo names.
  • Additional code examples for grouping lists into sets of three, five, or seven.

Figure C

The featured image not only explains Bard Google Sheets functions, but also provides examples of how those functions can be used.
Bard can not only explain the functions of Google Sheets, but also provide examples of how the functions can be used.

To explore additional Google Sheets functions, you can then prompt:

Are there other Google Sheets functions that achieve something similar?

Bard offers a few other functions that help with related aspects of your initial work.

Additionally, Bard can help you create the exact formula you need, but it can be a bit of a trial and error process. For example, say you want to analyze weather data to identify how many days the wind was predominantly from the west. First, try the initial detailed prompt (Figure D).

I have a Google Sheet with data in cells F2 through F367. The data is all numbers, from 0 to 359, and represents wind direction, with 0 being the north and 270 being the west. I would like a formula to indicate the percentage of days that the wind is from the west, where the value is anywhere between 240 and 270 degrees. Can you provide that?

Figure D

The graphic shows that with a sufficiently detailed prompt, Bard can respond with a detailed code snippet containing a Google Sheets function.
With a sufficiently detailed prompt, Bard can respond with a detailed code snippet that contains Google Sheets functions. Not necessarily always accurate, this snippet can often serve as the basis for the exact formula you need.

The response returned a =COUNTIF formula that threw an error. After a quick review of the function, prompt again, essentially asking Bard to try again:

I think the range indicator portion needs to be different. Maybe a logical AND not a text field?

This time, the response contains a =COUNTIFS formula. Select the Copy Code button, switch to Google Sheets, navigate to the desired destination cell, and then select Edit and Paste to add the formula. This time, with some tweaking, the code snippet works as intended (Statistics e).

Statistics e

With minor modifications, the code snippet response provided by Bard delivers the desired computation.
With minor modifications, the code snippet response provided by Bard delivers the desired computation.

And that’s a good snapshot of how you need to work with Bard. If the initial feedback meets your needs, that’s great! But always take the time to check the results for accuracy and be prepared to re-cue – and cued differently – to provide more relevant, useful or accurate feedback.

#Google #Bard #Google #Sheets #Updated

Leave a Reply

Your email address will not be published. Required fields are marked *