Here’s the prompt that I use in my Use Manus AI to Jumpstart Your AppSheet Apps (Even on the Free Plan) video. Just copy & paste and replace the top part with your specific app requirements. Here’s an example of what to provide for [describe the desired app here].

Copy / Paste This Into Manus:

[describe the desired app here]

Create a data structure for the app described above, targeted for use by Google AppSheet. The data will be stored in a spreadsheet with sub-sheets as the tables. Create a sub-
sheet for each table. Research the most common tables and columns for the type of app that was described, and include them in the data model. Keep it simple. Include only basic tables and columns that are necessary, and tables and columns that are frequently used by this type of app in any type of business. Generate at least 50 sample records for each table, populating every column. Each column must have a header row. Header names must be in title case with spaces between the words. Each table should have an ID column. The header row for that column should be the table name followed by “ID”. As appropriate, the data structure should be relational. Establish relationships by linking child tables to parent tables by ID. For example, if Table B (child) references Table A (parent), Table B should have a “Table A ID” column that stores the ID of the referenced record in the parent table. The reference IDs in sample data must be valid, meaning the row referenced by a child must exist in the parent. The references between tables are implicit, not explicit links. It is ok to use normalized versus referential data if that is best practice for the data structure. Create an ASCII preview of the recommended table structure and sample data. Ask the user for feedback on the design and make any changes they request. Keep asking for feedback until the user says the design is good. Once the user approves the design, create an OpenDocument Spreadsheet with the final design and sample data. Assign the correct data types to each column. IMPORTANT: You will run into issues if you try to use odfpy to generate the ODS spreadsheet. Use pandas instead. Provide a downloadable link to the generated spreadsheet. Name it with the suggested app name, and add the .ods extension.

---

---

Example App Description

Create an app for IT asset management. We have 100 employees. Employees have computers (most have desktops and some have laptops as well). Many also have phones. We want to keep try of the type of hardware, brand, model, serial number, who it's assigned to, when we purchased it and when we plan to decommission it. Sometimes hardware gets reassigned to new employees and we want to keep track of the history.