# US 12,001,782 B2 · Personalized autonomous spreadsheets

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 12,001,782 B2
- Document ID: US12001782B2
- Status: Granted
- Kind: B2
- Application number: 17/485,008
- Filed: 2021-09-24
- Published: 2023-03-30
- Granted: 2024-06-04
- Earliest claimed: 2021-09-24
- Assignees: Google Inc.
- Applicants: Google LLC
- Inventors: Andrew J. Lavery; Earl J. Wagner; Matthew Albright
- Web page: https://patentgrep.com/patent/US12001782B2

## CPC

- G06F 16/90332: {Natural language query formulation or dialogue systems}
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F 16/9535: Search customisation based on user profiles and personalisation
- G06N 5/02: Knowledge representation; Symbolic representation
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS

## Abstract

A method includes receiving, by a processing device from a client device associated with a user, a natural language query corresponding to a request to create, for the user, a personalized document having a tabular structure, determining, by the processing device, one or more attribute categories pertaining to the personalized document, identifying, by the processing device, at least one external data source including at least one subjective data source related to the user, retrieving, by the processing device from the at least one external data source, data items indicative of the one or more attribute categories, and generating, by the processing device, the personalized document for the user by populating each cell of the personalized document with a respective data item.

## Claims

### Claim 1

A method comprising:
receiving, by a processing device from a client device associated with a user, a natural language query corresponding to a request to create, for the user, an initial version of a personalized document having a tabular structure without additional user interaction;
determining, by the processing device, a set of attribute categories pertaining to the personalized document, the set of attribute categories comprising a first attribute category corresponding to one or more cells populated with one or more first attributes and a second attribute category corresponding to one or more cells populated with one or more second attributes;
identifying, by the processing device, at least one external data source, the at least one external data source comprising at least one subjective data source related to the user, wherein the at least one external data source comprises a personalized knowledge graph corresponding to the user;
retrieving, by the processing device from the at least one external data source, a plurality of data items indicative of the set of attribute categories; and
generating, by the processing device, the initial version of the personalized document for the user by populating each cell of a plurality of cells of the personalized document with a respective data item of the plurality of data items.

### Claim 2 (depends on 1)

The method of claim 1, wherein the at least one external data source further comprises an objective data source, and wherein retrieving the plurality of data items from the at least one external data source comprises:
retrieving, from the at least one subjective data source, one or more data items corresponding to the one or more first attributes, wherein the at least one subjective data source has content relevant to the user or a user group associated with the user; and
retrieving, from the objective data source, one or more data items corresponding to the one or more second attributes.

### Claim 3 (depends on 1)

The method of claim 1, further comprising:
identifying, by the processing device, a change in user activity; and
generating, by the processing device, a new version of the personalized document, wherein the new version includes content reflecting the change in the user activity, the content being relevant to the user or a user group associated with the user.

### Claim 4 (depends on 1)

The method of claim 1, further comprising:
retrieving, by the processing device, one or more additional data items from the at least one external data source; and
updating, by the processing device, the personalized document based on the one or more additional data items.

### Claim 5 (depends on 4)

The method of claim 4, wherein retrieving the one or more additional data items further comprises:
receiving an additional natural language query; and
retrieving the one or more additional data items in response to receiving the additional natural language query.

### Claim 6 (depends on 4)

The method of claim 4, wherein retrieving the one or more additional data items further comprises:
identifying a user interest in newly relevant data for the personalized document;
determining that the newly relevant data has been added to the at least one external data source; and
retrieving the newly relevant data from the at least one external data source.

### Claim 7

A system comprising:
a memory device; and
a processing device coupled to the memory device, the processing device to perform operations comprising:
receiving, from a client device associated with a user, a natural language query corresponding to a request to create, for the user, an initial version of a personalized document having a tabular structure without additional user interaction;
determining a set of attribute categories pertaining to the personalized document, the set of attribute categories comprising a first attribute category corresponding to one or more cells populated with one or more first attributes and a second attribute category corresponding to one or more cells populated with one or more second attributes;
identifying at least one external data source, the at least one external data source comprising at least one subjective data source related to the user, wherein the at least one external data source comprises a personalized knowledge graph corresponding to the user;
retrieving, from the at least one external data source, a plurality of data items indicative of the set of attribute categories; and
generating the initial version of the personalized document for the user by populating each cell of a plurality of cells of the personalized document with a respective data item of the plurality of data items.

### Claim 8 (depends on 7)

The system of claim 7, wherein the at least one external data source further comprises an objective data source, and wherein retrieving the plurality of data items from the at least one external data source comprises:
retrieving, from the at least one subjective data source, one or more data items corresponding to the one or more first attributes, wherein the at least one subjective data source has content relevant to the user or a user group associated with the user; and
retrieving, from the objective data source, one or more data items corresponding to the one or more second attributes.

### Claim 9 (depends on 7)

The system of claim 7, wherein the operations further comprise:
identifying a change in user activity; and
generating a new version of the personalized document, wherein the new version includes content reflecting the change in the user activity, the content being relevant to the user or a user group associated with the user.

### Claim 10 (depends on 7)

The system of claim 7, wherein the operations further comprise:
retrieving one or more additional data items from the at least one external data source; and
updating the personalized document based on the one or more additional data items.

### Claim 11 (depends on 10)

The system of claim 10, wherein retrieving the one or more additional data items further comprises:
receiving an additional natural language query; and
retrieving the one or more additional data items in response to receiving the additional natural language query.

### Claim 12 (depends on 10)

The system of claim 10, wherein retrieving the one or more additional data items further comprises:
identifying a user interest in newly relevant data for the personalized document;
determining that the newly relevant data has been added to the at least one external data source; and
retrieving the newly relevant data from the at least one external data source.

### Claim 13

A system comprising:
a memory device; and
a processing device coupled to the memory device, the processing device to perform operations comprising:
receiving a plurality of natural language queries from a user;
determining that each natural language query of the plurality of natural language queries is associated with a similar topic;
sending a recommendation to the user to create an initial version of a personalized document having a tabular structure based on the plurality of natural language queries; and
in response to receiving an indication from the user to create the initial version of the personalized document, generating the initial version of the personalized document without additional user interaction by populating each cell of a plurality of cells of the document with a respective data item of a set of data items retrieved from at least one external data source comprising a subjective data source comprising a personalized knowledge graph corresponding to the user, wherein the set of data items corresponds to a set of attribute categories pertaining to the document, and wherein the set of attribute categories comprises a first attribute category corresponding to one or more cells populated with one or more first attributes and a second attribute category corresponding to one or more cells populated with one or more second attributes.

### Claim 14 (depends on 13)

The system of claim 13, wherein generating the initial version of the personalized document comprises:
identifying the set of attribute categories pertaining to the personalized document; and
retrieving, from the at least one external data source, the set of data items.

### Claim 15 (depends on 13)

The system of claim 13, wherein the at least one external data source further comprises an objective data source.

### Claim 16 (depends on 13)

The system of claim 13, wherein the operations further comprise:
retrieving one or more additional data items from the at least one external data source; and
updating the personalized document based on the one or more additional data items.

### Claim 17 (depends on 16)

The system of claim 16, wherein retrieving the one or more additional data items further comprises:
receiving an additional natural language query; and
retrieving the one or more additional data items in response to receiving the additional natural language query.

### Claim 18 (depends on 16)

The system of claim 16, wherein retrieving the one or more additional data items further comprises:
identifying a user interest in newly relevant data for the personalized document;
determining that the newly relevant data has been added to the at least one external data source; and
retrieving the newly relevant data from the at least one external data source.
