IP Library Granted Patent US 12,001,783
Granted Patent B2
US 12,001,783 · App. 17/485,028 · Granted Jun 4, 2024

Autonomous spreadsheet creation

Inventors: Andrew J. Lavery (Austin, TX); Earl J. Wagner (Chicago, IL); Matthew Albright (Montclair, NJ)
Assignee: Google LLC
G06F40/18G06F16/953G06F40/40G06N5/02
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,001,783
App. No.
17/485,028
Granted
Jun 4, 2024
Kind
B2
Abstract

A method includes receiving, by a processing device, a natural language query corresponding to a request to create a document having a tabular structure, identifying, by the processing device, one or more attribute categories pertaining to the document, converting, by the processing device, the natural language query into a data access query for accessing at least one external data source, retrieving, by the processing device from the at least one external data source, a plurality of data items corresponding to the one or more attribute categories, and generating, by the processing device, the document by populating each cell of a plurality of cells of the document with a respective data item of the plurality of data items.

Claims (56)

1. A method comprising:

receiving, by a processing device, a natural language query corresponding to a request to create an original version of a document having a tabular structure without additional user interaction;

identifying, by the processing device, a set of attribute categories pertaining to the 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;

converting, by the processing device, the natural language query into a data access query for accessing at least one external data source comprising a knowledge graph;

retrieving, by the processing device from the at least one external data source, a plurality of data items corresponding to the set of attribute categories; and

generating, by the processing device, the original version of the document by populating each cell of a plurality of cells of the document with a respective data item of the plurality of data items.

2. The method of claim 1 , wherein the at least one external data source further comprises a website.

3. The method of claim 1 , wherein generating the original version of the document comprises generating the original version of the document to have a size determined in accordance with a size limit.

4. 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 document based on the one or more additional data items.

5. 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.

6. The method of claim 4 , wherein retrieving the one or more additional data items further comprises:

identifying, from the at least one external data source, newly relevant data with respect to the document; and

retrieving the newly relevant data from the at least one external data source.

7. A system comprising:

a memory device; and

a processing device coupled to the memory device, the processing device to perform operations comprising:

receiving a natural language query corresponding to a request to create an original version of a document having a tabular structure without additional user interaction;

identifying a set of attribute categories pertaining to the 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;

converting the natural language query into a data access query for accessing at least one external data source comprising a knowledge graph;

retrieving, from the at least one external data source, a plurality of data items corresponding to the set of attribute categories; and

generating the original version of the document by populating each cell of a plurality of cells of the document with a respective data item of the plurality of data items.

8. The system of claim 7 , wherein the at least one external data source further comprises a website.

9. The system of claim 7 , wherein generating the original version of the document comprises generating the original version of the document to have a size determined in accordance with a size limit.

10. 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 document based on the one or more additional data items.

11. 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.

12. The system of claim 10 , wherein retrieving the one or more additional data items further comprises:

identifying, from the at least one external data source, newly relevant data with respect to the document; and

retrieving the newly relevant data from the at least one external data source.

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 original version of a 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 original version of the document, generating the original version of the 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 knowledge graph, 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.

14. The system of claim 13 , wherein generating the original version of the document further comprises:

identifying the set of attribute categories pertaining to the document; and

retrieving, from the at least one external data source, the set of data items.

15. The system of claim 13 , wherein the at least one external data source further comprises a website.

16. 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 document based on the one or more additional data items.

17. 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.

18. The system of claim 16 , wherein retrieving the one or more additional data items further comprises:

identifying, from the at least one external data source, newly relevant data with respect to the document; and

retrieving the newly relevant data from the at least one external data source.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 27, 2021
From: LAVERY, ANDREW J.; WAGNER, EARL J.; ALBRIGHT, MATTHEW
To: GOOGLE LLC
Reel/Frame 057605/0905 →
Continuity (1)
Related Publication 20230106058A1 · Apr 6, 2023