Create apps using Gemini in AppSheet

Gemini in AppSheet is being rolled out gradually and is currently available to AppSheet Publisher Pro, AppSheet Starter, AppSheet Core, AppSheet Enterprise Standard, and AppSheet Enterprise Plus stand-alone accounts. Alternatively, if you are a Google Workspace customer, you can request access to the Gemini in AppSheet Chat app by contacting your AppSheet Sales representative.

Gemini, an AI-powered collaborator in AppSheet, lets you create an app by describing your idea using natural language. 

 For example, you might give Gemini a description for an app that manages facility inspections. Gemini returns an app card that you can use to design the final inspection app, as the following diagram shows:

The following sections describe how to create apps using Gemini in AppSheet:

• Access Gemini in AppSheet
• Step 1: Describe your business process
• Step 2: Create and customize your app
• What's next?

See also the Gemini in AppSheet FAQ.

Users with administrator privileges can disable the AI-assisted app creation feature by following the steps described in Turn Gemini in AppSheet on or off. The setting is applied at a team level so if you have multiple teams, you will need to disable it for each relevant team.

Access Gemini in AppSheet

To access Gemini in AppSheet:

1. Access My Apps:
   • Sign in to AppSheet. My Apps is displayed, by default.
   • Click My Apps in the top navigation. 
   • Select My Apps from the account profile drop-down.
     
     

   For more information about the My Apps page, see Explore the My Apps page.

2. Click + Create > Start with Gemini.

The Gemini in AppSheet chat interface displays prompting you to describe what you want your app to do.

Create your app using Gemini in AppSheet in two steps:

• Step 1: Describe your business process.
• Step 2: Create and customize your app.

 Step 1: Describe your business process

At the Gemini in AppSheet prompt, describe what you want your app to do. In your description (also called a prompt), provide as much detail as you can.

Here are some examples:

Facility inspections "Manage my inspection team's appointments. Our team conducts facility inspections, and every week we need to check that everything is operating correctly and submit reports. Include an image of the facility along with the date and status of each inspection."

Inventory tracker "I want to track sales of our products in a log, and update and monitor the incoming and outgoing inventory."

Project time tracker "I need to track employees' time. There are projects, and employees log the start and end times for their shift, and there's a timesheet that shows all of the weekly entries for the company."

 

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

Let's use the facility inspections example:

Enter: Manage my inspection team's appointments. Our team conducts facility inspections, and every week we need to check that everything is operating correctly and submit reports. Include an image of the facility along with the date and status of each inspection.

 

Gemini in AppSheet responds with an app card:

In this example, Gemini in AppSheet performed the following:

• Created the following tables to keep track of your data (similar to tabs in a spreadsheet): Facilities, Inspections, Inspectors, and Reports.
• 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: Facility Id, Inspector Id, Date, and Status.
• Added links between tables. For example, in the Inspections table, the Facility Id column links to the Name column in the Facilities table, and the Inspector ID column links to the Name column in the Inspectors table, 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.

Next, click one of the following:

• Create app to create and customize your app.
• Start over to discard the current app structure and start over. 

Step 2: Create and customize your app

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

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

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

Gemini in AppSheet creates your app using an AppSheet database and includes sample data to get you started. Before you share your app, you might want to edit or delete the sample data.

What's next?

• Explore the app editor
• Explore the app preview
• Share your app with users
• Turn Gemini in AppSheet on or off
• See also the Gemini in AppSheet FAQ