Categorize information using AI

This is a preview release of Gemini in AppSheet Solutions. See Track and manage feature releases. Preview offerings are intended for use in test environments only. This feature is not recommended for use in production apps. For questions or assistance with this feature, contact AppSheet Support.

Gemini in AppSheet Solutions (preview) requires an AppSheet Enterprise Plus account.
 

Categorize information based on a predefined set of categories using AI by adding the Categorize AI task in an automation.

See also:

Get started

Step through a quick start to build your first automation using AI to extract information from a car photo and categorize the car by body style. See Quick start: Build your first automation using AI.

Add and configure the Categorize AI task

To categorize information based on a set of predefined categories, add and configure the Categorize AI task by performing the following steps.

For the preview release, you must turn on Gemini in AppSheet Solutions in each app where you want to use AI in automations.
  1. Add the Categorize AI task to a bot, as described in Add a task to a bot.
  2. Configure the Categorize AI task by using the settings described in the following table. 
  3. Save the app.

Setting

Description

Task type

Select AI task.

Table

Table defined in the event and used by the task. See Tables: The Essentials for more information about tables.

AI task 

Type of AI task. Select Categorize.

Input columns

Add one or more columns to use as input to the AI task, up to a maximum of 10. Click Add and select a column from the drop-down.

Basic column data types and virtual columns are supported. 

The following data types are not supported:

Note: Ref type and List type columns are not supported at this time. 

Output

Select one of the following:

  • Save to table to save the extracted information to the table in your data source.
  • Return value to guide AI responses without storing the results in your data source.

For best practices when saving content, see Manage updates to row data by multiple bots.

Then, select the column that defines the categories. Must be an Enum type column that defines the allowed category values. For example, you might have a column called How expensive? that is an Enum type with the following values: Inexpensive, Moderately expensive, Expensive,Other

Additional instructions

Recommended. Do the following:

  
  • Describe in more detail the requirements for each category value.
  • Indicate what values to set if results are not known.
  • Ensure that any recommended values match the type and format of the column, for best results. 

Supports up to 1000 characters. 

For example:

Inexpensive: Less than 10 dollars
Moderately expensive: Between 10 and 50 dollars
Expensive: Over 50 dollars

Other: Not sure of value

Note: Specifying a value that is not defined in the Enum type column selected for the Output setting may cause unexpected behavior unless you allow other values when configuring the Enum column properties.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Main menu
12903084659424524179
true
Search Help Center
true
true
true
false
false
false
false