Step 1: Create Your App with Gemini

Provide Gemini a description of your app (e.g., a Library to manage books, a Retail Catalog to classify products, or an Inventory Tracker to monitor stock).

• Gemini suggests tables; keep only what you need.

• Customize columns for details Gemini can extract from images (e.g., title, author, ISBN, SKU, or other metadata).

• AppSheet generates a default view with sample data.

Step 3: Connect Apps Script to Gemini

1. In Google Drive, create a new Apps Script project.

2. Rename it to match your app (e.g., Gemini Book Tracker).

3. Set up the script file where Gemini calls will be made.

Step 5: Automate with AppSheet Bots

Set up a bot to trigger Gemini when new images are added:

• Event: New Photo Taken

• Source: App

• Target Table: (e.g., Products, Certificates, or Books)

• Data Change Type: Add only

Task: Upload Image of Book

• Project: Select your Gemini Apps Script project

• Function Name: Choose the relevant analyze function (e.g., analyzeImage)

• Function Parameter: Map the parameter to the Image column.

• Return Value: Enable → Object.

Output Mapping: Map Gemini’s extracted data (e.g., title, author, SKU, expiration date) to the table columns.

Final Step: Result

Gemini analyzes the uploaded image and writes structured data back into your table with the proper AppSheet types applied.