# US 12,001,783 B2 · Autonomous spreadsheet creation > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 12,001,783 B2 - Document ID: US12001783B2 - Status: Granted - Kind: B2 - Application number: 17/485,028 - Filed: 2021-09-24 - Published: 2023-04-06 - 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/US12001783B2 ## CPC - G06F 16/24522: {Translation of natural language queries to structured queries} - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F 16/248: Presentation of query results - G06F 16/953: Querying, e.g. by the use of web search engines - G06F 40/174: Form filling; Merging - G06F 40/20: Natural language analysis (semantic analysis of natural language G06F40/30) - G06F 40/30: Semantic analysis - G06F 40/40: Processing or translation of natural language (natural language analysis G06F40/20; semantic analysis G06F40/30) - 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, 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 ### Claim 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. ### Claim 2 (depends on 1) The method of claim 1, wherein the at least one external data source further comprises a website. ### Claim 3 (depends on 1) 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. ### 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 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, 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. ### 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 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. ### Claim 8 (depends on 7) The system of claim 7, wherein the at least one external data source further comprises a website. ### Claim 9 (depends on 7) 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. ### 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 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, 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. ### 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 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. ### Claim 14 (depends on 13) 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. ### Claim 15 (depends on 13) The system of claim 13, wherein the at least one external data source further comprises a website. ### 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 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, 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.