Create apps using Gemini for App Creation

Gemini for App Creation is available to all AppSheet paid accounts, including Google Workspace customers with AppSheet Core and AppSheet Enterprise Plus, and individual accounts with AppSheet Publisher Pro, AppSheet Starter, AppSheet Core, and AppSheet Enterprise Plus.

Gemini for App Creation allows you to build apps by simply describing a business process or idea in natural language.

For example, you might give Gemini a description for an app that manages facility inspections. Gemini returns the app structure that you can review, optionally, edit, and create an inspection app, as the following diagram shows:

Gemini in AppSheet creates app structure that you use to create an app

The following sections describe how to create apps using Gemini for App Creation:

Access Gemini for App Creation
Step 1: Describe your app idea or process
Step 2: Review and edit the app structure
Step 3: Create and customize your app
What's next?

Access Gemini for App Creation

To access Gemini for App Creation:

Access My Apps:
- Sign in to AppSheet . My Appsis displayed, by default.
- Click My Appsin the top navigation.
- Select My Appsfrom the account profile drop-down.
For more information about the My Apps page, see Explore the My Apps page .
Click + Create > App > Start with Gemini.

The Gemini-assisted chat interface opens.

Create your app using Gemini for App Creation in three steps:

Step 1: Describe your app idea or process
Step 2: Review and edit your app structure
Step 3: Create and customize your app

Step 1: Describe your app idea or process

At the Gemini prompt, do one of the following and press Enter:

Describe your app idea or process. In your description (also referred to as a prompt ), provide as much detail as you can.
Click on one of the sample prompts provided to auto-populate the prompt.

Gemini responds with an app structure summarizing data that will be managed by your app, including the tables and their associated columns.

Let's use a simple facility inspections example:

Enter: Manage inspections of my facility. Our inspectors conduct facility inspections, and every week we need to check that everything is operating correctly at each facility, pass or fail an inspection, and create and submit reports.

Gemini responds with an app structure:

App card for Inventory and Sales Tracker app

In this example, Gemini performed the following:

Created the following tables to keep track of your data (similar to tabs in a spreadsheet): Inspectors , Reports , Inspections , and Facilities .
Created the columns, listed after each table, which are the attributes that describe each row in a table. For example, the Inspections table includes the following columns: Id , Facility Id , Inspector Id , Date , Status , and Report Id .
Added linksbetween tables. For example, in the Inspections table, the Facilty Id and Inspector Id columns link to the Name columns in the Facilities and Inspectors tables, respectively, as the following diagram shows:

The following diagram provides an example of how your app might display and manage the records in the Inspections table.

Inspections table generated by Gemini in AppSheet and shown in the app

Notice that the Inspections table includes an additional column: Image . You'll learn how to add the Image column to the Inspections table in the next step.

Step 2: Review and edit your app structure

Review and edit your app structure, as required.

Review your app structure

Review the app structure and decide if there is other information that you would like to track using your app.

If you are satisfied with your app structure, click Create appto create and customize your app .

If you aren't satisfied with your app structure, do one of the following:

Edit your app structure (described below).
Click Start overto discard the current app structure and start over.

Edit your app structure

To edit your app structure, do one or more of the following:

Add a table
Edit a table

Add a table

Click +Add tableto add a new table.

Add a new table in Gemini

A dialog displays prompting you to enter the name of the table and add columns. The Id column is created automatically, providing a unique ID for the table that can't be edited or deleted.

Edit a table

Click a table in the app structure to edit it.

Click a table to edit it.

The Edit table dialog displays:

Edit table in app structure with Gemini in AppSheet

As shown in the previous figure, you can edit the table by doing one or more of the following, then click Saveto save your changes:

Edit the table name by clicking adjacent to the table name.
Add a column by clicking + Add column. Enter the column name and select a type from the drop-down. If you select Single select or Multi select ( Enum ), you'll be prompted to add one or more option values.
Edit a column name or type, or edit single- or multi-select option values.
Note: The Id column provides a unique ID for the table and can't be edited or deleted.
Delete a column by clicking adjacent to the column. You'll be prompted to confirm the operation.
Delete the entire table by clicking in the upper right corner of the dialog. You'll be prompted to confirm the operation.

Example: Edit a table

Let's add an Image column to the Inspections table:

Click the Inspections table in the app structure to edit it.
The Inspections table dialog displays.
Click + Add Columnand enter Image for the column name and type.
Click Save.

The Image column is added to the Inspections table.

Image column is added to Inspections table

Next, you'll create the app and open it in the AppSheet app editor.

Step 3: Create and customize your app

When you're ready to create your app, click Create app.

Gemini creates your app and opens it in the AppSheet app editor, where you can preview, customize, and share your app.

Try out your live appin the welcome screen, and then click Customize with AppSheetto go to the AppSheet app editor.

Gemini creates your app using an AppSheet database and includes sample data that may be inaccurate. Before you use your app, remove the sample data.

What's next?

Was this helpful?

How can we improve it?