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.
Access Gemini in AppSheet
To access Gemini in AppSheet:
- 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.
-
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
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.
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:
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
, andReports
. - 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
, andStatus
. - Added links between tables. For example, in the
Inspections
table, theFacility Id
column links to theName
column in theFacilities
table, and theInspector ID
column links to theName
column in theInspectors
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.